I have the following flow for logistic costs:
- I create a purchase order by month for my warehouse handler containing 1 line item with a quantity of 1600.
- Everytime I ship goods in my sales flow I create a shipment cost document that generates a goods receipt in that purchase order
- By the end of month I receive my invoice that is approximately for 1600 shipments, which means 1600 goods receipt.
When I post the invoice I have the issue of more than 999 lines for the accounting document. This is basically a problem with the GR/IR account.
The purchase account is activated in my company code, so everytime I make a goods receipt I debit my cost and credit this GR/IR account, this account is then cleared during the invoice process (debit GR/IR and credit supplier).
This account must be managed on line item basis and with open items management, this is why the invoice will try to create 1600 lines in the accounting document.
Is there a way to summarize booking on this account in the invoice that would also manage to clear all the goods receipts ?