Reply from rtuccell on Apr 7 at 5:27 PM Hi
here below some possible solutions:
- to execute of the GL Line item report S_ALR_87012282, the download should be not so difficult
- to create specific Z program to extract MJE in ALV format. This could permit you to create specifc layout for downloading.
- to create an excel macro to clean and import easily the report you're using today.
Please evaluate the better one depending on the basis of your experience, abapper availability, excel knowledge.
Regards
Rocco
| | | ---------------Original Message---------------
From: clangkamp
Sent: Tuesday, March 24, 2015 2:41 AM
Subject: Journal Line Item Extract (S_ALR_87012347) Just Excel Lines, No Formatting
Part of the accounting process is to look at the Trial Balance (generated by F.01), perform adjustments and then upload the result into the company consolidation tool.
In order to check items one always needs to go back to SAP into the accounts.
Theoretically, for a medium sized company, it should be possible just to download all the journals posted in a period and then do a sumifs() total to get from a list of all journals to the actual trial balance. (i.e. year end trial balance + Sumifs on a large excel spreadsheet).
The Journal Line items kind of has the data, but not quite, no Line texts, and the formatting is horrendous. Is it possible to download a list of all journal lines posted in a period (i.e. [17,7,40,50,], [Cur], [Date Posted], [Amt Loc Cur], [Amt transaction cur], [Text], ...
Simple Excel dump?
Any suggestions? |
| Reply to this email to post your response. __.____._ |   _.____.__ |
