Reports - File structure
The Report designer folder / file structure
All document layout files and reports are installed and stored in the ...\plug_ins\reports folder of your installation directory.
Access select Report designer:
On the Reports ribbon or the Setup ribbon, select Report designer.
The Report designer will list all layout files and report folders as follows:
1.Document printing – All the layout files for printing documents are stored in the ...\plug_ins\reports\DOCUMENTS\DOCUMENTS folder.
2.Reports menu – These reports are stored in the ...\plug_ins\reports\Newreports folder.
3.User reports menu – These reports are stored in the userreports folder. Users are encouraged to create and / or edit existing reports, but it is recommended that these be copied and stored in the ...\plug_ins\reports\userreports\ folder.
4.Tools → Ledger analyser and Tools → T-Account viewer – Seven (7) reports are stored in the ...\plug_ins\reports\GENERAL\ledgerview folder. These are:
a)budgetvsactsimple – Budget vs actual and This year vs last year reports.
b)colbal – Not used.
c)colbalopen – Not used.
d)colbalopenonly – Not used.
e)colbalsimple – Standard column balances report.
f)detail – Trial balance, Income / Expense (Income statement) and the Balance sheet
g)ledgerdetail – Print button on the T-Account viewer.
5.Reports generated from inside the TurboCASH4 program on various screens are stored in the ...\plug_ins\reports\GENERAL\documents folder. These are:
a)Batch Processing (Input → Batch entry (F2)):
i)abbreviations – Abbreviation Definitions as set in the Input → Batch entry – F9:Process option. If you click on the Print button of the Abbreviation screen, a list of Abbreviation definitions will be printed. The abbreviations listed on this report, may be used to automatically fill the description column in the "Description" column when processing transactions in batches (journals).
ii)batch – Batch Listing on the Batch entry – F8:List – This will print a list of all transactions in an unposted batch.
iii)postedbatch - Batch listing on the Batch entry – Posted batches – Details tab – Print button - This will print a list of all transactions in a selected posted batch.
iv)paycreditor - Prints the Creditor Payments report when clicking on the Print button in the Payments Debtors / Creditors option (Batch entry – F9:Process).
v)paydebtor – Prints the Debtor Payments report when clicking on the Print button in the Receive Payments / Creditors option (Batch entry – F9:Process).
vi)receipt – Prints a receipt if the Create receipt option is selected for Receipt batches in the Batch entry – F9:Process (and if the Print option is ticked).
vii)recon – Prints the Bank reconciliation report when clicking on the Report icon of the Reconcile Bank account screen (Input → Reconcile Bank).
b)Documents (Input → Documents (F6)) menu:
i)barcodes – context menu - Quick link to print the barcodes of the stock items selected on documents.
ii)labels - context menu - Quick link to print the postal address labels (and Contact name) of the debtors (customers / clients) selected on sales documents or creditors (suppliers / vendors) selected on purchase documents.
iii)labelsdelivery – Not implemented yet. This is similar than the labels report, but should print delivery addresses in stead of postal addresses.
c)Point-of-Sales (Standard) Input → Documents → POS Invoice (Ctrl + F7) menu:
i)oldpossales – This report prints from the Process - Reports or Cashup option on the POS Invoicing screen.
ii)oldposcashup - This report prints from the Process - Reports or Cashup option on the Input → Documents → POS Invoicing screen.
i)datacheck – Prints the Data integrity check report from Tools → Data integrity check menu.
ii)groups – Prints the list of the Account group 1 / 2, Debtor group 1 / 2, Creditor group 1 / 2, Stock group 1 / 2, Document group 1 / 2, etc. when clicking on the Print button of a selected group on Setup → Groups.
iii)payments – Prints a Receipts / Payments advise when the Receive Payment context menu option is selected (and the Print option is ticked) on the Input → Open item link menu Transactions tab or on the Open item link screen for a debtor (customer / client) or creditor (supplier / vendor) account.
iv)Userlog – Prints the Userlog report when clicking on the Log report button on Setup → System parameters → Access control menu.
a)CREDITOR – (Edit → Creditors (F5)) – Selected Creditor Label (Postal address) and Selected Creditor Delivery Label (Delivery address). Print when you right-click on a selected creditor (supplier / vendor) account from the list.
b)DEBTOR – (Edit → Debtors (F4)) – Selected Debtor Label (Postal address) and Selected Debtor Delivery Label (Delivery address). Print when you right-click on a selected debtor (customer / client) account from the list.
c)STOCK – (Input → Stock items (F12)) – Barcode and Yagoda barcode. Print when you right-click on a selected stock item or stock items from the list.
d)PROJECTS – If projects have been activated, and transactions have been entered in batches and documents, you may print five (5) reports (i.e. Transactions, Hours, Stock items, Statements and the Total report). Budgets can also be entered for Projects, but it needs to be added to these reports.
e)HORECAPOS – This folder contains the reports for the HORECAPOS and RETAILPOS Plugins.
f)SUBSCRIPT – This folder contains the Subscriptions report. (See the Subscriptions folder – This folder contains the report, emailtemplates, layouts and Sql for the Subscriptions Plugin).
g)REPORTS FOLDER (Discontinued Reports) - The BATCHREPORT, CONTACTS, COSTCENTER, GL and TAX folders contains old reports not used in TurboCASH4.
7. Folders and reports for Plugins:
a)EmailInvoice and debcred folders are used for the E-MailPro Plugin
b)parcel – This is not used at this stage – It is reserved for a Send Parcel Plugin.
c)remittance – This contains the list report, emailtemplates and layouts for the Reminders Plugin.
d)Subscriptions – This folder contains the report, emailtemplates, layouts and Sql for the Subscriptions Plugin.