Skip to main content
Solved

Customer Overpayment Payment

  • 23 September 2021
  • 9 replies
  • 1202 views

Forum|alt.badge.img

We have had a few instances where the customer overpays the invoice(s) by $0.01

How can this penny be addressed without having to make a .01 invoice to write it off?

Thanks for any help!

Best answer by markusray17

You can make the amount paid 0.01 cent higher and make the write off amount -0.01. You will get an error when the amount paid is higher than the balance on the document but once you put the negative write off amount in it should go away. 

View original
Did this topic help you find an answer to your question?

9 replies

Forum|alt.badge.img+5
  • Jr Varsity II
  • 237 replies
  • Answer
  • September 23, 2021

You can make the amount paid 0.01 cent higher and make the write off amount -0.01. You will get an error when the amount paid is higher than the balance on the document but once you put the negative write off amount in it should go away. 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 14 replies
  • September 24, 2021

That does it! Thanks alot.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 14 replies
  • September 25, 2021

After checking the customer details the invoice where this -.01 was applied as a writeoff now shows as a balance owing of .01. 

Was hoping this would clear this invoice as closed.

Any ideas?


Forum|alt.badge.img+5
  • Jr Varsity II
  • 237 replies
  • September 27, 2021

You need to make sure the amount applied is 1 cent higher than the balance of the document when you are doing a negative write off.

 

if the balance is 300(for example) and they paid 300.01 then you should set the Amount Paid to 300.01 and the write-off to -0.01. I’m guessing you set the amount paid to 300.00(the balance of the document which the system will default to) instead of 300.01 which would result in only 299.99 being applied to the document. 


Forum|alt.badge.img
  • Jr Varsity III
  • 41 replies
  • May 17, 2022

This creates an open payment record and the AR is still showing with a status of open.  How do you clear those?


Forum|alt.badge.img+5
  • Jr Varsity II
  • 237 replies
  • May 17, 2022

A payment is open if you still have an open balance on it. Which means you didn’t do the application correctly. You can either reverse the application and fix it or you can just write off the remaining balance on the payment.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • May 17, 2022

Hello, Have you considered using the Write-Off features of Acumatica? The write-off screen writes off without having to create invoices for $.01 (or any amount). This process also makes it easy to write off ALL small balances/small credits at the same time, with just a few clicks.


Forum|alt.badge.img
  • Jr Varsity III
  • 41 replies
  • May 18, 2022

Thanks, Mark..  I get it now.  Appreciate the help.  I entered the amount paid in the header, but didn’t catch in the original explanation that it needs to be entered as the amount paid on the detail grid as well.


jyounes
Jr Varsity II
Forum|alt.badge.img+1
  • Jr Varsity II
  • 59 replies
  • May 26, 2022

I get this error with an invoice payment import, it has happened about once a month.  My work around has been just to decrease/match the invoice but then my remittance is short a penny so I need to do a Debit memo for .01.  

Does anyone know any import script/formula that would put any excess invoice amount into being written off?

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings