A/R Debit Memo - Valid Invoice Balance Required

Epicor ERP 10
1

Our customer made an ACH payment last night, but overpaid the invoice balance due to late payment (late fees). So I created a debit memo, created a misc line charge for “interest earned for late pay” in the amount of $-20.59 to increase the original invoice.

When I go to apply the Debit Memo, I get this message:

image

What does this mean, and how do I get this memo applied? I’m not sure what I am missing here??

Thanks in advance.

2

Still seeking an answer for this if anyone out there can help me get this squared away!

Thanks!!!

3

Hi Kevin,

You might want to check that InvoiceBal and DocInvoiceBal on the IncvHead table actually match.

99% of the time, these are out by a very minor amount of which will cause this issue.

If they dont match, you can get a Datafix from Support.

Many Thanks

1 Like
4

Anytime I’ve encountered this error there has been an issue with two fields on the invoice head table. Most of the times I’ve seen this happen support has provided data fix to update the invbalance and unpostedbal.

2 Likes
5

Thanks for responding guys. I’m not sure where the “invoice head table” is located and how to determine the “invoicebal” and “docinvoicebal”?

Thanks again for your time and assistance!

6

If you can write a BAQ, add the InvoiceHed table and include all fields.

Add a table filter for the invoice number you are working on.

7

Hi Kevin,

You can view in SQL or in a BAQ, table in InvcHead

Many Thanks

8

I have no idea what an SQL or a BAQ is, unfortunately. Is there a more user friendly way to figure this out?

Sorry for the lack of knowledge here!

9

If you contact support, they can help with the query to find the issue. They may end up providing a datafix for you to run.

2 Likes