Rm Apply
I am trying to build a map to bring in cash receipt and apply it to an existing invoice. I just cannot get past the error below, no matter what I try. If I enter the transaction manually using the exact same numbers, it works fine. The original invoice was for $77 and I am only applying $70 so there is no way that it can be more than the original invoice. I am also setting the values for the discount and write off to be zero in the map itself. Any suggestions?
TEST_CR: Sql procedure error codes returned:
Error Number = 574 Stored Procedure= taRMApply Error Description = Apply Amount (APPTOAMT) + Discount Taken Amount (DISTKNAM) + Write Off (WROFAMNT) is > then the amount remaining on the invoice
Node Identifier Parameters: taRMApply
APFRDCTY = 9
APFRDCNM = PMT00000001939840
APTODCTY = 1
APTODCNM = 7001122334
Related Error Code Parameters for Node : taRMApply
APPTOAMT = 70
DISTKNAM = 0
WROFAMNT = 0
Error Number = 664 Stored Procedure= taRMApply Error Description = Apply To Amount (APPTOAMT) is > than the amount remaining on the payment/return
Node Identifier Parameters: taRMApply
APFRDCTY = 9
APFRDCNM = PMT00000001939840
APTODCTY = 1
APTODCNM = 7001122334
<taRMApply>
<APTODCNM>7001122334</APTODCNM>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<APPLYDATE>2016-10-31</APPLYDATE>
<APPTOAMT>70</APPTOAMT>
<WROFAMNT>0</WROFAMNT>
<DISTKNAM>0</DISTKNAM>
<GLPOSTDT>2016-10-31</GLPOSTDT>
<APFRDCNM>PMT00000001939840</APFRDCNM>
</taRMApply>
TEST_CR: Sql procedure error codes returned:
Error Number = 574 Stored Procedure= taRMApply Error Description = Apply Amount (APPTOAMT) + Discount Taken Amount (DISTKNAM) + Write Off (WROFAMNT) is > then the amount remaining on the invoice
Node Identifier Parameters: taRMApply
APFRDCTY = 9
APFRDCNM = PMT00000001939840
APTODCTY = 1
APTODCNM = 7001122334
Related Error Code Parameters for Node : taRMApply
APPTOAMT = 70
DISTKNAM = 0
WROFAMNT = 0
Error Number = 664 Stored Procedure= taRMApply Error Description = Apply To Amount (APPTOAMT) is > than the amount remaining on the payment/return
Node Identifier Parameters: taRMApply
APFRDCTY = 9
APFRDCNM = PMT00000001939840
APTODCTY = 1
APTODCNM = 7001122334
<taRMApply>
<APTODCNM>7001122334</APTODCNM>
<APFRDCTY>9</APFRDCTY>
<APTODCTY>1</APTODCTY>
<APPLYDATE>2016-10-31</APPLYDATE>
<APPTOAMT>70</APPTOAMT>
<WROFAMNT>0</WROFAMNT>
<DISTKNAM>0</DISTKNAM>
<GLPOSTDT>2016-10-31</GLPOSTDT>
<APFRDCNM>PMT00000001939840</APFRDCNM>
</taRMApply>
Answers
Pieter,
Believe the errors.
Error 574 is telling you that the amount you want to apply ($70) is more than the amount remaining for that document. So perhaps the original invoice was $77, but in order to get this error you must have already applied something against this invoice to take the amount remaining to be less than $70 currently.
Error 664 is telling you that your amount you are apply, $70, is more than the amount left on the payment itself. So while the payment was originally $70 (from what you said), it has already been applied to something and so no longer has 70 remaining.
You can verify this by going into GP and looking at the apply information for both items.
If you still have issues, you would need to submit a support incident to eOne or Microsoft (since it is their node/logic).
Believe the errors.
Error 574 is telling you that the amount you want to apply ($70) is more than the amount remaining for that document. So perhaps the original invoice was $77, but in order to get this error you must have already applied something against this invoice to take the amount remaining to be less than $70 currently.
Error 664 is telling you that your amount you are apply, $70, is more than the amount left on the payment itself. So while the payment was originally $70 (from what you said), it has already been applied to something and so no longer has 70 remaining.
You can verify this by going into GP and looking at the apply information for both items.
If you still have issues, you would need to submit a support incident to eOne or Microsoft (since it is their node/logic).
I just entered/posted the invoice in our test GP system, then ran the map so there is no way that anything is applied to it. If I could, I would have sent you the screen shots as well to proof it. We will play with it some more and book a case if we cannot get past it.
If everything is as you believe it to be, then you’ll want to log a case with Microsoft since the business logic is theirs.