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).

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameStructThe table name in the database.
API identifierstructureThe API identifier used in GraphQL.
Table no.119The 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.

Account set texts for different languages can be defined in the Text table. These texts has text type 18.
Note:
If you double-click or press * in this field, you can look up a Account set in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount setInteger
SQL nameAcSetThe database field name.
API identifieraccountSetThe API identifier used in GraphQL.
Number15368 

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).

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFontInteger
SQL nameFSzThe database field name.
API identifierfontSizeThe API identifier used in GraphQL.
Number3676 

Free 1

Additional numeric information about the structure.

Can be used to see break-line totals on break lines or for any other information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameFree1The database field name.
API identifierfree1The API identifier used in GraphQL.
Number11265 

Free 2

Additional numeric information about the structure.

Can be used to see break-line totals on break lines or for any other information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameFree2The database field name.
API identifierfree2The API identifier used in GraphQL.
Number11266 

Free 3

Additional numeric information about the structure.

Can be used to see break-line totals on break lines or for any other information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameFree3The database field name.
API identifierfree3The API identifier used in GraphQL.
Number11267 

Free 4

Additional numeric information about the structure.

Can be used to see break-line totals on break lines or for any other information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameFree4The database field name.
API identifierfree4The API identifier used in GraphQL.
Number11268 

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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameFrDtThe database field name.
API identifierfromDateThe API identifier used in GraphQL.
Number12803 

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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierfromWeekThe API identifier used in GraphQL.
Number12804 

Gr. 1

A group to which the structure line belongs.

Structure grouping 1 texts for different languages can be defined in the Text table. These texts has text type 168.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 1 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 1Integer
SQL nameGrThe database field name.
API identifiergroup1The API identifier used in GraphQL.
Number12815 

Gr. 2

A group to which the structure line belongs.

Structure grouping 2 texts for different languages can be defined in the Text table. These texts has text type 169.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 2 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 2Integer
SQL nameGr2The database field name.
API identifiergroup2The API identifier used in GraphQL.
Number12816 

Gr. 3

A group to which the structure line belongs.

Structure grouping 3 texts for different languages can be defined in the Text table. These texts has text type 170.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 3 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 3Integer
SQL nameGr3The database field name.
API identifiergroup3The API identifier used in GraphQL.
Number12817 

Gr. 4

A group to which the structure line belongs.

Structure grouping 4 texts for different languages can be defined in the Text table. These texts has text type 171.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 4 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 4Integer
SQL nameGr4The database field name.
API identifiergroup4The API identifier used in GraphQL.
Number12818 

Gr. 5

A group to which the structure line belongs.

Structure grouping 5 texts for different languages can be defined in the Text table. These texts has text type 172.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 5 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 5Integer
SQL nameGr5The database field name.
API identifiergroup5The API identifier used in GraphQL.
Number12819 

Gr. 6

A group to which the structure line belongs.

Structure grouping 6 texts for different languages can be defined in the Text table. These texts has text type 173.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 6 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 6Integer
SQL nameGr6The database field name.
API identifiergroup6The API identifier used in GraphQL.
Number12820 

Gr. 7

A group to which the structure line belongs.

Structure grouping 7 texts for different languages can be defined in the Text table. These texts has text type 174.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 7 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 7Integer
SQL nameGr7The database field name.
API identifiergroup7The API identifier used in GraphQL.
Number12821 

Gr. 8

A group to which the structure line belongs.

Structure grouping 8 texts for different languages can be defined in the Text table. These texts has text type 175.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 8 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 8Integer
SQL nameGr8The database field name.
API identifiergroup8The API identifier used in GraphQL.
Number12822 

Gr. 9

A group to which the structure line belongs.

Structure grouping 9 texts for different languages can be defined in the Text table. These texts has text type 176.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 9 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 9Integer
SQL nameGr9The database field name.
API identifiergroup9The API identifier used in GraphQL.
Number12823 

Gr. 10

A group to which the structure line belongs.

Structure grouping 10 texts for different languages can be defined in the Text table. These texts has text type 177.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 10 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 10Integer
SQL nameGr10The database field name.
API identifiergroup10The API identifier used in GraphQL.
Number12824 

Gr. 11

A group to which the structure line belongs.

Structure grouping 11 texts for different languages can be defined in the Text table. These texts has text type 178.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 11 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 11Integer
SQL nameGr11The database field name.
API identifiergroup11The API identifier used in GraphQL.
Number12825 

Gr. 12

A group to which the structure line belongs.

Structure grouping 12 texts for different languages can be defined in the Text table. These texts has text type 179.
Note:
If you double-click or press * in this field, you can look up a Structure grouping 12 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure grouping 12Integer
SQL nameGr12The database field name.
API identifiergroup12The API identifier used in GraphQL.
Number12826 

ID

