Skip to main content
Solved

Issue with Import Scenario to create Bill Payment and relate bill to the Bill Payment

  • January 5, 2022
  • 3 replies
  • 241 views

HI,

I have prepared the Import Scenario to create bill payment document and then relate the bill document it, the bill payment document is getting created but the bill is not getting related or added and the error returned is 

Error: The system failed to commit the Adjustments row.

I have attached herewith the xml file of import scenario.

Best answer by Naveen Boga

Hi @miketyson  I just worked on it and modified your import scenario, and I can able to create the Bills and Adjustments document as expected.

 

Please find the import scenario below for reference. Hope this helps!!

 

 

 

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • January 5, 2022

Hi @miketyson  I just worked on it and modified your import scenario, and I can able to create the Bills and Adjustments document as expected.

 

Please find the import scenario below for reference. Hope this helps!!

 

 

 


  • Author
  • Freshman I
  • January 6, 2022

Hi Naveen,

Thanks for the solution it helped. With your solution Bill Payment and Bill are getting related but the payment record remains in hold status.

In my import scenario i am unable to find the <Action: Remove Hold> (Remove from Hold) action. Is this due to that. But i can see that remove from hold is inactive in your scenario also, so this must not be the issue.

When i am adding Hold =False then I am getting the same earlier error The system failed to commit the Adjustments row. So i have made that inactive and payment record with related bill is getting created but is in Hold status.

So only remaining is how to remove hold.

Update xml is attached.

 

 


Forum|alt.badge.img
  • Freshman I
  • September 12, 2022

Hi Naveen

I have followed your example as closely as possible but I am still getting the following error: 

An error occurred during processing of the field Reference Nbr.: Error: 'Reference Nbr.' cannot be found in the system. See my scenario below:

Please can you advise where I am going wrong? Many thanks