By using this website, you agree to our Terms of Use (click here)
Hi,
Has anyone been successful importing payments (check or prepayments) while applying the appropriate bills in the same scenario?
With the current attached Scenario, i get the following error: "Error: the system failed to commit the adjustments row."
Any direction is appreciated here.
Ellie,
Below is a screenshot of a import I put together for one of our clients. I had to use the ignore error and make sure the document was on hold when entering the lines.
Hope this helps,
Kurt
Thanks Kurt, definitely looks like the right direction.
After applying the Hold situation to my scenario, it now recognizes the new row but i get an error:"'Reference Nbr.' cannot be found in the system" despite the fact that my reference number clearly exists (see attached image).
I Also tried, to no avail:
- Adding 'Line number =-1"
- Committing/ uncommitting each of the documents to apply rows
- Leaving out the reference row incompletely and saving all while the document remains on hold ( when entering a document manually this is valid)
Note that my scenario is AP and your is AR but hopefully the logic can apply to both.
Any suggestions?
https://timrodman.s3.us-east-2.amazonaws.com/forums/376-AP302000-Import-AP-Payments-1.xml
Ellie,
I went ahead and created a quick AP Payment import using a simple spreadsheet and demo data. Below are screenshots of the import scenario, the actual import, and the resulting payment. This was a simple payment that only applied to a single bill. The big thing was unchecking the Commit checkbox on the document type and ref number in the documents to apply. I'm sure if you are trying to apply a payment to multiple bills then you will need to play around with the Line Number counter.
Also, in the demo data the AP preferences have new documents on hold so I didn't need the first Hold=True.
Hope this helps,
Kurt
Got it working! Thanks Kurt, your suggestions helped.
For for some reason the import scenario errors when i try to change the document to Hold=False and says that the amount is not balanced (although they actually are balanced...), so i removed that part and it now works even for multiple documents (I can later manually remove the hold without error).
Here is a screen shot of the working version for anyone else that can make use of it:
@ellie I see this post is VERY old, but I'm hoping against hope that you still have access to this Import Scenario. Can you send me a screenshot please? I'm unable to see the screenshot in this post, it's just too small and zooming it isn't helping. I would really appreciate it!
@begreene The scenario may have changed a little bit over the years, but at core should be the same. Does the below screenshot render any better?
@ellie Thank you! A little better, but still really hard to read. Would you mind emailing it to me? My work email is bgreene@xkzero.com. I appreciate it!!
@begreene Just making sure you are aware that you need to click on the image? When you do that it opens separate in full resolution. Let me know if that did not work.
@ellie I had tried that w the original image and it didn't help, so I didn't even try it w the newer image...now I have, and it's perfect...thank you! 🙂
Awesome! I always wondered if this was possible to do with an Import Scenario.
Online Members
