Sage 300: sometimes i receive cheques from my customers that is more than the invoice amount, why is it that the software does not allow overpayment on an invoice, maybe there is a way to program the A/R and A/P subledgers to allow overpayments against the invoiced amount

one of my customers outsource his accounting to India and sometimes i get a cheque that is either over the amount of the invoice or I get two cheques paying the same invoice, my system does not allow me to record this overpayment against that invoice, i would like to be able to record those overpayments against that invoice so that when my customers asks for a full report on the amounts paid, i can provide him with all the transactions clearly and on a historical basis.

right now i have to create a suspense account in my G/L and record the double cheques and overpayments which really confuses the customer because he actually do not have any records provided from the indian company, he only gets a report on the total amounts paid, and the inidan company often apply the wrong cheque amounts to the wrong invoices.

i would like to have a clearer audit trail since i am looking at about 200 cheques a month from this customer.

i would like to be able to allow overpayments in my system

by: huey w. | over a year ago | Setup / Environment

I suggest you just record the receipt as "Unapplied Cash". It will then just sit in the AR Account as a credit balance against the customer, and will record in the general ledger as Debit Bank, Credit Debtors. There is no need for any Journal Entries in the General Ledger, and you have a complete record of the customers transactions. Unfortunately it cannot be applied to the invoice no quoted.

by: Margaret I. | over a year ago

1

sometimes i receive cheques from my customers that is more than the invoice amount, why is it that the software does not allow overpayment on an invoice, maybe there is a way to program the A/R and A/P subledgers to allow overpayments against the invoiced amount

Comments