source: sap-budget/README @ 7745113

client
Last change on this file since 7745113 was 7745113, checked in by Alex Dehnert <adehnert@…>, 14 years ago

Instructions on SAPGUI and the accounts

  • Property mode set to 100644
File size: 1.6 KB
Line 
1parser.py is designed to parse a summary report from SAPGUI, combine GLs into
2categories using a user-defined mapping, and produce a summary file with totals
3for each of the categories.
4
5parser.py takes three filename arguments:
6* summary: the SAPGUI summary report (exported using the "download" function)
7* accounts: account/category mapping file. The first column should be the category, and the second should be the account name (specifically, as it appears in the summary report --- which has a column of "     account number - account name" type elements). Additional columns may be included, but will be ignored. This may be useful for leaving notes for yourself about why an account is in a particular category.
8* output: CSV output file
9
10parser.py will read the first two files, write CSV output into the output file, and save some notes (e.g., summary rows that don't look like they have relevant info, accounts without a category, etc.) to stdout.
11
12To use SAPGUI to get the summary:
131) Run "add sapgui; saplogon" from an Athena machine
142) Type "ZSTM" into the box at the top and hit enter to load the summary report settings page
153) Fill in the appropriate fiscal period (probably 12/YYYY) and cost center (into the "cost object (unknown type)" box)
164) Run the report (hit the clock with the checkmark) and click through the warnings
175) Select the "download" option and save the file somewhere relevant
18
19To create the accounts file, you can run the program with an empty one (e.g.,
20/dev/null) and grep for lines starting with "Misc". Modify the text you get
21from that to replace all the "Misc" categories with useful names, and then
22rerun with that as your accounts file.
Note: See TracBrowser for help on using the repository browser.