Printout Samples
Below you will find samples and comments of the list types that can be selected under the Create tab.
Log
The Log list (classified by Part number) shows all invoicing. The information shown is: Part number, Name, Product group, Customer code, Order number, Invoice date, Invoice number, Delivery note number, Seller, User (that invoiced), price Each, invoiced Quantity, Amount, Setup price (on part), Total (Amount plus Setup price), Account, CC (cost center), CU (cost unit), Project and Reference number (customer's order number per row).
Depending on how the list was classified, you will see a total for each record. Each record also shows a total for invoiced Quantity, Amount, Setup price and Total, as well as an overall total for these.
The quantity is shown in italic text if the invoiced quantity differs from the delivered quantity. By placing the cursor on the quantity you will see the delivered quantity in a so-called tooltip. This can occur for service orders if the invoicing was made using a fixed price.
Sample of a Log list, classified by Part number.
List Functions
Dependent of the classification there are two functions in the list:
- You can preview the invoices. You preview either by double-clicking on an invoice row in the list, by pressing the F3 key, or by right-clicking on the invoice row and selecting the alternative Preview on the Info menu.
- Using the alternative Show intrastat info on the Info menu (which you access by right-clicking) you can replace the columns CC, CU, and Project in the list with the columns Statistical goods code and VAT number.
Total / Week
In the Total / week list, each row shows the following information per customer and week: the invoiced Quantity, Amount, Setup price, Total (Amount plus Setup price), Contribution Margin (CM) and a calculated Contribution Ratio (CR) for that week.
And at the bottom of the list you see the total Quantity, Amount, Setup price, Total, CM for that interval, as well as the total CR. The CR is calculated per row based on the Amount and CM.
Please note that the setup price is shown in a separate column.
Sample of a Total / Week list classified by Date.
Total / Year
In the Total / year list, each row shows information per customer and year: The invoiced Quantity, Amount, Setup price, Total (Amount plus Setup price), Contribution Margin (CM) and a calculated Contribution Ratio (CR) for that year.
And at the bottom of the list you see the total Amount, Setup price, Total and total CM, as well as the total calculated CR.
Please note that the setup price is shown in a separate column.
Sample of the Only total / year list, classified by Customer code.
Only Total
In the Only total list classified by Part number, each row shows all the invoicing per part with: Quantity, Amount, Total (Amount plus Setup price), Contribution Margin (CM), CR % and Rows (invoice rows). The last column Rows will not be printed. All columns are totaled at the end of the list. This list type can also be viewed in chart form.
Sample of the Only total list classified by Part number.
Only Total, Compare Price 2
This list shows Part number, Name, Quantity, Amount, Total, which CM and CR in percent that the Standard price result in and which CM and CR in percent the Post-calculated mean price result in. You will also find columns that show Diff and Diff in percent. At the bottom of the list you will find totals of all columns.
Sample of the Only total list, classified by Part number and using the alternative Compare price. 2.
Only Total with the Show Calculation Info Option
In the Only total list with the Show calculation info option, each row shows the following information per customer: Sales, total Manufacturing cost according to the pre-calculation (specified in the columns Material, SO, Subcontract, SC and Processing) and CM (contribution margin). A minicalculator symbol is displayed on rows where there is no calculation. Furthermore, if there is no calculation you will see the M or S part's standard price in the Material column.
Sample of the Only total list with the Show calculation info option, classified by Part number.
Only Total (Classified by Order Number)
In the Only total list classified by Order number, each row shows per order number: Quantity, Amount, Setup price, Total (Amount plus Setup price), Contribution Margin (CM) and CR %. This information will be printed. The following information will also be shown but not printed: Seller, Our reference, Your reference, Goods label 1 (row 1), Goods label 2 (row 2), Rows (invoice rows) and Project number. All columns that contain values that can be added together are totaled at the end of the list.
Sample of the Only total list classified by Order number.
An Explanation of Some of the Columns in the List
- Category - the customer category.
- Amount - the total amount invoiced to this customer (i.e. both sold parts, additional order rows and sold services). This is shown in the list as a total per column.
- CM - the contribution margin. The CM is calculated here as the invoicing on the customer minus the standard price of parts sold to this customer. A customer's CM can indicate the customer's profitability. If all your overhead costs are included in the standard price, the CM represents your profit. However, if only a portion of your overhead is included in the standard price, then the customer's CM should be considered as a contribution to the overhead plus any profit, if applicable. The CM is shown in the list as a total per column.
- CR % - the contribution ratio. The CR is shown here as the CM portion as a percentage of the total invoicing for this customer. The CR is entered as a percentage.
In the lists you can preview orders with status 9 (final delivery made) by pressing F3, right-clicking or double-clicking on the row. You can also print the invoice by using the Info menu in the invoice image.