Thursday, May 9, 2019

Saved Search on Item Fulfillments showing COGS Amount on those Sales Orders with related Return Authorization

To create a Saved Search on Item Fulfillments showing COGS Amount on those Sales Orders with related Return Authorization, below are the steps:

1. Navigate to Lists > Search > Saved Searches > New
2. Choose Transaction

3. Go to the Criteria tab > Standard subtab > Add Filters:
- Type = Sales Order
- Applying Transaction Fields... Type = Return Authorization
- Main Line = No
- Tax Line =  No
- Shipping Line = No

4. Go to the Results tab > Mark Show Totals check box (on the right side of the page)
5. Go to the Results tab > Columns subtab > Add Fields:
- Type
- Number
- Name
- Fulfilling/Receiving Transaction
- Applying Transaction
- Fulfilling/Receiving Transaction... COGS Amount
- Item

*Fields may be added/removed as necessary.

5. Name the Saved Search
6. Click Save & Run.
 

No comments:

Post a Comment