This list can be modified in the Configuration Wizard. General manipulation is possible using the stockmanagement.src file or window-related changes using Windowevent setbindropdown.
The following priorities are considered:
1.Window-related customization (windowevent setbindropown)
2.General changes (stockmanagement.src)
3.Settings in the Configuration wizard
In the e_bindropdownbsl variable, the ODATA command can be defined.
It is beneficial to use the Beas service layer, because Beas supports different warehouse systems that use different tables and logic.
The standard functions for receipt and issue are as folows:
file stockmanagement.src
function binreceiptdropdown
setvar=e_bindropdownbsl=BinLocation(<e_binwhscode,bsl>)?$mask=1
end function
function binissuedropdown
setvar=e_bindropdownbsl=WareHouseStock(<e_binwhscode,bsl>)?$select=BinLocation/BinCode,BinLocation/BinColor,OnHand,UoMCode,Batch,IVersionId,BatchAttribute1,BatchAttribute2,ExpirationDate&$filter=ItemCode eq <e_itemcode,bsl> and OnHand gt 0
end function
For receipt, use BinLocation.
For issue, use WareHouseStock.
For more information, see Beas Service Layer documentation.
Example
-- file stockmanagement.src --
// BinReceipt: Show all Bin Locations, ordered by OnHand descending, BinCode ascending:
function binreceiptdropdown
setvar=e_bindropdownbsl=BinLocation(<e_binwhscode,bsl>)?$select=BinLocation/BinCode,BinLocation/BinColor,OnHand&$orderby=OnHand desc,BinLocation/BinCode asc
end function
// BinIssue: Show only Bin Locations where OnHand > 0 of the selected ItemCode, ordered by OnHand descending, BinCode ascending:
function binissuedropdown
setvar=e_bindropdownbsl=WareHouseStock(<e_binwhscode,bsl>)?$select=BinLocation/BinCode,BinLocation/BinColor,OnHand,UoMCode,Batch&$filter=ItemCode eq <e_itemcode,bsl> and OnHand gt 0&$orderby=OnHand desc, BinLocation/BinCode asc
end function
|