Skip to main content
Solved

Automatically/API Submit Open Replenishment Order

  • January 16, 2025
  • 1 reply
  • 28 views

Forum|alt.badge.img+9

Is there a way to configure a replenishment order such that it auto submits and creates the resulting RPLO IMOs, or is there an API command/macro that we can execute on a process flow to submit an open Replenishment Order?

 

 

Best answer by csjohnstone

Never mind! I figured it out.

Process Flow Data Query to get Open Replenishment Orders:

1select replenish_order_id
2from repl_order_hdr
3where repl_order_stat = '100'
4-- and warehouse_id = 'XXX'

Process Flow Action to Submit:

1<root
2 xmlns:dt="urn:schemas-microsoft-com:datatypes">
3 <session email="" alias="">
4 <state bc_name="replenishment">
5 <action name="data">
6 <main>
7 <row>
8 <replenish_order_id dtype="string" in_var="" out_var="">{replenish_order_id}</replenish_order_id>
9 </row>
10 </main>
11 </action>
12 <action name="execmacro">
13 <attribute bo_name="main" macro_name="CreateIMOPR" />
14 <attribute dtype="string" in_var="" value="N" />
15 </action>
16 </state>
17 </session>
18</root>

 

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

1 reply

Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 36 replies
  • Answer
  • January 16, 2025

Never mind! I figured it out.

Process Flow Data Query to get Open Replenishment Orders:

1select replenish_order_id
2from repl_order_hdr
3where repl_order_stat = '100'
4-- and warehouse_id = 'XXX'

Process Flow Action to Submit:

1<root
2 xmlns:dt="urn:schemas-microsoft-com:datatypes">
3 <session email="" alias="">
4 <state bc_name="replenishment">
5 <action name="data">
6 <main>
7 <row>
8 <replenish_order_id dtype="string" in_var="" out_var="">{replenish_order_id}</replenish_order_id>
9 </row>
10 </main>
11 </action>
12 <action name="execmacro">
13 <attribute bo_name="main" macro_name="CreateIMOPR" />
14 <attribute dtype="string" in_var="" value="N" />
15 </action>
16 </state>
17 </session>
18</root>

 


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