Saturday, June 15, 2019

Vendor search for the most recent vendor bill date for each vendor.

1. Navigate to Reports > New Search or Lists > Search > Saved Searches > New.

2. Click Vendor.

3. Click the Results tab.

4. Group the Name column by selecting Group from the Summary Type dropdown list.

5. Add a Formula(Date) column with the following formula:

DECODE({transaction.type}, 'Bill', {transaction.trandate})

6. Group the Formula(Date) column by selecting Maximum from the Summary Type dropdown list.

7. Click Preview or Save & Run.

Note : For other transaction types, modify the formula by changing Bill to the particular transaction type (ex. Bill Credit).


No comments:

Post a Comment