Skip to Content
0

Report showing audit trail from Purchase Order to Goods Receipt to General Ledger

Jul 22, 2017 at 12:15 PM

84

avatar image
Former Member

example-report-with-reconciliation.xml

I am trying to build a SAP Business ByDesign report that provides an audit trail from purchase order to goods receipt to general ledger and everything works fine except for an inability to join the Goods Receipt Item (ITEM_ID field from Goods Receipt Item Details) to the Source Document Item (Source Document Item field from G/L Account Items).

I can see three possibilities:

1. I have simply missed a field that would provide a direct link either way between the two data sources;

2. I have not come across a tool within the system that would allow me to manipulate the

Source Document Item field from G/L Account Items in order to be able to create a direct link to ITEM_ID field from Goods Receipt Item Details; or

3. there is an oversight in the design of the system that prevents users directly linking general ledger transactions through the procurement process to provide a full audit trail in a single report; if I haven't just missed a field that provides a direct link, why would they design the system to post a concatenated Goods Receipt and Item reference rather than just an Item reference when there is already a Goods Receipt reference avaialble!).

I have attached a workbook reconciling the G/L Account - Line Items report with the same set of variables entered in my customised report. The attachment highlights the problem and shows how manipulation of Source Document Item field from G/L Account Items would overcome the problem if that functionality is available.

Would be great to hear how others have overcome this problem and any advice as to possible solutions will be greatly appreciated.

Thanks,

Simon

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers