Skip to main content
Solved

Automatically/API Submit Open Replenishment Order

  • January 16, 2025
  • 1 reply
  • 26 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>

 

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

Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 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>

 


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