Skip to main content
Solved

Importing invoices with more than one line items


Hi,

I have created import scenario to import invoces and line items, when i execute prepare and import action for each record from excel a new invoice is created.

In the excel there is only one invoice with 53 line items. But when import is done 53 invoices are getting created.

Following is the image shot of the Import Scenario i have created.

 

 Let me know what is the wrong in the above scenario.

Best answer by Naveen Boga

Hi @miketyson  I have modified your import scenario a bit and processed for 2 records. 

In this case, One document created with 2 lines. Please find the attached import scenario and screenshots for your reference.

 

If you don’t want to place the document on HOLD status, you need add the line in the REMOVE HOLD action in you import scenario.

 

 

View original
Did this topic help you find an answer to your question?

10 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • December 29, 2021

Hi @miketyson  Can you please share your XML format for Import Scenario here.

 


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 680 replies
  • December 29, 2021

Hi @miketyson 

I think the issue is on the Reference Nbr field. Can you please correct the field and check like below?
Attached a sample XML. Please review

 


  • Author
  • Freshman I
  • 4 replies
  • December 29, 2021

Hi,

I tried updating Refrence # and it is giving error.

I have attached the xml.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • December 29, 2021

Hi @miketyson  I have modified your import scenario a bit and processed for 2 records. 

In this case, One document created with 2 lines. Please find the attached import scenario and screenshots for your reference.

 

If you don’t want to place the document on HOLD status, you need add the line in the REMOVE HOLD action in you import scenario.

 

 


  • Author
  • Freshman I
  • 4 replies
  • December 29, 2021

Thanks Naveen creating invoice is working.

What if i want to update the invoice, when i am mapping reference nbr its giving error 

53 items have not been processed successfully. View name: Document.

XML is attached herewith.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • December 29, 2021

Hi @miketyson  Can you please share Error message, which you are getting at Grid Row level.

That will provide the more details about the issue.


  • Author
  • Freshman I
  • 4 replies
  • December 29, 2021

There is no error at Grid Row level

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • December 29, 2021

I don’t see any issue with the import scenario. I have processed 10 records successfully.

Here are the screenshots for reference.

 


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 98 replies
  • December 29, 2021

@miketyson , I have found that setting the AR Invoice numbering sequence to Manual will allow records with the same reference number to create additional lines on the document. 

When importing we usually set this to Manual & then set it back after the import is complete.

 

 


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • December 30, 2021

Hi @miketyson 

Have you got the import working at your end ? 

Happy Holidays,

Regards,


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings