Need to displayed only associated Asset based on stockroom selection.

Prasnajeet1
Giga Guru

Hi All

I have requirement to show only associated asset with stockroom.

For Example: User has selected a stockroom in Form stockroom (1001ABC)field in alm_transfer_order table and there are 20 asset associated with this stockroom (1001ABC). However only 5 asset are there where state is "In stock" and Sub state is either "Available" or "Pending transfer". So my requirement is when select the stockroom (1001ABC) then only those 5 asset should appear in the list control.

 

I know we can achieve this requirement using reference qualifier, however I am not able to write it.

Can someone please help with the correct script or step please.

 

Thanks you in advanced.

3 REPLIES 3

Ashok Sasidhara
Tera Sage
Tera Sage

Transfer order table does not give option to select assets. Did you mean 'Transfer order lines' (alm_transfer_order_line table) associated with the transfer order? While creating a new transfer order line, you need to first populate a value in the 'Model' reference field before clicking on the 'Asset' reference field. Then the asset field will show only the assets available in stock for that model at the selected stockroom's location. If you click on 'Asset' reference field before populating 'Model', it will show all the Assets available in stock at that location. That might be the reason for the mismatch which you are seeing. But as 'Model' is mandatory for submission, it will be correctly auto-populated even if you populate the 'Asset' field first.

If this is not the reason and if there is actually an issue, then please check if someone has modified the following 2 OOB script includes:

TransferOrderFilters
TransferOrderLineFilters

Prasnajeet1
Giga Guru

Hi Thanks for you input and support. I got the solution for this. I did few modification in the BR and got the expected output.

Amarjeet Pal
Kilo Sage
Kilo Sage

Hello @Prasnajeet1 ,

 

Please share the changes you made and please provide helpful to the replies and close the thread , so that it will be helpful for others to find the correct answer.

 

Thanks

Amarjeet Pal