Skip to main content

Hello there we have a customer who intended to pay for invoices A+B+C+D+E+F...a total of ‘say’ USD50,000. However they made a mistake and paid for eg 45000.00. I want to see the invoices above as paid and a separate entry for the 5K not paid ...not allocated just sitting on the statement until they put it right. I have tried a few options but am not able to get this situation echoed on Acumatica. Obviously I want the bank entry correct so that I can do a reconciliation but I don’t want to part pay a particular invoice as this was not the actual scenario. I thought maybe I should raise a credit note !!!! and then re-invoice to take care of this but it seems very clumsy to do this.

 

Best Regards

 

Malinda

@Malinda278 i would record the payment as it was provided to you and let the open balance sit until the remaining balance is paid.  it sounds like they did in fact underpay in this scenario if the total of the invoices was 50K and they only paid 45K.  if it was an overpayment, you could let that sit on the customers account as a credit but it doesn’t seem like that would apply in this case.

 


Hello Iqra is there anyway of just leaving the unpaid bit unallocated do you think or do you have to leave all of it  on the system as it was paid an completely unapplied?

 

Thanks Malinda


Hi @Malinda278 were you able to find a solution? Thank you!


Hello, 

There is an option on the customer profile for Statement Type, or Statement Format with the choices.
1. Open Item: Lists all details of open and partially paid and partially applied invoices, memos, and payments) 

  1. Balance Forward: this statement format rolls open, unpaid balance from prior period documents forward in one lump sum. You will see only unpaid amount from prior period and won’t be able to see the details of unpaid items on the statement report. 

I think the Balance Forward statement format is what you are looking for.

When entering the short payment, you may leave it unapplied on the customer’s account. AR Aging reports will show open invoice details and unapplied payment.

When entering the short payment, you may apply/pay in full and leave the balance on one invoice. Or you may distribute unpaid balance proportionally across all invoices. Either way the bank reconciliation will correctly show the payment and bank account can be correctly reconciled. 
 

I don’t recommend crediting the original invoice balances and  introducing a new debit memo for the unpaid balance because doing so makes the customer history more difficult to understand. Your customer will see strange new document on the statement and may question it.

I hope this helps you.

 


Hi, People left the solution already, just interested what is the purpose you don’t want to use partial payment against one invoice? Can I ask?


We have the same issue and need an answer as well. Our Customers will take deductions not related to the Invoice(s) they’re paying. Therefore we want to pay all the Invoices and leave an open amount with a reference for what it’s for to be reconciled later.


We have the same issue and need an answer as well. Our Customers will take deductions not related to the Invoice(s) they’re paying. Therefore we want to pay all the Invoices and leave an open amount with a reference for what it’s for to be reconciled later.

 

Same here - we just had a customer take some made up credits on their cheque and not sure how to best handle this situation. I don’t want to leave any of the invoices they fully paid as short paid but at same time I need the payment amount to match the cheque for our bank account reconciliation 


Reply