Is there a way to make a default storeroom when the maximo item number is only in one storeroom?
Re: PO - PO Lines - Charge To Storeroom Default if there is only one2014-02-05T23:29:58ZThis is the accepted answer. This is the accepted answer.
The below solution works... but get an error message whenever I pick a Maximo Item Number that belongs to more than one storeroom. Obviously, the cross domain is looking for one value, but it gets multiple and thus erroring out.1) Go To - System Configuration - Platform Configuration - Domains - click Add New Domain - Add new CROSSOVER Domain - add the following:Domain: INVENTORY2POLINEValidation Where Clause: itemnum=:itemnum and itemsetid=:itemsetid and siteid=:tositeidSource: LOCATIONDestination Field: STORELOCSave.2) Go To - System Configuration - Platform Configuration - Database Configuration - access the POLINE object - click on the attributes tab - filter for ITEMNUM - add INVENTORY2POLINE to the Domain field.Save.Click on the List tab - click on Select Action - Manage Admin Mode - Turn On Admin Mode - click Ok - Click on Select Action - Apply Configuration Changes - Apply Changes - Turn Off Admin Mode.Updated on 2014-02-06T00:05:05Z at 2014-02-06T00:05:05Z by swkim90049
Re: PO - PO Lines - Charge To Storeroom Default if there is only one2014-02-06T23:25:53ZThis is the accepted answer. This is the accepted answer.
If you instead want to use an Automation Script... this works better and doesn't give the error as the cross domain does:
In regards to your issue, please do the following: 1) Go To - System Configuration - Platform Configuration - Automation Scripting - click on Select Action - Create - Script with Attribute Launch Point - enter the following information: Launch Point: ITEMNUM Object: POLINE Attribute: ITEMNUM Click on Next 2) Enter the following value: Script: ITEMNUM Click on Next. 3) In the source Code Field, enter the following information: storeLocSet = mbo.getMboSet("$POLINE","INVENTORY","itemnum=:itemnum and siteid=:tositeid") inventoryLocation = storeLocSet.getMbo(0).getString("LOCATION") mbo.setValue("STORELOC",inventoryLocation) Save. Test issue