This field is no longer in use. Be aware the field may be removed in later versions.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainString of length 18Text (18)
SQL nameIDThe database field name.
API identifieridThe API identifier used in GraphQL.
Number2698 

Inf. 1

Additional structure information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInfThe database field name.
API identifierinformation1The API identifier used in GraphQL.
Number12807 

Inf. 2

Additional structure information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf2The database field name.
API identifierinformation2The API identifier used in GraphQL.
Number12808 

Inf. 3

Additional structure information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf3The database field name.
API identifierinformation3The API identifier used in GraphQL.
Number12809 

Inf. 4

Additional structure information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf4The database field name.
API identifierinformation4The API identifier used in GraphQL.
Number12810 

Inf. 5

Additional structure information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf5The database field name.
API identifierinformation5The API identifier used in GraphQL.
Number12811 

Inf. 6

Additional structure information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf6The database field name.
API identifierinformation6The API identifier used in GraphQL.
Number12812 

Inf. 7

Additional structure information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf7The database field name.
API identifierinformation7The API identifier used in GraphQL.
Number12813 

Inf. 8

Additional structure information.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainInf. @Text (40)
SQL nameInf8The database field name.
API identifierinformation8The API identifier used in GraphQL.
Number12814 

Line no.

Each line in the table is given a consecutive number in the order in which they are entered.

Note:
The Line no. does not change when inserting new lines between existing ones. The Sort seq. no. specifies the order of the lines and is affected when new lines are inserted between existing lines.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Primary keyYesProduct no., Line no.
SQL nameLnNoThe database field name.
API identifierlineNoThe API identifier used in GraphQL.
Number2695 

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.

The memo can contain for example a product description, environmental information and product information which should be linked to a product.

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.

Note:
It is important that you save the file on a server and in a folder that is available to all users, otherwise users who try to open the memo will receive an error message.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMemo file nameText (260)
SQL nameNoteNmThe database field name.
API identifiermemoFileNameThe API identifier used in GraphQL.
Number13774 

Memo no.

Link to the memo for the entry.

The actual memo is stored in the Memo table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMemo no.Integer
SQL nameMemoNoThe database field name.
API identifiermemoNoThe API identifier used in GraphQL.
Number19233 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
MemoMemo
  • Memo no.

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.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainQuantityDecimal
SQL nameNoPerStrThe database field name.
API identifierquantityPerStructureThe API identifier used in GraphQL.
Number2699 

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number11269 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number11270 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number11271 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number11272 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number11273 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number11274 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainLong alphanumeric organisational unit no.Text (40)
SQL nameR7The database field name.
API identifierorgUnit7The API identifier used in GraphQL.
Number11275 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR8The database field name.
API identifierorgUnit8The API identifier used in GraphQL.
Number11276 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR9The database field name.
API identifierorgUnit9The API identifier used in GraphQL.
Number11277 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR10The database field name.
API identifierorgUnit10The API identifier used in GraphQL.
Number11278 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR11The database field name.
API identifierorgUnit11The API identifier used in GraphQL.
Number11279 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR12The database field name.
API identifierorgUnit12The API identifier used in GraphQL.
Number11280 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Overridden description

The description that overrides the value from the Description field in the Product table on the order line.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDescriptionText (60)
SQL nameDescrThe database field name.
API identifieroverriddenDescriptionThe API identifier used in GraphQL.
Number2697 

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.

A look-up opens the dialog box where you can see the following check boxes and options:

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:
Picking after invoicing will not work if using Reserve on save or creating manual reservations.
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.
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 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
If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.
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:
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.
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.
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 Processing > Order status 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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProc. method 1Integer
SQL namePrM1The database field name.
API identifierprocessingMethod1The API identifier used in GraphQL.
Number6549 

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.

A look-up opens the dialog box where you can see the following check boxes and options:

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:
Picking after invoicing will not work if using Reserve on save or creating manual reservations.
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.
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 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
If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.
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:
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.
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.
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 Processing > Order status 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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProc. method 2Integer
SQL namePrM2The database field name.
API identifierprocessingMethod2The API identifier used in GraphQL.
Number4949 

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.

A look-up opens the dialog box where you can see the following check boxes and options:

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:
Picking after invoicing will not work if using Reserve on save or creating manual reservations.
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.
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 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
If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.
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:
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.
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.
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 Processing > Order status 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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProc. method 3Integer
SQL namePrM3The database field name.
API identifierprocessingMethod3The API identifier used in GraphQL.
Number6550 

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.

A look-up opens the dialog box where you can see the following check boxes and options:

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:
Picking after invoicing will not work if using Reserve on save or creating manual reservations.
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.
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 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
If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.
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:
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.
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.
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 Processing > Order status 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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProc. method 4Integer
SQL namePrM4The database field name.
API identifierprocessingMethod4The API identifier used in GraphQL.
Number6560 

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.

