A valid New Invoice Balance is required

Epicor ERP 10
,
1

We are testing Accounts Receivable Cash Entry. If a customer makes a payment that is (say) $1.00 less than the invoice and we decide to write the $1 off, I intend to use the Write Off function. I have Company Configuration set up to allow up to $25 for both positive and negative write offs.
I am able to check the Write Off checkbox and enter the account number I want to charge to. The $1 automatically fills in and the Unapplied amount becomes zero. But when I attempt to Apply, I receive a Business Logic Error “A valid New Invoice Balance is required”.
We are on the public cloud.

Detail of error:
Business Layer Exception

A valid New Invoice Balance is required.
A valid New Invoice Balance is required.

Exception caught in: Epicor.ServiceModel

Error Detail

Correlation ID: f85830cd-25e3-43c2-935b-11e6798e891b
Message No.: 1
Description: A valid New Invoice Balance is required.
Program: Erp.Services.BO.CashRec.dll
Method: valNewBal
Line Number: 15842
Column Number: 21
Table: CashDtl
Message No.: 2
Description: A valid New Invoice Balance is required.
Program: Erp.Services.BO.CashRec.dll
Method: valNewBal
Line Number: 15842
Column Number: 21
Table: CashDtl

Client Stack Trace

at Epicor.ServiceModel.Channels.ImplBase`1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets)
at Erp.Proxy.BO.CashRecImpl.MassGenerateCashDtl(String pcGroupID, Int32 ipHeadNum, Boolean useDisc, ARInvSelDataSet ds, String& massGenErrorMsg, Decimal& opTotalCashReceived, Decimal& opTotalApplied, Decimal& opUnappliedBalance, Decimal& opTotalMisc, Decimal& opTotalDiscount, Decimal& opTotalDeposit, Decimal& opTotalARAmount, Decimal& opTotalWithhold, Decimal& opTotalWriteOff)
at Erp.Adapters.CashRecAdapter.MassGenerateCashDtl(String pcGroupID, Int32 ipHeadNum, Boolean useDisc, String& massGenErrorMsg, Decimal& opTotalCashReceived, Decimal& opTotalApplied, Decimal& opUnappliedBalance, Decimal& opTotalMisc, Decimal& opTotalDiscount, Decimal& opTotalDeposit, Decimal& opTotalARAmount, Decimal& opTotalWithhold, Decimal& opTotalWriteOff)

What am I doing wrong?

2

Hi Nancy,

Do you have any Directives (BPMs) on the CashRec business object or on any of the Cash-related tables?

3

No. I have no BPMs period.

4

Are you trying to apply the Write Off within the Cash Receipt or have you tried from the separate Write Off command?

5

@nanvdand
May be the write-off option in the cash receipt entry will only work when you have the invoice amount as well.

Example:- Invoice balance is $156. Customer pays $155.
In this case in the cash receipt entry you will enter $155 and apply to the invoice and the remaining $1 will be write-off. This works fine without any error.

If you are trying to do only write-off of $1, then it is advisable to use
"Write off and Adjustment " (Accounts receivables -> general operation -> Write off and Adjustment)

6

Thank you everyone. I have made some progress but it still isn’t perfect. I found that once I have selected the customer’s invoice, and entered the Allocated Amount, checked the Write Off checkbox, and entered a valid GL number (the Write Off Amount automatically fills in), if I click on “Apply” I receive the error. If I click on Select and Apply, I get no error.

Great so far. If a customer overpays by a small amount, I receive a warning, but then I am allowed to write off the difference. It all works great.

If a customer underpays by a small amount, I am able to enter the Write Off Amount, etc. Click Select and Apply and the payment is moved to the Allocate tab. The problem now, is that it shows up as a discount, not a write off. And I have those as two different GL accounts. This happens whether or not I have “Force Discount” button engaged.

Any additional advice?