Structure
The Structure table defines which sub products each structure product consists of.
In the Structure table you can build up product structures to simplify order entry, purchasing and warehousing. A structure product is a product that consists of one or more sub products. Sub products can be services/appointments, internally produced products or standard purchased goods - part-finished goods or finished goods that are also sold separately. All production goods in turn have their own structure, which describes the raw materials from which the goods are produced. You can thus break down a finished product into several sub products at as many levels as you need. The same raw material can also be included in an unlimited number of structures.
Processing method exists in both the Product table and the Structure table. It has a large number of options that you can use to control how Business NXT processes each product. The Processing method in the Product table can be used to control both the structure product and underlying sub products, while the Processing method in the Structure table can be used to control individual sub products.
When you fill in the Product no. and Quantity fields for a structure product on an order line, you can choose to expand the structure. New order lines will then be inserted showing the sub products belonging to the structure product. You can either expand the structure with the Expand structure processing or automatically (requested for the current transaction type in the Processing method dialog in the Product table).
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | Struct | The table name in the database. |
| API identifier | structure | The API identifier used in GraphQL. |
| Table no. | 119 | The table number in the data model. |
The following fields exist in this table:
Account set
Used together with VAT and accounting group to get the correct VAT and accounting information on orders. It is suggested when you enter orders for the structure.
It overrides the default account set from the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account set | Integer |
| SQL name | AcSet | The database field name. |
| API identifier | accountSet | The API identifier used in GraphQL. |
| Number | 15368 |
Font
The font to be suggested on the order lines when the structure is expanded.
The field shows the font family, style and size within square brackets. In the database there are three separate fields for font family, font style and font size. The field shown on the screen keeps the font size in the database.
Is normally set with the Font command (in the Design group in the Home tab).
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Font | Integer |
| SQL name | FSz | The database field name. |
| API identifier | fontSize | The API identifier used in GraphQL. |
| Number | 3676 |
Free 1
Additional numeric information about the structure.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 11265 |
Free 2
Additional numeric information about the structure.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 11266 |
Free 3
Additional numeric information about the structure.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 11267 |
Free 4
Additional numeric information about the structure.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 11268 |
From date
The first date the structure line will be considered for an order.
The structure line is only expanded if the Trans. date field in the Order line table is within the range of the From date and To date fields.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | FrDt | The database field name. |
| API identifier | fromDate | The API identifier used in GraphQL. |
| Number | 12803 |
From week
The week when the structure line will be considered for an order.
The value is automatically calculated when a date is entered into the From date field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | fromWeek | The API identifier used in GraphQL. |
| Number | 12804 |
Gr. 1
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 1 | Integer |
| SQL name | Gr | The database field name. |
| API identifier | group1 | The API identifier used in GraphQL. |
| Number | 12815 |
Gr. 2
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 2 | Integer |
| SQL name | Gr2 | The database field name. |
| API identifier | group2 | The API identifier used in GraphQL. |
| Number | 12816 |
Gr. 3
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 3 | Integer |
| SQL name | Gr3 | The database field name. |
| API identifier | group3 | The API identifier used in GraphQL. |
| Number | 12817 |
Gr. 4
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 4 | Integer |
| SQL name | Gr4 | The database field name. |
| API identifier | group4 | The API identifier used in GraphQL. |
| Number | 12818 |
Gr. 5
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 5 | Integer |
| SQL name | Gr5 | The database field name. |
| API identifier | group5 | The API identifier used in GraphQL. |
| Number | 12819 |
Gr. 6
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 6 | Integer |
| SQL name | Gr6 | The database field name. |
| API identifier | group6 | The API identifier used in GraphQL. |
| Number | 12820 |
Gr. 7
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 7 | Integer |
| SQL name | Gr7 | The database field name. |
| API identifier | group7 | The API identifier used in GraphQL. |
| Number | 12821 |
Gr. 8
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 8 | Integer |
| SQL name | Gr8 | The database field name. |
| API identifier | group8 | The API identifier used in GraphQL. |
| Number | 12822 |
Gr. 9
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 9 | Integer |
| SQL name | Gr9 | The database field name. |
| API identifier | group9 | The API identifier used in GraphQL. |
| Number | 12823 |
Gr. 10
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 10 | Integer |
| SQL name | Gr10 | The database field name. |
| API identifier | group10 | The API identifier used in GraphQL. |
| Number | 12824 |
Gr. 11
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 11 | Integer |
| SQL name | Gr11 | The database field name. |
| API identifier | group11 | The API identifier used in GraphQL. |
| Number | 12825 |
Gr. 12
A group to which the structure line belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure grouping 12 | Integer |
| SQL name | Gr12 | The database field name. |
| API identifier | group12 | The API identifier used in GraphQL. |
| Number | 12826 |
ID
This field is no longer in use. Be aware the field may be removed in later versions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | String of length 18 | Text (18) |
| SQL name | ID | The database field name. |
| API identifier | id | The API identifier used in GraphQL. |
| Number | 2698 |
Inf. 1
Additional structure information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf | The database field name. |
| API identifier | information1 | The API identifier used in GraphQL. |
| Number | 12807 |
Inf. 2
Additional structure information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf2 | The database field name. |
| API identifier | information2 | The API identifier used in GraphQL. |
| Number | 12808 |
Inf. 3
Additional structure information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf3 | The database field name. |
| API identifier | information3 | The API identifier used in GraphQL. |
| Number | 12809 |
Inf. 4
Additional structure information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf4 | The database field name. |
| API identifier | information4 | The API identifier used in GraphQL. |
| Number | 12810 |
Inf. 5
Additional structure information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf5 | The database field name. |
| API identifier | information5 | The API identifier used in GraphQL. |
| Number | 12811 |
Inf. 6
Additional structure information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf6 | The database field name. |
| API identifier | information6 | The API identifier used in GraphQL. |
| Number | 12812 |
Inf. 7
Additional structure information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf7 | The database field name. |
| API identifier | information7 | The API identifier used in GraphQL. |
| Number | 12813 |
Inf. 8
Additional structure information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf8 | The database field name. |
| API identifier | information8 | The API identifier used in GraphQL. |
| Number | 12814 |
Line no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Product no., Line no. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 2695 |
Memo file name
The file name for the Memo attached to the structure.
Handling of the memo files is set in the Misc. tab in the Processing method dialog box in the Product table. The Copy memo from structure check box in the processing method must be selected and this field must be filled in, in order to transfer the memo to the Order line table.
On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.
Double-click or press * to open the Select file dialog box to manually select a memo file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 13774 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo no. | Integer |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19233 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
No per structure
The number of units for the sub product required per unit of the structure head.
When structures are expanded the value in this field is multiplied by the value entered in the structure head to calculate the numbers suggested in the Order line table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | NoPerStr | The database field name. |
| API identifier | quantityPerStructure | The API identifier used in GraphQL. |
| Number | 2699 |
Organisational unit 1
The organisational unit the structure is assigned to.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 11269 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
The organisational unit the structure is assigned to.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 11270 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
The organisational unit the structure is assigned to.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 11271 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
The organisational unit the structure is assigned to.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 11272 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
The organisational unit the structure is assigned to.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 11273 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
The organisational unit the structure is assigned to.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 11274 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
The organisational unit the structure is assigned to.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 11275 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
The organisational unit the structure is assigned to.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 11276 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
The organisational unit the structure is assigned to.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 11277 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
The organisational unit the structure is assigned to.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 11278 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
The organisational unit the structure is assigned to.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 11279 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
The organisational unit the structure is assigned to.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 11280 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Overridden description
The description that overrides the value from the Description field in the Product table on the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Description | Text (60) |
| SQL name | Descr | The database field name. |
| API identifier | overriddenDescription | The API identifier used in GraphQL. |
| Number | 2697 |
Proc. method 1
Settings defining the behaviour of the structure.
On all dialog box pages there is a double set of check boxes. The first column of check boxes is the main column, and this relates to the actual row. The second column is only relevant for structure products. This column describes the behaviour of the structure lines and is only available from the Product table and only when the product is a structure head.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 1 | Integer |
| SQL name | PrM1 | The database field name. |
| API identifier | processingMethod1 | The API identifier used in GraphQL. |
| Number | 6549 |
Proc. method 2
Settings defining the behaviour of the structure.
On all dialog box pages there is a double set of check boxes. The first column of check boxes is the main column, and this relates to the actual row. The second column is only relevant for structure products. This column describes the behaviour of the structure lines and is only available from the Product table and only when the product is a structure head.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 2 | Integer |
| SQL name | PrM2 | The database field name. |
| API identifier | processingMethod2 | The API identifier used in GraphQL. |
| Number | 4949 |
Proc. method 3
Settings defining the behaviour of the structure.
On all dialog box pages there is a double set of check boxes. The first column of check boxes is the main column, and this relates to the actual row. The second column is only relevant for structure products. This column describes the behaviour of the structure lines and is only available from the Product table and only when the product is a structure head.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 3 | Integer |
| SQL name | PrM3 | The database field name. |
| API identifier | processingMethod3 | The API identifier used in GraphQL. |
| Number | 6550 |
Proc. method 4
Settings defining the behaviour of the structure.
On all dialog box pages there is a double set of check boxes. The first column of check boxes is the main column, and this relates to the actual row. The second column is only relevant for structure products. This column describes the behaviour of the structure lines and is only available from the Product table and only when the product is a structure head.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 4 | Integer |
| SQL name | PrM4 | The database field name. |
| API identifier | processingMethod4 | The API identifier used in GraphQL. |
| Number | 6560 |
Proc. method 5
Settings defining the behaviour of the structure.
On all dialog box pages there is a double set of check boxes. The first column of check boxes is the main column, and this relates to the actual row. The second column is only relevant for structure products. This column describes the behaviour of the structure lines and is only available from the Product table and only when the product is a structure head.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 5 | Integer |
| SQL name | PrM5 | The database field name. |
| API identifier | processingMethod5 | The API identifier used in GraphQL. |
| Number | 6561 |
Product no.
The product to which the sub product will be assigned.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| Primary key | Yes | Product no., Line no. |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 2694 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
|
Product type 1
The product type the product belongs to.
This field overrides the corresponding field from the Product table on the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product type 1 | Integer |
| SQL name | ProdTp1 | The database field name. |
| API identifier | productType1 | The API identifier used in GraphQL. |
| Number | 6109 |
Product type 2
The product type the product belongs to.
This field overrides the corresponding field from the Product table on the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product type 2 | Integer |
| SQL name | ProdTp2 | The database field name. |
| API identifier | productType2 | The API identifier used in GraphQL. |
| Number | 6110 |
Product type 3
The product type the product belongs to.
This field overrides the corresponding field from the Product table on the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product type 3 | Integer |
| SQL name | ProdTp3 | The database field name. |
| API identifier | productType3 | The API identifier used in GraphQL. |
| Number | 6111 |
Product type 4
The product type the product belongs to.
This field overrides the corresponding field from the Product table on the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product type 4 | Integer |
| SQL name | ProdTp4 | The database field name. |
| API identifier | productType4 | The API identifier used in GraphQL. |
| Number | 6112 |
Raw material
The sub product is a raw material.
If this field is selected, the transaction type 5 - Further processing gets assigned to a new order lines. Once the structure is expanded for a production order, Pick lists can be generated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | rawMaterial | The API identifier used in GraphQL. |
| Number | 16450 |
Sort seq. no.
The order of the lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort seq. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Srt | The database field name. |
| API identifier | sortSequenceNo | The API identifier used in GraphQL. |
| Number | 2701 |
Structure weight
The weight of the whole structure.
If you select Distribute amounts on structure lines in the Processing method dialog box, the structure weight is distributed among the structure lines when the structure is expanded.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | StrWgt | The database field name. |
| API identifier | structureWeight | The API identifier used in GraphQL. |
| Number | 6400 |
Sub product no.
The structure the product is assigned to.
A structure is defined as a product and one or more sub products.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| SQL name | SubProd | The database field name. |
| API identifier | subProductNo | The API identifier used in GraphQL. |
| Number | 2696 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | SubProduct |
| ||
| Search product | SubSearchProduct |
|
To date
The last date the structure line will be considered for an order.
The structure line is only expanded if the Trans. date field in the Order line table is within the range of the From date and To date fields.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | ToDt | The database field name. |
| API identifier | toDate | The API identifier used in GraphQL. |
| Number | 12805 |
To week
The last week the structure line is considered for an order.
The value is automatically calculated when a date is entered into the To date field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | toWeek | The API identifier used in GraphQL. |
| Number | 12806 |
Trans. information 1
Free grouping and information field.
The corresponding field in the Product transaction table is updated with the value from this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (40) |
| SQL name | TrInf1 | The database field name. |
| API identifier | transactionInformation1 | The API identifier used in GraphQL. |
| Number | 6115 |
Trans. information 2
Free grouping and information field.
The corresponding field in the Product transaction table is updated with the value from this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (40) |
| SQL name | TrInf2 | The database field name. |
| API identifier | transactionInformation2 | The API identifier used in GraphQL. |
| Number | 6116 |
Trans. information 3
Free grouping and information field.
The corresponding field in the Product transaction table is updated with the value from this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (40) |
| SQL name | TrInf3 | The database field name. |
| API identifier | transactionInformation3 | The API identifier used in GraphQL. |
| Number | 7080 |
Trans. information 4
Free grouping and information field.
The corresponding field in the Product transaction table is updated with the value from this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (40) |
| SQL name | TrInf4 | The database field name. |
| API identifier | transactionInformation4 | The API identifier used in GraphQL. |
| Number | 7081 |
VAT and accounting group
The VAT and accounting group for the structure.
It overrides the Default VAT and accounting group field from the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VAT and accounting group | Integer |
| SQL name | ProdGr | The database field name. |
| API identifier | taxAndAccountingGroup | The API identifier used in GraphQL. |
| Number | 15367 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT and accounting group | TaxAndAccGroup |
|
Warehouse no.
The warehouse for the sub product.
Multiple warehouses can be used for structure products. The value in this field is copied to the Order line table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| SQL name | StcNo | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 13773 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | Stock |
|
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |