Accounts Payable Charge Amount
The CHARGEMNT is not a required field in the GP map, yet the Excel file is looking for it?
A solution to the problem was found after working with Pat, a Live Chat agent. In short, I am using a custom Excel file with the use of a SmartConnect mapping for AP. My custom Excel file isn’t that far off of the one provided, but I remove some values that we do not use in our systems.
To fix Charge Amount, I logged into the Create Payables Transaction mappings and located Discount Taken Amount. I changed this value to a Local Constant of 0. This instantly resolve the issue!
No matter what you do the Charge Amount needs to be equal to the other side of the equation. So check that the values in the other fields mentioned balance out with the Charge Amount.
I did not notice that you responded to this thread. I do not use a Charge Amount field in GP, so if I set it to the total of all of the items would this fix the issue?
I did try setting the Charge Amount value equal to that of the document amount, but that did not work either.
If you would like to submit an answer or comment, please sign in to the eOne portal.