Skip to main content
Question

How to use Sourcing macro on Service Order Materials


Forum|alt.badge.img+9

I’m trying to set up an integration for consumable orders that will create Service Orders, add materials, and then Allocate (source) them from a designated warehouse.
Setting ldmnd_stat_id updates the status, but does not actually allocate the stock. 
Sourcing through the employee portal seems to call macro Sourcing.

I’ve tried to run this through the interactive api, but I cannot get it to succeed. Is someone able to assist me with the format?

I’ve tried using attributes, and macro params. I’m struggling to find any documentation on specific macros, which would be really helpful.
 

<root
	xmlns:dt="urn:schemas-microsoft-com:datatypes">
	<session email="" alias="">
		<state bc_name="service_order">
			<action name="data">
				<main>
					<row number="1">
						<order_id>SV2311290003@@1</order_id>
					</row>
				</main>
			</action>
			<action name="execmacro">
				<attribute bo_name="demand_material@row=1" macro_name="Sourcing" />
				<attribute dtype="string" in_var="" value="- -req_qty,cancel_due_date_check,part_id,whse,bin,fr_bin_code_id,inv_type,company_id,$1,1,842101,CC001,8582,Default_Good,good,," />
				<attribute dtype="string" in_var="" value="1" />
			</action>
		</state>
	</session>
</root>



 

<root
	xmlns:dt="urn:schemas-microsoft-com:datatypes">
	<session email="" alias="">
		<state bc_name="service_order">
			<action name="data">
				<main>
					<row number="1">
						<order_id>SV2311290003@@1</order_id>
					</row>
				</main>
			</action>
			<action name="execmacro">
				<attribute bo_name="demand_material@row=1" macro_name="Sourcing" />
				<macro_params>
					<columns>
						<value>req_qty</value>
						<value>cancel_due_date_check</value>
						<value>part_id</value>
						<value>whse</value>
						<value>bin</value>
						<value>fr_bin_code_id</value>
						<value>inv_type</value>
						<value>company_id</value>
					</columns>
					<values>
						<value dtype="string">$1</value>
						<value dtype="string">1</value>
						<value dtype="string">842101</value>
						<value dtype="string">CC001</value>
						<value dtype="string">8582</value>
						<value dtype="string">Default_Good</value>
						<value dtype="string">good</value>
						<value dtype="string"></value>
					</values>
				</macro_params>
			</action>
		</state>
	</session>
</root>

 

0 replies

Be the first to reply!

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