Solved

Import Scenario for Payments to an order

  • 10 February 2021
  • 5 replies
  • 338 views

Userlevel 4
Badge +2

I am trying to import payments from a spreadsheet into the Payments and Applications. These payments are against an open Sales Order. 
I can do this manually but my Import Scenario results in the error mesage “The system failed to commit the SOAdjustments row.”
(yes this is in the demo date, 2020r2, 20.201.0051) 
Thank you in advance for any assistance.
Bill
Here is my Import Scenario:

 

icon

Best answer by Naveen Boga 11 February 2021, 06:41

View original

5 replies

Userlevel 7
Badge +12

Hi @wfilipiak67 

Can you please unselect the Commit checkbox for the below-highlighted lines and verify once.

 

 

Hope this helps!!

 

Userlevel 4
Badge +2

Thank you for the quick response! 
I gave it a try & am now getting a different error. the specified order type & order number cannot be found.  Yet it does exist.
Here is a pic of the error, along with the Sales Order screen.
 

 

Userlevel 7
Badge +12

Hi @wfilipiak67,

I have tried this in my local instance and it is working for me.

I’m assuming that there is some issue with an order. Can you please create a new order and create the payment using the import scenario.

Please find the screenshots for reference.

Hope this helps!!

 

 

 

 

Userlevel 4
Badge +2

Thank you Naveen! 

I was able to get this to “work” on my instance. 

Userlevel 7
Badge +12

@wfilipiak67 Great :) 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved