Skip to main content
Solved

Import Scenario: Sales Order Item Description based on Inventory ID

  • October 22, 2024
  • 3 replies
  • 70 views

Hi All,

 

I am creating an import scenario for sales orders and after a lot of troubleshooting I was able to get to the end of it without any errors, however after importing my data I saw that Line Description is coming up as blank.

I believe that is because of the highlighted info on the screenshot below where I set it to Null. However I don’t know how else to get the data that I need to be in the false statement.

My if statement is supposed to bring the item description from my import file if the item id is “!” (exclamation mark) otherwise, just use the description that the system uses based on the inventory id. Essentially, in this situation, the “!” is a comment item, so it should change as per the import file, otherwise it’s an actual stock item, thus should use the description set in Acumatica.

I tried looking into the internal fields but could not find the name of the field to bring it up, if it is that simple.

Does anybody have an idea?

 

Thanks!

Clauber

 

 

Best answer by jib87

Assuming that “!” represents specific SKU that exists on Acumatica, try this:
 


So, if the Line order detail inventory id matches what is specified, it will use the Description from the source. Otherwise, it will use the description of the item from Acumatica

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

3 replies

Forum|alt.badge.img
  • Varsity I
  • 41 replies
  • Answer
  • October 28, 2024

Assuming that “!” represents specific SKU that exists on Acumatica, try this:
 


So, if the Line order detail inventory id matches what is specified, it will use the Description from the source. Otherwise, it will use the description of the item from Acumatica


  • Author
  • Jr Varsity II
  • 9 replies
  • October 29, 2024

Hi @jib87

 

Thank you very much for your answer, it worked perfectly for my scenario! Ans yes, you assumed correctly.

I tried so many fields and couldn’t figure out which one should I use.

 

Thanks again for taking the time to help me out.

Clauber


Forum|alt.badge.img
  • Varsity I
  • 41 replies
  • October 30, 2024

Sounds great! Glad to help @cvianna 


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