Solved

Import Scenario Save at Header Level instead of Detail Lines

  • 20 March 2024
  • 3 replies
  • 29 views

Userlevel 4
Badge +1

I am updating Queue times on Released Production Orders that have approximately 10 operations each.  My import scenario is putting the order On Hold, finding the operation ID (@@), updating the Queue time, and removing the Hold.  It does this for all 10 lines on every order.

Is there a way I can set the import scenario to put the order on Hold, update all the lines, then remove the hold?  Instead of Hold-update-RemoveHold 10 times?

icon

Best answer by TatianaDavydova 24 April 2024, 12:55

View original

3 replies

Userlevel 4
Badge +1

 

Userlevel 1

Hi @danielklumpp!
Which version are you using? Starting with 2023R2, the import scenario mapping has the “Execute Action” column. In this column, you can select when a particular action should be executed: for each detail line, only for first detail line, or only for last detail line. This can be useful when you put documents on hold and remove them from hold. You can see the description here: https://help.acumatica.com/?ScreenId=ShowWiki&pageid=7a8cb982-bcf7-4260-9e3f-0bb934509a07. Also, there is an example of using this setting in the Integration Scenarios course https://openuni.acumatica.com/courses/reporting/i100-integration-scenarios/.
Hope this helps :)

Userlevel 4
Badge +1

This is exactly what I was looking for.  Thank you so much!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved