Friday, September 28, 2018

List of Bills and Item Receipts with Associated Landed Cost Category

Here are steps to get the list of Bills and Item Receipts with associated Landed Cost Category:

1. Go to Transactions > Management > Saved Searches > New
2. Pull up Transaction Search
3. On the Criteria tab > Standard subtab, add:
      Type = is any of Bill,  Item Receipt
      Applied to Link Type = Landed Cost
4. On the Results tab, have the following fields and set the Summary type 

         Field                               Summary Type
       Date -------------------------------- Group
       Type -------------------------------- Group
       Number ----------------------------- Group
       Name -------------------------------- Group
       Amount ------------------------------ Maximum
       Applied to Link Type --------------- Group
       Applied to Transaction ------------ Group
5. Put a name on the search 
6. Hit Save and Run


No comments:

Post a Comment