Skip to Content
0
Jan 17, 2023 at 04:03 PM

How to view GL accounts of 100s of GR/IR documents binded into 1 invoice?

47 Views

Hello all,

My question is how to view GL accounts (in debit side of GR documents) of 100s of GR/IR documents combined into 1 invoice? (we use R3)

The purpose to find GL accounts of GR documents is to reconcile them for the end-year/periodical financial audit.

The SAP system that my company is using doesn't have 1 to 1 matching function of 1 Invoice to 1 GR Document.

Rather, as the company is in manufacturing, the current set up combines 100s of GR documents into 1 invoice for manufacturing related invoices (MRP purchases).

But the problem is when trying to find the GL accounts (debit GL accounts in GR docu) and prices taged to each of those GL accounts, I have to open and transfer from Invoice docu to GR docu for each of those 100s of GR/IR documents in 1 invoice, which takes hours of work.

Such process is very inefficient and leaves me virtually impossible to reconcile 1000s of invoices per month.

Conclusively, it leaves me with 2 options:

1. Find inherit SAP function which will allow me to accomplish 1 to 1 matching of Invoice<->GR document.

2. Ask company SAP engineers to develop such function above in current SAP.

Any advice or cases shared will be appreciated.

I would greatly appreiciate everyone's help as I am pulling out my hair with this problem.

Visiualization of current process/problem:

gl-accounts-review.png

Attachments