Skip to main content
Answer

Import Scenario for Payments to an order

  • February 10, 2021
  • 5 replies
  • 699 views

wfilipiak67
Captain II
Forum|alt.badge.img+3

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:

 

Best answer by Naveen Boga

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!!

 

 

 

 

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • February 10, 2021

Hi @wfilipiak67 

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

 

 

Hope this helps!!

 


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • February 10, 2021

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.
 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • February 11, 2021

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!!

 

 

 

 


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • February 13, 2021

Thank you Naveen! 

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • February 14, 2021

@wfilipiak67 Great :)