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 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 (Reports ribbon) – These reports are stored in the ...\plug_ins\reports\systemreports folder.
  3. User reports menu (Reports ribbon) – 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. Spreadsheet reports menu (Reports ribbon) – These reports are stored in the ...\plug_ins\reports\excelreports\ folder. 
  5. Ledger analyser and Reports → T-Account viewer (Reports ribbon) – Seven (7) reports are stored in the ...\plug_ins\reports\GENERAL\ledgerview folder. These are:
    1. budgetvsactsimple – Budget vs actual and This year vs last year reports.
    2. colbal – Not used.
    3. colbalopen – Not used. 
    4. colbalopenonly – Not used.
    5. colbalsimple – Standard column balances report.
    6. detail – Trial balance, Income / Expense (Income statement) and the Balance sheet 
    7. ledgerdetail – Print button on the T-Account viewer.
  1. Reports generated from inside the osFinancials5 (or TurboCASH5.2) on various screens are stored in the ...\plug_ins\reports\GENERAL\documents folder. These are: 
    1. Batch Processing  (Default → Batch entry (F2)): 
      1. abbreviations – Abbreviation Definitions as set in the Default → 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). 
      2. batch – Batch Listing on the Batch entry  – F8:List – This will print a list of all transactions in an unposted batch. 
      3. 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.
      4. paycreditor - Prints the Creditor Payments report when clicking on the Print button in the Payments Debtors / Creditors  option (Batch entry – F9:Process). 
      5. paydebtor – Prints the Debtor Payments report when clicking on the Print button in the Receive Payments / Creditors  option (Batch entry – F9:Process). 
      6. 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).
      7. recon – Prints the Bank reconciliation report when clicking on the Report icon of the Reconcile Bank account screen (Default → Reconciliation).
    1. Documents  (Default → Documents (F6)) menu:
      1. barcodes – context menu - Quick link to print the barcodes of the stock items selected on documents. 
      2. 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) selected on purchase documents.
      3. labelsdelivery – Not implemented yet. This is similar than the labels report, but should print delivery addresses in stead of postal addresses. 
    1. Point-of-Sales (Standard)  Default → Input → POS Invoice  (Ctrl + F6) menu:
      1. oldpossales – This report prints from the Process - Reports or Cashup option on the POS Invoicing screen.
      2. oldposcashup - This report prints from the Process - Reports or Cashup option on the Default → Input → POS Invoicing screen.
    1. Others:
      1. datacheck – Prints the Data integrity check report from Setup → Tools → Data integrity check.
      2. 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. 
      3. payments – Prints a Receipts / Payments advise when the Receive Payment context menu option is selected (and the Print option is ticked) on the Default →Open item link  menu Transactions tab or on the Open item link screen for a debtor (customer / client) or creditor (supplier / vendor) account. 
      4. Userlog – Prints the Userlog report when clicking on the Log report button on Setup → Access control.
  1. REPORTS:
    1. CREDITOR – (Default – 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.  
    2. DEBTOR – (Default – 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.
    3. STOCK – (Default – Stock items  (F12)) – Barcode and Yagoda barcode. Print when you right-click on a selected stock item or stock items from the list.
    4. 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.
    5. HORECAPOS – This folder contains the reports for the HORECAPOS and RETAILPOS Plugins.
    6. SUBSCRIPT – This folder contains the Subscriptions report. (See the Subscriptions folder – This folder contains the report, emailtemplates, layouts and Sql for the Subscriptions Plugin).
    7. REPORTS FOLDER (Discontinued Reports) - The BATCHREPORT, CONTACTS, COSTCENTER, GL and TAX folders contains old reports not used in TurboCASH5. 
  1. Folders and reports for Plugins: 
    1. EmailInvoice and debcred folders are used for the E-MailPro Plugin
    2. parcel – This is not used at this stage – It is reserved for a Send Parcel Plugin. 
    3. remittance – This contains the list report, emailtemplates and layouts for the Reminders Plugin. 
    4. Subscriptions – This folder contains the report, emailtemplates, layouts and Sql for the Subscriptions Plugin.