 |
The SAP General Ledger Macro is an example of a General Ledger batch generated from a standalone Payroll System. The macro converts a csv file into the SAP format making it ready to upload in SAP.
Problem: In this instance the payroll system is separate from the accounting package and as a result a manual payroll journal was required each month.
To convert this batch manually after each month took a solid day as there was at least 4500- 6000 lines each month.
One issue caused by doing it manually meant if you cut one line too many, your batch would not balance and you would have to start again.
When the regular payroll officer went on leave, it meant the journals were not done as it was too complex to teach anyone.
This then caused problems with the Accounts Department as month end could not be completed.
Solution: A macro was written to convert the csv file into a SAP format and have all fields in the correct column plus adding several user-define fields.
This solution meant even if the payroll officer was on leave anyone could run and convert this file. The aim was to automate the file ready to upload into SAP.
From exporting the batch from the Payroll System into Excel and executing the macro takes less than 1 minute and it was ready to upload into SAP.
 Step 1 |
 Step 2 |
 Step 3 |
 Step 4 |
