Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from clangkamp on Mar 24 at 2:36 AM 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. __.____._ |   _.____.__ |
