Over Payment Calculation

SUGGESTED

Hi Dear;

Can you please explain me for the following transactions.

First, I enter a purchase for $5250. Then I pay $250, $2000, then $-2250, then $5250. After pay off, i edit the payment i made for $2000 to $-250 then pay off the rest of $2250. After that I try to change the original invoice amount from $5250 to $3500. After Process, there is a credit message said I'll get $1750 as the credit note then after message said I will get a credit of $3750 instead of $1750. So in the payment module what I've got is the new Original amount $3500, Owing amount $2000 and a credit note of $3750.

In similar case, I get the same credit note as per transactions below:

- Purchase: $5250

- Pay: $250, then $2000, then reverse -$2250, then pay $5250 then i edit the payment of $2000 to -$250 then pay off $2250 then edit the payment of $2250 to -$3000 then pay off again $5250. 

- After pay off, I edit the original purcase to $3500. After Process, there is a credit message said I'll get $1750 as the credit note then after message said I will get a credit of $3750 instead of $1750. So in the payment module what I've got is the new Original amount $3500, Owing amount $2000 and a credit note of $3750.

Can you please explain me how the system calculate the for $3750? Because as per what in the T account, I over paid only $1750.

Thanks for your help. 

  • 0
    I would suggest print the General ledger report on payable or related account and check the Journal entry and reversal entries to track it; or try to call Sage 50 support see if they can help you.
  • 0
    SUGGESTED
    If you have an outstanding amount of 2000 and a credit note of 3750, you have a net credit of 1750 ($2000 - $3750 = -$1750). To adjust this so that only the $1750 credit is displaying, create a cash payment for the most recent payment date, enter $2000 as the payment amount of the outstanding invoice and -$2000 as the payment amount of the credit note for a net payment of $0. Your original invoice should no longer appear as outstanding and the credit note should reflect an amount owing of -$1750.