Scenario
User wanted to know why is the Amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search is different from the amount in the Balance fields on the Vendor Record
Solution
The Balance column on the Vendor Saved Search extracts information from the Vendor Record > Subsidiaries tab > Balance (Base) field of the Primary Subsidiary.
The Balance (Foreign Currency) column extracts information from the Vendor Record > Financial tab > Balance Information section > Balance field.
If there is no Subsidiary selected under Home > Set Preferences > Restrict View tab > Subsidiary field.
a. Amount in the Balance column = Amount in the Balance (Base) field x Consolidated Exchange Rate for the period.
b. Amount in the Balance (Foreign Currency) column = Amount in the Balance field under Financial tab x Consolidated Exchange Rate for the period.
Consolidated Exchange Rate can be found by:
1. Navigate to Lists > Accounting > Consolidated Exchange Rates
2. Expand the Filters folder:
a. In the Period drop down field, select the current period
b. In the From Subsidiary drop down field, select the Primary Subsidiary of the Vendor Record
c. In the To Subsidiary drop down field, select the Name of Parent Company
3. Click Calculate
If the Subsidiary selected under the Home > Set Preferences > Restrict View tab > Subsidiary field is the same as the Primary Subsidiary selected on the Vendor record, the amount showing up in the Balance (Base) field on the Vendor Record is the same as the Balance column on the Vendor Saved Search,the amount showing up in the Balance field on the Vendor Record is the same as the Balance (Foreign Currency) column on the Vendor Saved Search.