SMR Tool v2.5 dated 01.01.2022 || Generate SMR with fully automated Tool

Incase of Any Issue with SMR Generation feel free to contact through potools1@gmail.com with INPUT Files and Office PINCODE.

Subscribe PoTools https://bit.ly/3zhuenp

What's New in SMR v2.5 dated 01.01.2022?

SMR Tool Logo added, Progress bar added & Configuration window modified.
Total Receipts & Payments from external rough excel(Recommended)/SAP File(Not Recommended)
Bank Attached Office added.
ECB Memo number added automatically
Quick access Function added.
Validation added for ABCDE statement.
Simplified and Fully automated.

Video Tutorial :

Function Keys:

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

Rough - Total Receipts /Payments

Reports Requirement:

FAGLL03.xlsx
MB51.xlsx
MB5B.txt

How to Generate Reports in SAP?

1. Generation of FAGLL03.XLSX

Invoke FAGLL03 Tcode in SAP module
Enter GL 4867100000 & 4867100010
Date for previous month i.e 01.11.2021 to 30.11.2021
Custom Selection (Ctrl+F1) Enter Profit Center from SO profit center to last BO profit center as shown in the below image
Execute (F8)
In List > Export to Spreadsheet and Save as FAGLL03.xlsx

2. Generation of MB51.XLSX

Invoke MB51 Tcode
Enter Plant and Storage Location
Choose Layout as /BHARUCH and Press F8/Execute
In List > Export to Spreadsheet and Save as MB51.xlsx

3. Generation of MB5B.txt

Invoke MB5B in SAP Module
Enter Company Code, Plant and Storage Location
Enter Selection date as first date of month i.e 01.11.2021
In category untick Without Opening and Closing Stock in 1st and 6st Option
Tick totals only non-hierarchical representation.
Press F8/ Execute
In list >Save >File >unconverted
Save as MB5B.txt

Report Generation over.

Download Supporting Files and Install
Download SMR Tool v2.5 and Paste it anywhere in PC
All the above three reports Paste into inside SMR Tool Folder with the name of SMR as shown in the image.
Execute the Tool and Configure Minimum, Maximum Cash, Authorized Stamp and Revenue Balance, Cash Office Name and Pincode.
Back to Main Screen of the Tool
Enter SMR Period ie 01.11.2021 to 30.11.2021
Enter SO Balance- Opening balance of 01.11.2021 and BO Balance Sum of Opening balance of 01.11.2021 of all BOs under AO.
UPLOAD

SMR Tool v2.5 dated 01.01.2021 Snapshots

Download Latest version @ https://www.potoolsblog.in/2024/06/smr-v41-dated-08062024-spm-monthly.html