Reports - File structure

Parent Previous Next

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 → 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 → T-Ledger analyzer 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)ledgerdetailPrint 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)Journal processing  (Action → Journal entry (F2)):

i)abbreviations – Abbreviation Definitions as set in the Action → Journal 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, estimates, purchases, supplier returns and orders).

ii)journal – Journal Listing on the Journal  entry  – F8:List – This will print a list of all transactions in an unposted journal.

iii)postedbatch - Journal Listing on the Journal entry  – Posted journals – Details tab Print button - This will print a list of all transactions in a posted journal.

iv)paycreditor - Prints the Vendor payments report when clicking on the Print button in the Payments Customers / Vendors option (Journal entry – F9:Process).

v)paydebtor – Prints the Customer  payments report when clicking on the Print button in the Receive Payments / Vendors option (Journal entry – F9:Process).

vi)receipt – Prints a receipt if the Create receipt option is selected for Receipt Journals in the Journal 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 (Action → Reconciliation).

b)Documents  (Action → Documents (F6)) menu:

i)barcodes – context menu - Quick link to print the barcodes of the inventory items selected on documents.

ii)labels  - context menu - Quick link to print the postal address labels (and Contact name) of the customers selected on sales documents or 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)  Action → Input → POS Invoice  (Ctrl + F6) 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 Action → Input → POS Invoicing screen.

d)Others:

i)datacheck – Prints the Data integrity check report from Setup → Tools → Data integrity check.

ii)groups – Prints the list of the Account group 1 / 2, Customer group 1 / 2, Vendor group 1 / 2, Inventory 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 advice when the Receive payment context menu option is selected (and the Print option is ticked) on the Action → Open item link  menu Transactions tab or on the Open item link screen for a customer or vendor account.

iv)Userlog – Prints the User-log report when clicking on the Log report button on Setup → Access control.

6.REPORTS:

a)CREDITOR – (Action –Vendors  (F5)) – Selected Vendor Label (Postal address) and Selected Vendor Delivery Label (Delivery address). Print when you right-click on a selected vendor account from the list.  

b)DEBTOR – (Action –Customers  (F4)) – Selected Customer Label (Postal address) and Selected Customer Delivery Label (Delivery address). Print when you right-click on a selected customer account from the list.

c)STOCK (Action – Inventory items  (F12)) – Barcode and Yagoda barcode. Print when you right-click on a selected inventory item or inventory items from the list.

d)PROJECTS – If projects have been activated, and transactions have been entered in journals and documents, you may print five (5) reports (i.e. Transactions, Hours, Inventory 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.


Created with the Personal Edition of HelpNDoc: Free iPhone documentation generator