Friday, July 12, 2019

Saved Search to Expose all Currencies Associated with a Vendor

When users enable Multi-Currency for Vendor, the Currency field on Saved Search will only point to Primary Currency selected on the Vendor Record. If users want to expose the Other Currencies assigned to the Vendor, then Vendor Currency Balance Fields: Currency should be used. To create a Saved Search showing all Currencies and the corresponding balances:

1.    Navigate to Transactions > Management > Saved Searches > New.

2.    Select Vendor.

3.    On the Results tab add the following fields: Name, Vendor Currency Balance Fields: Currency and Vendor Currency Balance Fields > Balance (Foreign Currency).

4.    Click Preview or Save & Run.

NOTE: The above steps can also be performed for customer search to expose all currencies.

No comments:

Post a Comment