Vendor Trial Balance
This new report was developed in order to obtain analytical details for Vendors. And it helps the Accounting Department to compare values registered in accounting with values registered using vendor cards.
How to run the Vendor Trial Balance for a specific period
- Open the Vendor Trial Balance by choosing Tell me icon
- In the window that is opened the following fields must be completed:
- Date Filter - date interval for which the report is run
- No.- the G/L accounts for which the trial balance is run eventhough this filter is not mandatory
- Vendor Posting Group Code from Vendor Posting Group tab, Code field – the report will only show results for vendor transactions filtered on vendor posting group. This filter is not mandatory.
For a more detailed report the following fields can be completed too:
- Currency Details – for each vendor, transactions are grouped and totaled on currency code. For each vendor, a new section is displayed for each currency having transaction.
- Show eq. in LCY - for transactions posted in foreign currency, a separate line is shown in the report, with amounts calculated in LCY.
Posted Results
The report totalizes values for each vendor, vendor posting group and for each selected ledger account through the following columns :
- Vendor number
- Vendor description
- Initial balance
- Previous movements
- Current movements
- Total amounts
- Ending balance