The Vendor transactions report lists all the transactions in documents and journals which are posted (updated) to the ledger for any specific period(s). You may select to show opening balances.
In addition to this, the following two (2) reports may be printed:
•Vendor transaction list - This report lists all the transactions in documents and journals which are posted (updated) to the ledger. All transactions will be listed irrespective of open item links.
•Vendor transaction list - Open item - This report lists only those outstanding transactions in documents and journals which are posted (updated) to the ledger. If a vendor account is set as Open item account (Action → Vendor - Accounting information tab), it will list only those transactions with outstanding amounts. Any debit amounts, which are not linked to credit transactions, should be processed in Action → Open item link.
This report will include opening balances (closing balances before the selected periods / dates).
To print Vendor - Transactions reports:
1.On the Reports ribbon, select Reports → Vendors → Transactions.
3.Select the following options:
a)Period - Select a period on the Per period tab. You may click on the Free selection tab to select a specific date or a range of dates to include transactions in the report.
b)From ... To - Select a vendor) account or a range of vendor accounts, to include in the report.
c)Sequence - Select "Vendor code" to print the report by account code or "Description" to print the report by account description (name).
d)New page per account - If this option is selected (ticked), it will print the transactions for each account on a new page.
e)Cost center 1 / 2 - If you have activated Cost centers, you may select the Cost centers.
4.Click on the OK button.
View the "Vendor transactions" report:
The details on the report, is as follows:
1.Page header 1 - Company details - This will only print on the fist page.
If the New page per account option on the report parameters is selected (ticked), the Company details will not be printed in the Page header of the first page. The company name is displayed in the Page footer of all pages.
2.Page header 2 - Report Name and Parameters as selected on the Report Options will display below the Company details on the first page and at the top of each subsequent page.
3.Header group - The Account code and Name (description). It also displays if the vendor account is an open item account.
4.Detail - List the transaction details for each account.
a)Date - The date of the transaction or document.
b)Journal no. - The Journal number as generated for posted journal transactions. If documents (i.e. purchases and supplier returns are posted, the document number will be listed.
c)Alias - The Journal name (as entered in the Alias field, or Auto-alias generated), for posted journal transactions. If documents (i.e. purchases and supplier returns are posted, the document number will be listed.
d)Reference - The reference number of the document (i.e. purchases and supplier returns) or the reference number entered in the reference column on the Journal entry screen.
e)Description - The inventory item code or the account description (if the Financial entry inventory item type was selected on a document) of the document (i.e. purchases and supplier returns) or the description entered in the description column on the Journal entry screen.
f)Debit - The debit transaction amount.
g)Credit - The credit transaction amount.
h)Cum - The accumulative total of the transactions included in the account.
5.Footer - Groups - Total / Balance - Displays the total of the transactions and the closing balance for each account.
6.Page Footer - List the following:
a)Data - Name of the Set of Books and the full path of the Set of Books (e.g. ...\books\BOOKSNAME\Books.fdb)
b)System User and TurboCASH User (Setup →Access control ).
c)Printed: The date and time of the system (computer) on which the report is printed.
d)Page: Page number and the last page number of the report.
Created with the Personal Edition of HelpNDoc: Generate Kindle eBooks with ease