Reports - System reports - File names
Reports menu - File structure and file names
All standard reports are installed and stored in the ...\plug_ins\reports\systemreports folder of your installation directory.
To access the Report designer:
1.On the Reports ribbon; or the Setup ribbon, select Report designer. The Report designer will list all systemreports files and report folders as follows:
When printing reports using the “Material” theme, the icons in the “Material” theme folder will be displayed in menus and the icons in the “Classic” theme folder will be displayed on the report parameters screens and in Reportman.
For your convenience, a list of the file names and structure of the reports in the Reports menu (Reports ribbon) is as follows:
|
Folder |
Sub-folder1 |
Sub-folder2 |
Internal folder name / Report name |
Internal report name |
Material Reports menu |
Icons on report parameters |
|
Ledger |
|
|
TRN_1372 |
|
|
|
|
|
Budget |
|
TRN_1027 |
|
|
|
|
|
|
|
Budget vs actual (3 periods) |
TRN_3372.rep |
|
|
|
|
Graph |
|
TRN_1091 |
|
|
|
|
|
|
|
Graph - Profit Loss per week |
TRN_906169.rep |
|
|
|
|
Listing |
|
TRN_66 |
|
|
|
|
|
|
|
Chart of Accounts |
TRN_73.rep |
|
|
|
|
Transactions |
|
TRN_74 |
|
|
|
|
|
|
|
Transactions |
TRN_74.rep |
|
|
|
|
|
|
Transactions - Standard |
TRN_906110.rep |
|
|
|
|
|
|
Transactions - Extra details |
TRN_906111.rep |
|
|
|
Debtors |
|
|
TRN_160 |
|
|
|
|
|
Graph |
|
TRN_1091 |
|
|
|
|
|
|
|
Graph - Debtors per week |
TRN_906168.rep |
|
|
|
|
Age analysis |
|
TRN_65 |
|
|
|
|
|
|
|
Balances detail |
TRN_906142.rep |
|
|
|
|
|
|
Balances detail history (open item) |
TRN_906143.rep |
|
|
|
|
|
|
Balances |
TRN_906147.rep |
|
|
|
|
Listing |
|
TRN_66 |
|
|
|
|
|
|
|
Contacts |
TRN_2876.rep |
|
|
|
|
|
|
Listing |
TRN_66.rep |
|
|
|
|
|
|
List delivery address |
TRN_906138.rep |
|
|
|
|
|
|
List postal address |
TRN_906139.rep |
|
|
|
|
|
|
List details |
TRN_906140.rep |
|
|
|
|
|
|
Credit control listing (Credit limit vs Current balance) |
TRN_906338.rep |
|
|
|
|
|
|
Tax and Company registration numbers |
TRN_906339.rep |
|
|
|
|
Print labels |
|
TRN_68 |
|
|
|
|
|
|
|
Delivery address labels |
TRN_906064.rep |
|
|
|
|
|
|
Postal address labels |
TRN_906137.rep |
|
|
|
|
Transactions |
|
TRN_74 |
|
|
|
|
|
|
|
Transactions |
TRN_74.rep |
|
|
|
|
|
|
Transaction List - Open item |
TRN_906061.rep |
|
|
|
|
|
|
Transactions - Standard |
TRN_906106.rep |
|
|
|
|
|
|
Transactions - Extra details |
TRN_906107.rep |
|
|
|
|
|
|
Transaction List |
TRN_906440.rep |
|
|
|
|
Outstanding |
|
TRN_947 |
|
|
|
|
|
|
|
Debtor statement |
TRN_1090.rep |
|
|
|
|
|
|
Due date |
TRN_2222.rep |
|
|
|
|
|
|
Debtors Outstanding at date |
TRN_906104.rep |
|
|
|
|
|
|
Debtor statement - Outstanding |
TRN_906552.rep |
|
|
|
Creditors |
|
|
TRN_161 |
|
|
|
|
|
Graph |
|
TRN_1091 |
|
|
|
|
|
|
|
Graph - Creditors per week |
TRN_906167.rep |
|
|
|
|
Age analysis |
|
TRN_65 |
|
|
|
|
|
|
|
Balances detail |
TRN_906142.rep |
|
|
|
|
|
|
Balances detail history (open item) |
TRN_906143.rep |
|
|
|
|
|
|
Balances |
TRN_906147.rep |
|
|
|
|
Listing |
|
TRN_66 |
|
|
|
|
|
|
|
Contacts |
TRN_2876.rep |
|
|
|
|
|
|
Listing |
TRN_66.rep |
|
|
|
|
|
|
List delivery address |
TRN_906138.rep |
|
|
|
|
|
|
List postal address |
TRN_906139.rep |
|
|
|
|
|
|
List details |
TRN_906140.rep |
|
|
|
|
|
|
Credit control listing (Credit limit vs Current balance) |
TRN_906338.rep |
|
|
|
|
|
|
Tax and Company registration numbers |
TRN_906339.rep |
|
|
|
|
Print labels |
|
TRN_68 |
|
|
|
|
|
|
|
Delivery address labels |
TRN_906064.rep |
|
|
|
|
|
|
Postal address labels |
TRN_906137.rep |
|
|
|
|
Transactions |
|
TRN_74 |
|
|
|
|
|
|
|
Transactions |
TRN_74.rep |
|
|
|
|
|
|
Transaction List - Open item |
TRN_906061.rep |
|
|
|
|
|
|
Transactions - Standard |
TRN_906108.rep |
|
|
|
|
|
|
Transactions - Extra details |
TRN_906109.rep |
|
|
|
|
|
|
Transaction List |
TRN_906440.rep |
|
|
|
|
Outstanding |
|
TRN_947 |
|
|
|
|
|
|
|
Creditor remittance advise |
TRN_1089.rep |
|
|
|
|
|
|
Due date |
TRN_2222.rep |
|
|
|
|
|
|
Outstanding at date |
TRN_906103.rep |
|
|
|
|
|
|
Creditor remittance advise - Outstanding |
TRN_906551.rep |
|
|
|
Sales |
|
|
TRN_1792 |
|
|
|
|
|
Quotes |
|
TRN_1870 |
|
|
|
|
|
|
Graph |
TRN_1091 |
|
|
|
|
|
|
|
Graph - Quotes per week - Quantities |
TRN_906323.rep |
|
|
|
|
|
|
Graph - Quotes per week - Turnover |
TRN_906324.rep |
|
|
|
|
|
Debtors |
TRN_160 |
|
|
|
|
|
|
|
Quotes per period - Quantities |
TRN_906315.rep |
|
|
|
|
|
Sales |
TRN_1792 |
|
|
|
|
|
|
|
Quotes per period |
TRN_3568.rep |
|
|
|
|
|
Items |
TRN_2052 |
|
|
|
|
|
|
|
Items per period |
TRN_906115.rep |
|
|
|
|
Invoices |
|
TRN_300 |
|
|
|
|
|
|
Graph |
TRN_1091 |
|
|
|
|
|
|
|
Graph - Invoices per week - Quantities |
TRN_906170.rep |
|
|
|
|
|
|
Graph - Invoices per week - Turnover |
TRN_906171.rep |
|
|
|
|
|
Debtors |
TRN_160 |
|
|
|
|
|
|
|
Invoices per period - Quantities |
TRN_906155.rep |
|
|
|
|
|
Sales |
TRN_1792 |
|
|
|
|
|
|
|
Invoices per period |
TRN_3570.rep |
|
|
|
|
|
Items |
TRN_2052 |
|
|
|
|
|
|
|
Items per period |
TRN_906115.rep |
|
|
|
|
Credit notes |
|
TRN_47 |
|
|
|
|
|
|
Graph |
TRN_1091 |
|
|
|
|
|
|
|
Graph - Credit notes per week - Quantities |
TRN_906319.rep |
|
|
|
|
|
|
Graph - Credit notes per week - Turnover |
TRN_906320.rep |
|
|
|
|
|
Debtors |
TRN_160 |
|
|
|
|
|
|
|
Credit notes per period - Quantities |
TRN_906311.rep |
|
|
|
|
|
Sales |
TRN_1792 |
|
|
|
|
|
|
|
Credit notes per period |
TRN_3569.rep |
|
|
|
|
|
Items |
TRN_2052 |
|
|
|
|
|
|
|
Items per period |
TRN_906115.rep |
|
|
|
Plugins |
|
|
TRN_1805 |
|
|
|
|
|
Price agreement |
|
TRN_3380 |
|
|
|
|
|
|
|
Debtor – Price agreement |
TRN_906035.rep |
|
|
|
|
|
|
Creditor – Price agreement |
TRN_906088.rep |
|
|
|
|
Location-Serials-Batches |
|
TRN_3398 |
|
|
|
|
|
|
|
On hand |
TRN_1777.rep |
|
|
|
|
|
|
Stock movement |
TRN_906038.rep |
|
|
|
Stock |
|
|
TRN_1999 |
|
|
|
|
|
Reorder |
|
TRN_1778 |
|
|
|
|
|
|
|
Reorder report |
TRN_83.rep |
|
|
|
|
|
|
Current stock levels |
TRN_906268.rep |
|
|
|
|
Print labels |
|
TRN_68 |
|
|
|
|
|
|
|
Barcode |
TRN_1774.rep |
|
|
|
|
|
|
Yagoda barcode |
TRN_906040.rep |
|
|
|
|
Stock item listing |
|
TRN_84 |
|
|
|
|
|
|
|
All selling prices |
TRN_1056.rep |
|
|
|
|
|
|
Tax classes |
TRN_3465.rep |
|
|
|
|
|
|
Stock item listing |
TRN_84.rep |
|
|
|
|
Backorder |
|
TRN_906050 |
|
|
|
|
|
|
|
Backorder |
TRN_906050.rep |
|
|
|
|
Stock In / Out |
|
TRN_906112 |
|
|
|
|
|
|
|
Stock In / Out - Documents |
TRN_38.rep |
|
|
|
|
|
|
Stock In / Out |
TRN_906112.rep |
|
|
|
Point-of-Sale |
|
|
TRN_2200 |
|
|
|
|
|
Standard |
|
TRN_1990 |
|
|
|
|
|
|
|
Sales |
TRN_1792.rep |
|
|
|
|
|
|
Receipts |
TRN_182.rep |
|
|
|
|
Cash slip printer |
|
TRN_906160 |
|
|
|
|
|
|
|
Sales |
TRN_1792.rep |
|
|
|
|
|
|
Receipts |
TRN_182.rep |
|
|
|
Contacts |
|
|
TRN_2876 |
|
|
|
|
|
|
|
Contacts |
TRN_2876.rep |
|
|
|
Calendar |
|
|
TRN_2879 |
|
|
|
|
|
|
|
Hours |
TRN_2330.rep |
|
|
|
Batch entry |
|
|
TRN_298 |
|
|
|
|
|
|
|
Documents |
TRN_38.rep |
|
|
|
|
|
|
Batch transactions per period |
TRN_906141.rep |
|
|
|
Purchases |
|
|
TRN_49 |
|
|
|
|
|
Purchase documents |
|
TRN_1269 |
|
|
|
|
|
|
Graph |
TRN_1091 |
|
|
|
|
|
|
|
Graph - Purchases per week - Quantities |
TRN_906289.rep |
|
|
|
|
|
|
Graph - Purchases per week - Cost |
TRN_906290.rep |
|
|
|
|
|
Creditors |
TRN_161 |
|
|
|
|
|
|
|
Purchases per period - Quantities |
TRN_906150.rep |
|
|
|
|
|
Items |
TRN_2052 |
|
|
|
|
|
|
|
Items per period |
TRN_906115.rep |
|
|
|
|
|
Purchases |
TRN_302 |
|
|
|
|
|
|
|
Purchases per period |
TRN_3573.rep |
|
|
|
|
Orders |
|
TRN_1871 |
|
|
|
|
|
|
Graph |
TRN_1091 |
|
|
|
|
|
|
|
Graph - Orders per week - Quantities |
TRN_906325.rep |
|
|
|
|
|
|
Graph - Orders per week - Cost |
TRN_906326.rep |
|
|
|
|
|
Creditors |
TRN_161 |
|
|
|
|
|
|
|
Orders per period - Quantities |
TRN_906317.rep |
|
|
|
|
|
Items |
TRN_2052 |
|
|
|
|
|
|
|
Items per period |
TRN_906115.rep |
|
|
|
|
|
Purchases |
TRN_302 |
|
|
|
|
|
|
|
Orders per period |
TRN_3572.rep |
|
|
|
|
Supplier returns |
|
TRN_303 |
|
|
|
|
|
|
Graph |
TRN_1091 |
|
|
|
|
|
|
|
Graph - Supplier returns per week - Quantities |
TRN_906321.rep |
|
|
|
|
|
|
Graph - Supplier returns per week - Cost |
TRN_906322.rep |
|
|
|
|
|
Creditors |
TRN_161 |
|
|
|
|
|
|
|
Supplier returns per period - Quantities |
TRN_906313.rep |
|
|
|
|
|
Items |
TRN_2052 |
|
|
|
|
|
|
|
Items per period |
TRN_906115.rep |
|
|
|
|
|
Purchases |
TRN_302 |
|
|
|
|
|
|
|
Supplier returns per period |
TRN_3574.rep |
|
|
|
Company info |
|
|
TRN_320 |
|
|
|
|
|
|
|
Bank accounts |
TRN_183.rep |
|
|
|
|
|
|
Information |
TRN_629.rep |
|
|
|
Currencies |
|
|
TRN_3470 |
|
|
|
|
|
|
|
Currencies |
TRN_3470.rep |
|
|
|
Documents |
|
|
TRN_38 |
|
|
|
|
|
Document listing |
|
TRN_45 |
|
|
|
|
|
|
|
Document listing |
TRN_45.rep |
|
|
|
|
Document listing per account |
|
TRN_906161 |
|
|
|
|
|
|
Sales documents |
TRN_1268 |
|
|
|
|
|
|
|
Invoices |
TRN_300.rep |
|
|
|
|
|
|
Quotes |
TRN_418.rep |
|
|
|
|
|
|
Credit notes |
TRN_706.rep |
|
|
|
|
|
Purchase documents |
TRN_1269 |
|
|
|
|
|
|
|
Purchases |
TRN_302.rep |
|
|
|
|
|
|
Supplier returns |
TRN_303.rep |
|
|
|
|
|
|
Orders |
TRN_798.rep |
|
|
|
|
Unprinted document listing |
|
TRN_906162 |
|
|
|
|
|
|
Sales documents |
TRN_1268 |
|
|
|
|
|
|
|
Invoices |
TRN_300.rep |
|
|
|
|
|
|
Quotes |
TRN_418.rep |
|
|
|
|
|
|
Credit notes |
TRN_706.rep |
|
|
|
|
|
Purchase documents |
TRN_1269 |
|
|
|
|
|
|
|
Purchases |
TRN_302.rep |
|
|
|
|
|
|
Supplier returns |
TRN_303.rep |
|
|
|
|
|
|
Orders |
TRN_798.rep |
|
|
|
Sales analysis |
|
|
TRN_85 |
|
|
|
|
|
Quotes per period |
|
TRN_3568 |
|
|
|
|
|
|
|
Quotes per period - Debtor group 1 |
TRN_906301.rep |
|
|
|
|
|
|
Quotes per period - Debtor group 2 |
TRN_906302.rep |
|
|
|
|
|
|
Quotes per period - Document group 1 |
TRN_906303.rep |
|
|
|
|
|
|
Quotes per period - Document group 2 |
TRN_906304.rep |
|
|
|
|
|
|
Quotes per period - Salesperson |
TRN_906305.rep |
|
|
|
|
Invoices per period |
|
TRN_3570 |
|
|
|
|
|
|
|
Invoices per period - Debtor group 1 |
TRN_906157.rep |
|
|
|
|
|
|
Invoices per period - Debtor group 2 |
TRN_906158.rep |
|
|
|
|
|
|
Invoices per period - Document group 1 |
TRN_906159.rep |
|
|
|
|
|
|
Invoices per period - Document group 2 |
TRN_906165.rep |
|
|
|
|
|
|
Invoices per period - Salesperson |
TRN_906166.rep |
|
|
|
|
Credit notes per period |
|
TRN_3569 |
|
|
|
|
|
|
|
Credit notes per period - Debtor group 1 |
TRN_906291.rep |
|
|
|
|
|
|
Credit notes per period - Debtor group 2 |
TRN_906292.rep |
|
|
|
|
|
|
Credit notes per period - Document group 1 |
TRN_906293.rep |
|
|
|
|
|
|
Credit notes per period - Document group 2 |
TRN_906294.rep |
|
|
|
|
|
|
Credit notes per period - Salesperson |
TRN_906295.rep |
|
|
|
|
Sales per product |
|
TRN_3571 |
|
|
|
|
|
|
|
Sales per product - Stock group 1 |
TRN_906174.rep |
|
|
|
|
|
|
Sales per product - Stock group 2 |
TRN_906175.rep |
|
|
|
|
Sales per period |
|
TRN_906122 |
|
|
|
|
|
|
|
Sales per period - Debtor group 1 |
TRN_906332.rep |
|
|
|
|
|
|
Sales per period - Debtor group 2 |
TRN_906333.rep |
|
|
|
|
|
|
Sales per period - Document group 1 |
TRN_906334.rep |
|
|
|
|
|
|
Sales per period - Document group 2 |
TRN_906335.rep |
|
|
|
|
|
|
Sales per period - Salesperson |
TRN_906336.rep |
|
|
|
Tax |
|
|
TRN_906020 |
|
|
|
|
|
|
|
Tax list debtor with tax id |
TRN_3675.rep |
|
|
|
|
|
|
Tax per period |
TRN_906105.rep |
|
|
|
|
|
|
Tax report - Reference / Document no. |
TRN_906550.rep |
|
|
|
|
|
|
Tax list creditor with tax id |
TRN_906553.rep |
|
|
|
Purchase analysis |
|
|
TRN_977 |
|
|
|
|
|
Orders per period |
|
TRN_3572 |
|
|
|
|
|
|
|
Orders per period - Creditor group 1 |
TRN_906306.rep |
|
|
|
|
|
|
Orders per period - Creditor group 2 |
TRN_906307.rep |
|
|
|
|
|
|
Orders per period - Document group 1 |
TRN_906308.rep |
|
|
|
|
|
|
Orders per period - Document group 2 |
TRN_906309.rep |
|
|
|
|
|
|
Orders per period - Salesperson |
TRN_906310.rep |
|
|
|
|
Purchases per period |
|
TRN_3573 |
|
|
|
|
|
|
|
Purchases per period - Creditor group 1 |
TRN_906152.rep |
|
|
|
|
|
|
Purchases per period - Creditor group 2 |
TRN_906153.rep |
|
|
|
|
|
|
Purchases per period - Document group 1 |
TRN_906154.rep |
|
|
|
|
|
|
Purchases per period - Document group 2 |
TRN_906163.rep |
|
|
|
|
|
|
Purchases per period - Salesperson |
TRN_906164.rep |
|
|
|
|
Supplier returns per period |
|
TRN_3574 |
|
|
|
|
|
|
|
Supplier returns per period - Creditor group 1 |
TRN_906296.rep |
|
|
|
|
|
|
Supplier returns per period - Creditor group 2 |
TRN_906297.rep |
|
|
|
|
|
|
Supplier returns per period - Document group 1 |
TRN_906298.rep |
|
|
|
|
|
|
Supplier returns per period - Document group 2 |
TRN_906299.rep |
|
|
|
|
|
|
Supplier returns per period - Salesperson |
TRN_906300.rep |
|
|
|
|
Purchases per product |
|
TRN_3575 |
|
|
|
|
|
|
|
Purchases per product - Stock group 1 |
TRN_906172.rep |
|
|
|
|
|
|
Purchases per product - Stock group 2 |
TRN_906173.rep |
|
|
|
|
Purchases and Supplier returns per period |
|
TRN_906337 |
|
|
|
|
|
|
|
Purchases documents per period - Creditor group 1 |
TRN_906327.rep |
|
|
|
|
|
|
Purchases documents per period - Creditor group 2 |
TRN_906328.rep |
|
|
|
|
|
|
Purchases documents per period - Document group 1 |
TRN_906329.rep |
|
|
|
|
|
|
Purchases documents per period - Document group 2 |
TRN_906330.rep |
|
|
|
|
|
|
Purchases documents per period - Salesperson |
TRN_906331.rep |
|
|
