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:

select replenish_order_id
from repl_order_hdr
where repl_order_stat = '100'
-- and warehouse_id = 'XXX'

Process Flow Action to Submit:

<root
xmlns:dt="urn:schemas-microsoft-com:datatypes">
<session email="" alias="">
<state bc_name="replenishment">
<action name="data">
<main>
<row>
<replenish_order_id dtype="string" in_var="" out_var="">{replenish_order_id}</replenish_order_id>
</row>
</main>
</action>
<action name="execmacro">
<attribute bo_name="main" macro_name="CreateIMOPR" />
<attribute dtype="string" in_var="" value="N" />
</action>
</state>
</session>
</root>

 

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:

select replenish_order_id
from repl_order_hdr
where repl_order_stat = '100'
-- and warehouse_id = 'XXX'

Process Flow Action to Submit:

<root
xmlns:dt="urn:schemas-microsoft-com:datatypes">
<session email="" alias="">
<state bc_name="replenishment">
<action name="data">
<main>
<row>
<replenish_order_id dtype="string" in_var="" out_var="">{replenish_order_id}</replenish_order_id>
</row>
</main>
</action>
<action name="execmacro">
<attribute bo_name="main" macro_name="CreateIMOPR" />
<attribute dtype="string" in_var="" value="N" />
</action>
</state>
</session>
</root>