Skip to main content
Solved

Import by Scenario import is unsuccessful but there is no error message


Forum|alt.badge.img

 

My simple, first Import by Scenario import fails but there is no error message.  I’m not sure where to look.

 

Where do I look?

 

Thanks,

 

Tom

Best answer by BenjaminCrisman

@TomMorris Can you advise on what you’re trying to accomplish with the import? Are you trying to import new records, or update existing records?

I noticed you are using Reference Nbr. for both the reference number of the document, as well as the reference number for the Vendor Ref Nbr, have you tried making a new field for the Vendor Ref Nbr and/or just hard coded it since you are only importing a single line?

Was this document used for the AP Bills used for something else prior? It looks like you are using CustomerID as the Vendor line so maybe there are some out of place references on the mapping?

I’ve attached the import from sales demo ACU Import AP Bills for reference

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

5 replies

riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • 75 replies
  • July 16, 2024

Hello @TomMorris 

Could you please share a screenshot of the import scenario mapping?

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • July 16, 2024

Of course.  Thanks, Rodrigo.

 

 


riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • 75 replies
  • July 16, 2024

Hi @TomMorris,

Thanks for the screenshot. 
Mapping looks fine, I would delete the <Action:Insert> line on top (see first screenshot of the sample scenario mapping as reference) and make sure at the end of the scenario mapping you have the <Action: Save> line (second screenshot):

 

 

 



Hope this helps.


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 621 replies
  • Answer
  • July 16, 2024

@TomMorris Can you advise on what you’re trying to accomplish with the import? Are you trying to import new records, or update existing records?

I noticed you are using Reference Nbr. for both the reference number of the document, as well as the reference number for the Vendor Ref Nbr, have you tried making a new field for the Vendor Ref Nbr and/or just hard coded it since you are only importing a single line?

Was this document used for the AP Bills used for something else prior? It looks like you are using CustomerID as the Vendor line so maybe there are some out of place references on the mapping?

I’ve attached the import from sales demo ACU Import AP Bills for reference


Forum|alt.badge.img
  • Author
  • Freshman I
  • 10 replies
  • July 18, 2024

Thanks Benjamin.  

The import is reduced to one row as I work to isolate different issues I have encountered.  I’m Acumatica green. 

I’ll review your comments, see what I can find.

 

Tom


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