Replicate Tansfer Order with Transfer Order Lines

[HudyssonPOntes]

Good afternoon, how are you? I need to create an order guide or catalog item that will replicate the transfer order page with its respective transfer order lines. I need the page to allow the user to select the source and destination stock, and to choose multiple items and quantities from the alm_asset table, so that I can later create a transfer order and transfer order lines. How could I do this? Thank you very much!

[jcmings]

Just a note in advance - I have very little familiarity with the Transfer tables. But there are a few options, and it depends how you want to "receive" this request. It can either be a record that's created directly on your alm_transfer_order_line table (in which case you would use a record producer) or a request/request item (in which case you would go the catalog item/order guide route). 

If you wanted to create a record producer (a catalog item that creates a record directly on the alm_transfer_order_line table), you can do so by navigating to the alm_transfer_order_line table record (System Definition > Tables) and clicking on the related link Add to Service Catalog. This will begin the process of creating a record producer; you'll need to specify the catalog item's name, short description, and variables (fields on the form). For the purpose of adding items and quantities from the alm_asset table, you could add a multi-row variable set (MRVS) to your record producer. You would later need to script (or via flow designer) the transfer of the MRVS to what records you need.

If you went the catalog item route, the process would look pretty similar, but you would just start with the New button on sc_cat_item table. You can configure your variables from that screen. The creation of the request via the portal will create a REQ and RITM (RITM will be tied to the catalog item you created). If you wanted to have multiple RITMs associated with the REQ, you'd create an order guide, and you'd need to create a catalog item for each alm_asset the user has an option to add. (Alternatively use a MRVS on your catalog item.) You may still need a script to map this to create other records.

Hope this helps... happy to try to solution further if needed!