SMR Tool v3.5 dated 04.02.2022 Download Link & Working Procedure

SMR v3.5 dated 04.02.2022:

As per requests received from various end user, the following modification done.

• Section II Page Modification done for ABCDE Statement for both Cash and Stamp.
• PA17A - Page No.2 Data More accurate i.e 100% accuracy arrived.
• Material Master Modification option enabled - Press F1 from SMR Tool v3.5. (Auto populated in version 3.0)
• -Ve symbol has been removed from Cash Remittance / Cash Sent to BO
• + Removed from Stamp Received/Sent if it is Nil

FAQ v1.1

1. Runtime Error INVALID PROPERTY VALUE '380' during Cash Uploading

• Check the Input File > FAGLL03.xlsx should have GLs 4867100000 4867100010
• Redownload from SAP - FAGLL03 tcode using the above GLs.

2. Please "Run Start Database and execute this from Server"

• SMR Tool Latest version should be run from POS Server if the Generation of 2nd Page is checked in Configuration.

3. Invalid Property Value during Stamp Uploading

• Error Fixed

Function Keys added in SMR Tool:

F1 - MaterialMater Configuration.

F3 - Upload Total Receipts and Total Payments from Rough.XLSX. (Format given below).
F4 - Upload SMR data from Input Folder.
F9 - Check Total Receipts & Payment with Closing Balance.
F10 - Generate Reports.

What's New in SMR Tool V3.0?

1. SMR Tool v3.0 designed for generating SMR Report of both pages Section II and PA17A.
2. Option for changing Input SMR folder location.
3. Either EOF or BOF is True while Collecting Stamp Balance data.
4. Material Maintenance options added and its auto-populated when needed. 
5. Configuration Window Changed as per requirement & validation.
6. Copy GLs added for copying GLs for generating FAGLL03 in SAP for the purpose of generation of PA17A - next page SMR.
7. Section II alone can generate using the version v3.0.

Watch the Video Till End for better understanding (Just 5mins will save your entire day of work in c/w SMR)

How its work and what kind of reports given?

SMR v3.0 Deigned for generation of Section II alone or Section II alongwith PA17A. This can be configured under Configuration Window. Hence, the following Input needed based on requirement of SMR

Reports requirement for Generating Section II alone?

• Can execute anywhere and any PC. No need POS Server.
• FAGLL03 - DOP Cash & Cash in Transit of AO & its BO. (For calculating CB of AO and BO & Cash received/Sent from Cash Office/Bank & BOs). FAGLL03.xlsx
• MB51 of concern AO Storage Location. (for Calculating Stamp CB of AO).MB51.xlsx
• MB5B of concern AO for the Start date of SMR Period. (for the purpose of OB of Stamp Balance). MB5B.txt Read More

Reports requirement for generation of both pages of Section II and PA17A?

• Should be executed from POS Server for collection POS data and information.
• Reports as Mentioned above for generating Section II in addition to the below. (3 Reports)
• Finacle - Common Account Statistical Reports(2Reports)  - Report Number 13 in MIS server. Generate Report in excel format for the current month / corresponding month of previous year.

Naming Structure should be (Year of Start Date).xls & (Year of Start Date)-1.xls | i.e if the start date is 28.12.2021 and end date 27.01.2022 the current period common account statistical report name should be 2021.xls and previous year corresponding month report should be 2020.xls

In default, the report generation in Finacle only with the extension of *.xls. Report generation for same report in different period is allowed by the Finacle Live/MIS Server the time interval of 10mins

• FAGLL03-SAP Reports for PA17A(2Reports)  - Click Copy GLs in SMR Tool v3.0 and Invoke FAGLL03 in SAP Module and Paste the GLs in FAGLL03, the posting date as same SMR Generation period and Profit Center - AO Profit Center alone. Export the report in Excel format which has latest extension of .xlsx. Go Back Change Posting Year with the same date and month

Naming Structure should be (Year of Start Date).xlsx & (Year of Start Date)-1.xlsx | i.e if the start date is 28.12.2021 and end date 27.01.2022 the current period FAGLL03 should be 2021.xlsx and previous year corresponding month report should be 2020.xlsx

Totally, 7 Reports needed for generating Section II & PA17A SMR Report.

Click below link to download the SMR Tool v3.0

Subscribe PoTools Telegram Channel

Subscribe PoTools Youtube Channel

DOWNLOAD

DOWNLOAD SUPPORTING FILES