The Check Item Availability Page is available when the Available to Promise feature is enabled. This can be checked by navigating to Set Up > Company > Enable Features > Items & Inventory tab > Inventory subtab.
To do this (using Administrator Role):
1. Navigate to Reports > Saved Searches > New. Select Search Type: Transaction
2. At the Criteria Tab > Standard Subtab, select the following filters:
-----a. Type - at pop up: is Purchase Order
-----b. Status: at pop up: any of: Purchase Order Pending Approval, Purchase Order Pending Receipt, Purchase Order Partially Received, Purchase Order Pending Billing/Partially Received
-----c. Location: at pop up: (select preferred Location)
-----d. Expected Receipt Date: at the pop up: (select preferred period – noted that PO should have Expected Receipt Date filled to be displayed) --- Optional
3. At the Results Tab > Columns subtab, select the following fields:
*** Mark the Show Totals field
1. Item --- Summary Type: Group
2. Location --- Custom Label: PO Location
3. Date
4. Expected Receipt Date
5. Type
6. Number
7. Quantity
8. Quantity Committed
9. Formula (Numeric) --- Formula: {quantity}-{quantitycommitted}---Custom Label: Remaining Quantity
4. Edit the Search Title
5. Hit Save and Run.
No comments:
Post a Comment