on 07-16-2012 5:52 PM
Hello,
I am trying to understand how the SAP system assigns payment amount to an invoice and calculates residual payment, please let me know the correct logic.
Invoice amount: $45000
Payment amount: $50000 ( which comes thru wire and posted thru F-28 on account )
1) Customer sends payment advice information which in the above case for $20000 to be applied against $45000 invoice out of the payment amount $50000.
Now we create a payment advice for $20K with reference to Invoice doc.
In F-28 when we select the above payment advice, system selects both payment line of $50k and invoice line of $45K, comes up with a residual amount of -25,000K (?) .
2) If the payment advice was for $25000 then in F-28 the residual item is shown as +20000$, and the payment line is not selected or highlighted.
The posting amounts in both the cases also differs completely.
From what I observed if whenever the residual balance is more than 50% of the payment amount system selects both the invoice and payment lines and comes up with a negative residual balance.
What I would like system to do is apply the payment amount against the invoice line only and not come up with a negative residual balance. I know if we get the gross amount populated in payment advice the above is possible.
For that I think we need put in an enhancement since SAP doesn't populate the gross amount in the payment advice by default. ( Not sure if I am wrong here)
Please explain the rationale behind the above system logic, I think this is standard behaviour, but I am trying to understand it in the correct way.
Attached is the scenario screenshots.
Thanks,
Vamsi
Hello Vamsi,
Logic for residual payment is like this:
1.Define Reasons code T-code -> OBBE
2. Define reason code conversion version T-code -> OBCR
3. Define conversion of payment difference reason code -->OBCS
After these above configuration you have to assign the account determination
3. over payment/under payment
Define account for payment different --> OBXL (it will ask you chart of account)
4. Cash Discount
Define account for cash discount granted --> OBXI
Thanks and Regards,
Mangal Modi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for the reply.
I am actually looking at the reasoning behind the above system behavior. The above steps you mentioned are required for posting payment differences via reason codes to different accounts.
I am trying to find a convincing logic behind why systems calculates residual balance if the cash application amount exceeds a certain percentage of the payment amount.
hope I am clear.
Thanks,
Vamsi
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.