I am working on an assignment where I need to find out customer wise total invoice and payment(Incoming and Outgoing). Dataset = General Ledger
For Total Invoice, I have considered document type RV and posting key (1,12,11,2).
For total incoming payment, have considered Document type DZ and posting key (18 and 8). There are other posting keys against which payment amount are appearing which is very small amount and can be reversal which can be ignored.
Question - There is document type ZX (Atomatic clearing doc.) under which posting key as other clearing, other payable and other receivable, incoming payment and invoice are appearing having bigger amount for a particular customer, which cant be ignored.
Can anyone tell me what are these automatic entries. Am I missing any invoice and payment amount by not considering these numbers. On sample basis, for one particular clearing document I observed that invoice(RV) and Payment(DZ) is appearing in automatic entries(ZX).
Thanking you in anticipation of your cooperation.