Skip to main content
Solved

Import Scenario: Update Item Class UOM


AWelty24
Jr Varsity II
Forum|alt.badge.img

Howdy all,

Looking for some input on an import scenario that isn't updating a Base Price UOM value at the Item Class level (even though that’s the mission of this import scenario)

The import scenario appears to run successfully but the data are not updated.

The business mission is to update the Item Class Base/Sale/Purchase UOM values to match a specific Item Base UOM value. In the screenshot you can see that the goal is to update the Item Class that starts with "350MISC" such that its Item Class Base/Sale/Purchase UOM values are set to "LB" rather than "EA".

The screen shows that the import was successful but the Item Class UOM values are not being updated.

What’s a good way to troubleshoot when the scenario returns a successful result, but the field isn’t updated? 

 

Also, maybe this import scenario is too abbreviated and perhaps this is the root cause:

 

Any pointers would be great. 

Best answer by AWelty24

I got this worked out and wanted to share.

Tagging the wonderful @laura01 for pointing me in the right direction.

First, you are right. I didn’t have everything “active” that should be set to active.

Second: I learned that Acumatica actually recommends mapping on Item Class Description rather than Item Class CD. This is counter-intuitive but it does seem to work. (Could this be related to the Item Class CD masking? Maybe that makes it hard to match.)

 

 

Third: seems like it also needed me to map the Availability Calculation. In this case there was only one available value so it was ok for me to define that within the mapping.

 

Thank you so much for pointing me in the right direction and catching that mistake!

Hope this helps others in the future.

Arline

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

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3044 replies
  • October 19, 2022

Hello

It looks like Class ID line needs to be Active on the Import Scenario.

 


AWelty24
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 17 replies
  • Answer
  • October 21, 2022

I got this worked out and wanted to share.

Tagging the wonderful @laura01 for pointing me in the right direction.

First, you are right. I didn’t have everything “active” that should be set to active.

Second: I learned that Acumatica actually recommends mapping on Item Class Description rather than Item Class CD. This is counter-intuitive but it does seem to work. (Could this be related to the Item Class CD masking? Maybe that makes it hard to match.)

 

 

Third: seems like it also needed me to map the Availability Calculation. In this case there was only one available value so it was ok for me to define that within the mapping.

 

Thank you so much for pointing me in the right direction and catching that mistake!

Hope this helps others in the future.

Arline


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2527 replies
  • October 21, 2022

Thank you for sharing your solution with the community @AWelty24 !


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