On Order tab of OE Order Entry screen the item quantities region displays item quantities for the currently highlighted line item – for the selected shipping location and for all the locations. Drilldown buttons are available besides Quantity on Sales Order, Quantity on Purchase Order and Qty Committed fields which provides detailed information.
Similarly we have provided a drilldown link for Quantity on Hand field. In this blog we shall review this enhancement.
Likewise other item quantities fields we have provided custom drilldown buttons to show the details for the location specified in the selected detail line and another one for all the locations.
Note: Item quantities are given in stocking unit of measure.
The New Stuff : Advance Search feature for Reconcile Statements Form
The drilldown button besides location specific (Qty. On Hand) quantities; display the item location details for the location specified in the selected detail line. The form lists the details such as Picking Sequence, Qty. On Hand, Qty. Available to Ship and Qty. Committed.
The drilldown button besides all location (Qty. On Hand) quantities; displays the item location details for all the locations. The form lists the details such as Picking Sequence, Qty. On Hand, Qty. Available to Ship and Qty. Committed.
Thus the Qty. On Hand drilldown buttons provides useful information regarding item quantities from the item location details.
Note: This customization is done using Sage 300 SDK, as a result easy to deploy and it works with Sage 300 ERP 2012 and Sage 300 ERP v6.0A.
Also Read :
1. How to Calculate Current Quantity on Hand on Custom Reports in Sage Accpac ERP
2. Location Wise I/C Item Details
3. Defining Specific Location for an Inventory Item in Sage 300 ERP
4. How to set default reserved quantity in Sage 300 ERP
5. Advanced Features in Order Entry screen of Sage 300 ERP 2012