Monday, November 28, 2011

eConnect error 570

Error No 570, Amount to apply (APPTOAMT) is larger than the invoice amount

Sometimes you will get this error when you are calling the eConnect method taRMApply , this issue could occur if your trying to apply amount grater than the original invoice amount of an invoice.

System will check the applied amount which been pass to the taRMApply method against the original invoice amount (ORTRXAMT) in the RM Open table (RM20101), if the applied amount > original invoice amount then system will throw eConnect 570 error

Actually this issue will not occur in  Microsoft Dynamics GP , because if you try to apply cash document which has amount grater than the invoice amount, GP system will partially apply the cash receipt amount . e.g. if the invoice amount was 560 USD and you applied 1000 USD cash receipt , GP will apply 560 USD to the invoice and the cash receipt will have remaining 440 USD can be applied to other invoices. If you try the same scenario above with eConnect system will through an error "Amount to apply (APPTOAMT) is larger than the invoice amount" to work around this issue you need to use the following logic:

Before apply the cash receipt amount to an invoice , you need to compare the invoice amount and with cash amount.

If the cash amount >= invoice amount then
applied amount =invoice amount
Else
applied amount =cash amount
End If

No comments:

Post a Comment

SSRS - How to Parameterizing the SQL Query

We need to create separated dataset to handle the pre defined list in that dataset we will use simple select statement to define the li...