Saturday, December 22, 2018

Non-MLI account: Lists> Search> Saved Searches> Transactions> Summary type is Group: The drilled down results are showing transactions amounts for other vendors too

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