A look-up opens the dialog box where you can see the following check boxes and options:

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:
Picking after invoicing will not work if using Reserve on save or creating manual reservations.
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.
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 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
If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.
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:
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.
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.
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 Processing > Order status 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.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProc. method 5Integer
SQL namePrM5The database field name.
API identifierprocessingMethod5The API identifier used in GraphQL.
Number6561 

Product no.

The product to which the sub product will be assigned.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainProduct no.Text (40)
Primary keyYesProduct no., Line no.
SQL nameProdNoThe database field name.
API identifierproductNoThe API identifier used in GraphQL.
Number2694 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
ProductProduct
  • Product no.
Search productSearchProduct
  • Product no.

Product type 1

The product type the product belongs to.

This field overrides the corresponding field from the Product table on the order line.

Product type 1 texts for different languages can be defined in the Text table. These texts has text type 19.
Note:
If you double-click or press * in this field, you can look up a Product type 1 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct type 1Integer
SQL nameProdTp1The database field name.
API identifierproductType1The API identifier used in GraphQL.
Number6109 

Product type 2

The product type the product belongs to.

This field overrides the corresponding field from the Product table on the order line.

Product type 2 texts for different languages can be defined in the Text table. These texts has text type 58.
Note:
If you double-click or press * in this field, you can look up a Product type 2 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct type 2Integer
SQL nameProdTp2The database field name.
API identifierproductType2The API identifier used in GraphQL.
Number6110 

Product type 3

The product type the product belongs to.

This field overrides the corresponding field from the Product table on the order line.

Product type 3 texts for different languages can be defined in the Text table. These texts has text type 112.
Note:
If you double-click or press * in this field, you can look up a Product type 3 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct type 3Integer
SQL nameProdTp3The database field name.
API identifierproductType3The API identifier used in GraphQL.
Number6111 

Product type 4

The product type the product belongs to.

This field overrides the corresponding field from the Product table on the order line.

Product type 4 texts for different languages can be defined in the Text table. These texts has text type 113.
Note:
If you double-click or press * in this field, you can look up a Product type 4 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct type 4Integer
SQL nameProdTp4The database field name.
API identifierproductType4The API identifier used in GraphQL.
Number6112 

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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrawMaterialThe API identifier used in GraphQL.
Number16450 

Sort seq. no.

The order of the lines.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainSort seq. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSrtThe database field name.
API identifiersortSequenceNoThe API identifier used in GraphQL.
Number2701 

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.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNo.Integer
SQL nameStrWgtThe database field name.
API identifierstructureWeightThe API identifier used in GraphQL.
Number6400 

Sub product no.

The structure the product is assigned to.

A structure is defined as a product and one or more sub products.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainProduct no.Text (40)
SQL nameSubProdThe database field name.
API identifiersubProductNoThe API identifier used in GraphQL.
Number2696 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
ProductSubProduct
  • Sub product no.
Search productSubSearchProduct
  • Sub product no.

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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameToDtThe database field name.
API identifiertoDateThe API identifier used in GraphQL.
Number12805 

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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiertoWeekThe API identifier used in GraphQL.
Number12806 

Trans. information 1

Free grouping and information field.

The corresponding field in the Product transaction table is updated with the value from this field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (40)
SQL nameTrInf1The database field name.
API identifiertransactionInformation1The API identifier used in GraphQL.
Number6115 

Trans. information 2

Free grouping and information field.

The corresponding field in the Product transaction table is updated with the value from this field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (40)
SQL nameTrInf2The database field name.
API identifiertransactionInformation2The API identifier used in GraphQL.
Number6116 

Trans. information 3

Free grouping and information field.

The corresponding field in the Product transaction table is updated with the value from this field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (40)
SQL nameTrInf3The database field name.
API identifiertransactionInformation3The API identifier used in GraphQL.
Number7080 

Trans. information 4

Free grouping and information field.

The corresponding field in the Product transaction table is updated with the value from this field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (40)
SQL nameTrInf4The database field name.
API identifiertransactionInformation4The API identifier used in GraphQL.
Number7081 

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.

VAT and accounting group texts for different languages can be defined in the Text table. These texts has text type 17.
Note:
If you double-click or press * in this field, you can look up a VAT and accounting group in the Text table.
Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainVAT and accounting groupInteger
SQL nameProdGrThe database field name.
API identifiertaxAndAccountingGroupThe API identifier used in GraphQL.
Number15367 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT and accounting groupTaxAndAccGroup
  • VAT and accounting group

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWarehouse no.Integer
SQL nameStcNoThe database field name.
API identifierwarehouseNoThe API identifier used in GraphQL.
Number13773 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
WarehouseStock
  • Warehouse no.

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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPvnThe database field name.
API identifierchangedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA 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. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA 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

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA 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.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA unique column number. 

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 18. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.