Question

How to use Sourcing macro on Service Order Materials

  • 30 November 2023
  • 0 replies
  • 62 views

Userlevel 1
Badge +6

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