Isah provides several ways to create reports:
Overview of FastReport reports
This section describes FastReport reports.
Printing texts, documents and memos
An item on which a FastReport report is based can have texts, documents and memos linked to it. For example, the sales order header may contain a text about your company's holiday closure. When you print a report, you can choose to print the linked texts, documents and memos as well. You might want to add the text about the holiday closure in the Sales order confirmation report, for instance. Only texts with the right text type will be printed. On the sales order confirmation in our example, a sales order header text will be printed only if the text type 'MSL10, External header for sales' is used.
The list below contains the default texts printed on reports. The text type assigned to a text determines whether or not the text is printed. It is also important, however, where the text with the relevant text type was entered.
Examples
Text type |
Description |
Text must be entered on |
R1000 Purchase |
R1002 Purchase |
R1007 Sales |
R1008 Sales |
R1010 Shipping note |
R1011 Order |
R1084 Signed service task |
MPA00 |
External text - sales part |
Part |
|
|
V |
|
|
V |
|
MPA01 |
External text - purchasing part |
Part |
V |
V |
|
|
|
|
|
MPA02 |
External text - sales and purchasing part |
Part |
V |
V |
V |
|
|
V |
|
MPU00 |
External text - supplier |
Supplier |
V |
V |
|
|
|
|
|
MPU10 |
External header - purchasing |
Purchase order |
V |
V |
|
|
|
|
|
MPU11 |
External footer - purchasing |
Purchase order |
V |
V |
|
|
|
|
|
MPU20 |
External text - purchase part line |
Purchase order line |
V |
V |
|
|
|
|
|
MPU25 |
External text - purchase part line, receipt schedule |
Receipt schedule line |
V |
|
|
|
|
|
|
MPU30 |
External text - purchase equipment line |
Purchase line |
V |
|
|
|
|
|
|
MPU40 |
External text - purchase, external operation line |
Purchase line |
V |
|
|
|
|
|
|
MSL00 |
External text - customer |
Customer |
|
|
V |
|
|
V |
|
MSL10 |
External header - sales |
Sales offer/order |
|
|
V |
|
|
V |
|
MSL11 |
External footer - sales |
Sales offer/order |
|
|
V |
|
|
V |
|
MSL20 |
External text - sales line |
Sales line |
|
|
V |
|
|
V |
|
MSL30 |
External text - sales line shipping schedule |
Shipping schedule line |
|
|
V |
|
|
V |
|
MSL40 |
External header - shipping note |
Shipping note |
|
|
|
|
V |
|
|
MSL50 |
External text - shipping note line |
Shipping note line |
|
|
|
|
V |
|
|
MSL60 |
External header - sales invoice |
Sales invoice |
|
|
|
V |
|
|
|
MSL61 |
External footer - sales invoice |
Sales invoice |
|
|
|
V |
|
|
|
MSL70 |
External text - sales invoice line |
Sales invoice line |
|
|
|
V |
|
|
|
MSV00 |
External text - object |
|
|
|
|
|
|
|
|
MSV10 |
External text - service contract |
|
|
|
|
|
|
|
|
MSV20 |
External text - service contract version |
|
|
|
|
|
|
|
|
MSV30 |
Internal text service task |
Production calculation for operations |
|
|
|
|
|
|
V |
MSV40 |
External text service task |
Production calculation for operations |
|
|
|
|
|
|
V |
MZD00 |
External text - delivery condition |
Delivery condition |
V |
|
|
|
|
V |
|
MZP00 |
External text - payment condition |
Payment condition |
V |
|
|
|
|
V |
|
A distinction is made between internal and external reports. Reports intended for internal use, such as work orders, only support the printing of memos. Reports sent to customers, such as sales order confirmations, support the printing of texts, documents and memos.
Multilingual reports
You can print reports in any language. The languages supported by default are English, German and Dutch. For other languages, use the label editor to enter the translations for field names, so that the translated terms are displayed in the report. Multilingual texts, documents and memos are defined in the settings of the texts, documents and memos, rather than in the reports.
The Purchasing department will use the Purchase order report to place orders with suppliers. Depending on the purchase order type, a purchase order will be printed for parts, equipment, or external operations.
Printing requirements
In order to print the report, the following conditions must be true:
Result after printing
Once the report has been printed:
Location of the report in Isah
Purchase module, Reports folder
A work order contains all information needed for executing a production operation. Work orders are created by planners and used by production employees.
Printing requirements
In order to print the report, the following condition must be true:
Result after printing
Once the report has been printed:
Location of the report in Isah
Production modules, Work preparation folder, Reports folder
The Purchasing department uses requests for offers to request prices and delivery times from suppliers.
Printing requirements
In order to print the report, the following condition must be true:
Result after printing
Once the report has been printed:
Location of the report in Isah
Purchase module, Reports folder
The sales file card gives the Internal Sales department information about the sales offer or order and their corresponding lines. The report is intended for internal communication. Use the sales order to create appointments and record any communications with the customer.
Note: The total sum is the sum of the printed lines. If you have made a selection by status type, the sum is not the full order sum.
Location of the report in Isah
Sales module, Reports folder
The Shipping or Warehouse department uses the Shipping picklist report to collect parts intended for shipment. As a shipping line may have multiple origins, and stock properties (such as warehouse and location) can be registered for each origin, every origin has its own line.
Components
Any components to be included in the delivery mainly originate from the shipping note line, which in turn is based on the shipping schedule of the sales order. Components may, however, also originate from production. On the shipping note, such lines are displayed as underlying lines. On the picklist, they are displayed on the same level as the other lines. All components are supplementary to the lines containing parts intended for shipment.
Displaying stock locations
Stock locations of stock deliveries are displayed only if it is not clear from which warehouse or location the parts are to be picked.
Example
Five pieces must be shipped, but the shipping schedule does not specify the warehouse the parts are to be picked from. Two pieces are available in warehouse A and three pieces are available in warehouse B. In this case, there is one shipping note line with two stock location lines. The report displays two lines.
Note: The stock is transferred as soon as the shipping note is created (in other operations in Isah, stock is not transferred until the processing phase). During processing, the shipping note is corrected if there is a discrepancy between the items to be shipped based on the shipping note and the items actually prepared for shipment.
Location of the report in Isah
Shipping module, Reports folder
The Warehouse department uses the Production picklist report to collect parts needed for production.
Location of the report in Isah
Production modules, Production folder, Reports folder
The Warehouse department uses the Stock count report to count the physical stock and to register the results on the Stock counts form in Isah.
Location of the report in Isah
Stock module, Reports folder
The Sales department uses the Sales offer report to make offers to customers.
Printing requirements
In order to print the report, the following condition must be true:
Result after printing
Once the report has been printed:
Location of the report in Isah
Sales module, Reports folder
The Finances department uses the Sales invoice report to charge customers for parts and services already delivered or rendered or still to be delivered or rendered. The report can display various types of invoices: standard invoices, invoices for multiple orders, periodic invoices, final invoices, service invoices, and cost-plus invoices. For cost-plus specification lines, you can indicate for each line whether the line is to be printed by selecting the Print check box (Sales module, Lines button, Cost-plus specification button, General tab).
Printing requirements
In order to print the report, the following conditions must be true:
Result after printing
Once the report has been printed:
The fields are available in the Invoicing module, Sales invoices form.
Location of the report in Isah
Invoicing module, Reports folder
The Shipping note report contains information about the delivery of parts to customers. The Sales or Shipping department will include this report in the delivery.
Printing requirements
In order to print the report, the following conditions must be true:
Result after printing
Once the report has been printed:
The fields are available in the Invoicing module, Sales invoices form.
Location of the report in Isah
Shipping module, Reports folder
R1011 Sales order confirmation
The Sales department uses the Sales order confirmation report to confirm the goods and services to be delivered to the customer.
Printing requirements
In order to print the report, the following conditions must be true:
Result after printing
Once the report has been printed:
Location of the report in Isah
Sales module, Reports folder
The Purchasing department uses the Purchase reminder report to formally inform the supplier of non-deliveries or partial deliveries of orders.
Printing requirements
In order to print the report, the following conditions must be true:
Location of the report in Isah
Purchase module, Reports folder
R1013 Shipping note for ext. operation
The Shipping or Warehouse department includes the Shipping note for external operation report when shipping materials that are to undergo an external operation.
Printing requirements
In order to print the report, the following condition must be true:
Result after printing
Once the report has been printed:
These fields can be found in the production modules, Transaction files folder, Shipping notes for external operations form.
Location of the report in Isah
Production modules, Reports folder, Production folder
Office assistants registering hours use the report to check hours, and managers use the report to check the hours registered.
Location of the report in Isah
Time Registration module, Reports folder
The Production sheet report shows the calculation of a production file. The planner uses the report to check whether the production calculation is correct and complete.
Location of the report in Isah
Production modules, Reports folder, Work preparation folder
R1028 Commitments transactions
The Commitments transactions report lists the transactions on the ledger account 'Commitments', sorted by purchase order. The report enables the Finances and Purchasing departments to substantiate the balance of the ledger account 'Commitments'.
The report is based on the non-summarized journal entries on the Journal entries form. You can find the ledger account in the General Settings module (Ledger settings folder, Safety net accounts form, Safety net accounts 2 tab).
Location of the report in Isah
Financial module, Reports folder, Journal entries folder
R1029 Invoices to receive transactions
The Invoices to receive transactions report lists the transactions on the ledger account 'Invoices to receive', sorted by purchase order (the detail lines are sorted by purchase order, posting date and journal entry category). The report enables the Finances and Purchasing departments to substantiate the balance of the ledger account 'Invoices to receive'.
The report is based on the non-summarized journal entries on the Journal entries form. You can find the ledger account in the General Settings module (Ledger settings folder, Safety net accounts form, Safety net accounts 2 tab).
Location of the report in Isah
Financial module, Reports folder, Journal entries folder
R1030 Goods to receive transactions
The Goods to receive transactions report lists the transactions on the ledger account 'Goods to receive', sorted by purchase order (the detail lines are sorted by purchase order, posting date and journal entry category). The report enables the Finances and Purchasing departments to substantiate the balance of the ledger account 'Goods to receive'.
The report is based on the non-summarized journal entries on the Journal entries form. You can find the ledger account in the General Settings module (Ledger settings folder, Safety net accounts form, Safety net accounts 2 tab).
Location of the report in Isah
Financial module, Reports folder, Journal entries folder
R1031 Customer labels
R1032 Supplier labels
R1033 Days off card
R1034 Hour bar codes
R1035 Employee bar codes
R1036 Historical stock valuation
R1037 VAT balance
R1038 Failures including bar code
R0139 Machine (group) bar codes
R1040 Job assignments
R0141 Saw and cut list
R1042 Customer messages
R1043 Supplier messages
R1044 Service message
R1045 Service contract
R1046 Part price info
R1047 Prices by customer
R1048 Prices by supplier
R1049 WIP by sales order
R1050 Provisional turnover specification
R1051 Sums to be completed by file
R1052 Provisional purchase invoices (FinJournal)
R1053 Part calculation
R0154 Production progress
R1055 Phase comparison by order
R1056 Hours entered
R1057 Operation in part calculation
R1058 Equipment in part calculation
R1059 External operation in part calculation
R1060 Surcharge in part calculation
R1061 Credit limit information
R1062 Equipment in production file
R1063 Operation in production file
R1064 External operation in production file
R1065 Surcharge in production file
R1066 Part purchases mismatch
R1067 Equipment purchases mismatch
R1068 External operation purchases mismatch
R1069 Invoiced
R1070 Part production sheet
R1071 PR totals by sales order
R1072 Price difference in stock receipts
R1073 Journal detail
R1074 Periodic invoices turnover
R1075 Totals by export number
R1076 Goods to receive
R1077 Ledger transactions
R1078 PR by sales order
R1079 Overview of service messages
R1080 Ledger totals - offer, order and production order
R1081 Hours by period
R1082 Creditor turnover
R1083 Purchase turnover statistics