Thursday, May 30, 2019

Create a Saved Search with the Same Supply Information at the Check Item Availability window

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