cancel
Showing results for 
Search instead for 
Did you mean: 

Residual Item Posting Logic

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Any inputs please.

Thanks,

Vamsi