Sunday, June 30, 2019

Create a List of Item Receipts from a Specific Vendor for a Specific Month

Need a list of Item Receipts from a Specific Vendor for a specific month.

1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Select Transaction from the list.
3. In Criteria > Standard > Filter:
    a. Choose Type from the dropdown and in the popup select Item Receipt
    b. Choose Created From Fields… from the dropdown and in the popup select Type. In the new popup box, choose Purchase Order
    c. Choose Main Line from the dropdown and in the popup select No
    d. Choose Quantity from the dropdown and in the popup, select greater than and enter 0 in the Value field
    e. Choose Item Fields... from the dropdown and in the popup select Type. In the new popup, choose Assmebly/Bill of Materials and Inventory Item
4. In Results > Columns > Field:
    a. Click on Remove All button
    b. Add Number, Item, Quantity, Date and Amount
    c. Add Vendor Fields... and in the popup choose Name/ID
    d. Add other fields as necessary
5. In Available Filters:
    a. Add Date and check the box under Show in Footer
    b. Add Vendor Fields... and in the popup choose Name/ID. Check the box under Show in Footer
6. Rename the Saved Search.
7. Click Save & Run.

1 comment: