1. Navigate to Lists> Search> Saved Searches
2. Select Transaction
3. Under Criteria tab > Standard Sub tab select the following filters
---Type is Purchase order
---Main Line is False
4. Under Results tab add the following columns:
---Vendor Fields is Name and set the Summary type to Group
---Quantity Fulfilled/Received and set Summary type to Sum
5. Rename the search and hit Save & Run
6. Drill down the Vendor name.
Results: Transaction Saved Search with Grouped Field: The drilled down results are showing transactions amounts for other suppliers too
Solution:
1. Use vendor ID instead of vendor name to drill down the search.
---Select vendor fields is ID
2. If the customer wants to see the company name still add on the Results tab> Formula Text: {vendor.companyname}
---This will remove the "Link" for drilling down the field and therefore user will use vendor ID instead
Note: Defect 231728 was filed for this concern
No comments:
Post a Comment