Hi Team,
I have a scenario in AR, I need to derive a new activity in AR, which should tell us the payment made by the customer is Over/Short/Exact Payment.
Im checking in BSEG table, by taking BELNR and the corresponding WRBTR but not sure how to match the Invoice amount to paid amount.
Suggest me a possible way to match the Invoice & Paid amount.
Thanks
Chanti
Hi @chanti.p,
this is a comparison rather then an activity creation in my opinion. I would use CASE WHEN to compare the paid amount to the to-be paid amount. Something like this should work to classify each case: CASE WHEN paid amount = to-be paid THEN 'Exact' WHEN paid amount > to-be paid THEN 'Short' ... ELSE... END
Best
Kevin
Hi Chanti,
This is not as straightforward as it seems.
You could match invoices with clearing documents using BSEG.AUGBL and BSEG.BELNR (with BSEG.KOART = 'D').
To identify these 3 scenarios would be basically comparing the WRBTR values. It gets tricky when Payments are not correctly linked to the invoices (which is a very common issue).
Best,
Gabriel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
