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.
To access select Report designer:
1.DOCUMENTS – All the layout files for printing documents are stored in the
" ...\plug_ins\reports\DOCUMENTS\DOCUMENTS " folder.
2.Reports → Reports menu – These reports are stored in the " ...\plug_ins\reports\systemreports " folder.
3.Reports → User reports – 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.Reports → Ledger analyser and Reports → 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 TurboCASH5 program on various screens are stored in the ...\plug_ins\reports\GENERAL\documents folder. These are:
a)Batch Processing (Batch entry (F2) (Action ribbon)):
i)abbreviations – Abbreviation definitions as set in the 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 document lines when processing documents (invoices, credit notes, quotes, Purchases, Supplier returns and Orders).
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 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 theBatch 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 (Reconciliation (Action ribbon)).
b)Documents (Documents (F6)) (Action ribbon):
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 → POS Invoice (Ctrl + F6) menu on the Action ribbon:
i)oldpossales – This report prints from the Process - Reports or Cashup option on the POS Invoicing.
ii)oldposcashup - This report prints from the Process - Reports or Cashup option on the Input → POS Invoicing (Action ribbon).
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 Groups (Setup ribbon).
iii)payments – Prints a Receipts / Payments advise when the Receive Payment context menu option is selected (and the Print option is ticked) on the Open item link (Action ribbon) Transactions tab or on the Open item link for a debtor (customer / client) or creditor (supplier / vendor) account.
a)CREDITOR – (Action – 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 – (Action – 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 – (Action – 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 TurboCASH5.
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.