Product transaction

In this table, transactions concerning products, including finishing and realisation, are logged.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL nameProdTrThe table name in the database.
API identifierproductTransactionThe API identifier used in GraphQL.
Table no.122The table number in the data model.

The following fields exist in this table:

Account set

Used for determining the tax processing and accounting when the order line is processed.

If the field is not filled in, the system uses the Default account set field from the Company information table.

For example if you have a special offer in connection with a trade fair, and want to post these sales to separate sales accounts, you can achieve this by using a special Account set for these orders or order lines.

The original value in the field is suggested based on the value in the Order 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.
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.
DomainAccount setInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcSetThe database field name.
API identifieraccountSetThe API identifier used in GraphQL.
Number3460 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT- and accounting informationTaxAndAccountingInformation
  • VAT and accounting group
  • Account set
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Account. year/period

The accounting year and period.

The field may be in use by external reporting or analysis applications, it is not in use by Business NXT functionality. Value is found based on the Accounting period table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainYear/Per.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAcYrPrThe database field name.
API identifieraccountingYearAndPeriodThe API identifier used in GraphQL.
Number11026 

Accounting document no.

The accounting document no refers to Incoming accounting document 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.
DomainNo.Integer
SQL nameInAcDocNoThe database field name.
API identifierincomingAccountingDocumentNoThe API identifier used in GraphQL.
Number17966 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting documentIncomingAccountingDocument
  • Accounting document no.

Actual return date

The date when the return of goods took place.

When executing processing Returned from the Order table the Actual return date is gotten from the current date for selected hire/loan orders.

In the order head and in the order lines there is also a field for Expected return date, here you enter the date on which the return of goods is expected to take place.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRlRetDtThe database field name.
API identifieractualReturnDateThe API identifier used in GraphQL.
Number5033 

Actual return week

The actual return date as day number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieractualReturnWeekThe API identifier used in GraphQL.
Number5664 

Alloc. order line no.

Only used for sales orders and goods consumption lines for a production. Points to the line number of the purchase/production order to which it is allocated.

The value is filled in when running the Generate purchase/production orders processing in the Order table, or manually enter an order number in the Allocated order no. field.

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.
DomainNo.Integer
SQL nameLnPurcNoThe database field name.
API identifierallocatedOrderLineNoThe API identifier used in GraphQL.
Number13877 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
Order lineAllocatedOrderLine
  • Allocated order no.
  • Alloc. order line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Allocated order no.

Used to link a sales order line to a specific purchase or production order.

The value is filled in when running the Generate purchase/production orders processing in the Order table. By deleting the contents of this field, the allocation is withdrawn.

Note:
When using allocated order a reservation is always made against inflow quantity in the allocated order line, even if Reserve from shipments with inflow qty. has not been selected under Reservation processing in the Company information table. This is done to show that the shipment is reserved and to secure the reservation. By deleting an allocated order number, all reservations that have not been picked or finished are deleted, including reservations made for other shipments than from the allocated purchase or production order.

Order lines can be joined to purchase orders via allocated order numbers to see which sales order lines are allocated to them.

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.
DomainOrder no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePurcNoThe database field name.
API identifierallocatedOrderNoThe API identifier used in GraphQL.
Number3720 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
OrderAllocatedOrder
  • Allocated order no.
Order lineAllocatedOrderLine
  • Allocated order no.
  • Alloc. order line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Amount

The residual value of the order line , in the actual currency.

The value is the product of Price and Quantity, minus the line discounts. As the Quantity field is reduced when finished, it is the residual value of the order line that is displayed. The Price unit, Price qty. and Price factor fields are also taken into account. Totals for the whole order are accumulated in the order head.

Tip:
If the price and amount are to be the same, the quantity can be suggested as 1 via, for example, the To field for the product.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAmThe database field name.
API identifieramountInCurrencyThe API identifier used in GraphQL.
Number3459 

Amount (dom.)

The residual value of the order line , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDAmThe database field name.
API identifieramountDomesticThe API identifier used in GraphQL.
Number3353 

Amount before discount

The amount before line discounts , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieramountBeforeDiscountInCurrencyThe API identifier used in GraphQL.
Number5623 

Amount before discount (dom.)

The amount before line discounts , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieramountBeforeDiscountDomesticThe API identifier used in GraphQL.
Number5624 

Amount before discount in EURO

The amount before line discounts , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnAmount before discountEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieramountBeforeDiscountInEuroThe API identifier used in GraphQL.
Number7762 

Amount in EURO

The residual value of the order line , in Euro.

If the standard currency, given in the Company information table is defined as Currency type 2 or 3 in the Currency table, the Amount in EURO will be calculated with the exchange rate given for Euro in Sales rate field in the Currency table.

If the standard currency, defined in the Company information table is defined as Currency type 0 or 1, please read the field help for the Currency table for explanation of how the amount in Euro is calculated.
Note:
The column is a calculated column, not stored in the database, which means that Amount in EURO in all tables where it exists will be updated if the Euro exchange rate in Currency table is changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnAmountEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieramountInEuroThe API identifier used in GraphQL.
Number7763 

Area

The area of the unit used to specify the stock for the product.

The original value in the field is suggested based on the value in the Product table, if it is not overridden by the value in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAreaLThe database field name.
API identifierareaThe API identifier used in GraphQL.
Number5949 

Area per unit

The area of the product in the relevant per unit factor.

The original value in the field is suggested based on the value in the Product table, if it is not overridden by the value in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAreaUThe database field name.
API identifierareaPerUnitThe API identifier used in GraphQL.
Number5935 

Arrival/departure date

The arrival or departure date of the product.

For a purchase/production order the original value is suggested based on the value in the Sent date field plus the value in the Transport time field. Otherwise the options below are used in the following sequence:
  • Confirmed delivery date plus Transport time.
  • Required delivery date plus Transport time.
  • Trans. date plus Lead time and Transport time.
For a sales order or further processing when a product is in stock the original value is suggested based on the current date plus the value in the Assemble time field. Otherwise the options below are used in the following sequence:
  • Confirmed delivery date plus Assemble time.
  • Required delivery date plus Assemble time.
  • Trans. date plus Adm. time, Lead time and Transport time.
  • Order date.

For this field to be calculated, one or more of the delivery date calculation fields must also be selected in the Calculate delivery date field in the Company information table.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameArDtThe database field name.
API identifierarrivalOrDepartureDateThe API identifier used in GraphQL.
Number5559 

Arrival/departure week

The arrival or departure date of the product saved as day of week number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierarrivalOrDepartureWeekThe API identifier used in GraphQL.
Number5665 

Barcode

The barcode used to register the product on the order line.

Used to enter product information on an order line instead of entering the product no. By entering the barcode (e.g. with a barcode reader) on the order line the product and product information from the Barcode table are filled in on the order line.

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.
DomainBarcodeText (52)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSCdThe database field name.
API identifierbarcodeThe API identifier used in GraphQL.
Number4998 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
BarcodeBarcode
  • Barcode

Cap. asset no.

Capital asset number for the order. The field is a lookup to the Capital asset table.

The capital asset can be entered at the order line for accounting purposes if selling capital assets for own consumption or using purchase orders to purchase capital assets.

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.
DomainCap. asset no.Integer
SQL namePropNoThe database field name.
API identifiercapitalAssetNoThe API identifier used in GraphQL.
Number11017 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
Capital assetCapitalAsset
  • Cap. asset no.
Capital asset transactionCapitalAssetTransaction
  • Cap. asset no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Capital asset proc.

Can be joined to a capital asset number once for the accounting, if selling capital assets for own consumption.

Capital assets can be removed from the warehouse via the order module and posted as acquisition of the selected capital asset.

To ensure that the accounting is correct, a separate account set for this routine could/should be set up, in which it is only necessary to enter debit/credit further processing. The account can be directly from the warehouse or another account that is different from further processing for sold goods.

Which voucher series you will use for Activation of capital assets from order must be defined. This will be done in the Activ. Cap. A. Series field in the Company information table.

Entering goods out:

  • Create an order with transaction type 4 - Adjustment/internal issue or 5 - Further processing and with Order type 1 - Normal order.
  • In the order line, call up the Capital asset proc. and Cap. asset no. fields and enter the processing and the capital asset. It is possible to enter new capital assets when you look up in the field.
  • Check that there are values in the Cost price and Price fields. If these fields are not filled in, the function does not work.
  • Finish the order, the stock will be reduced and a product transaction will be created.

See also: Product transaction

Entering receipt of a purchase order

  • Create an order with transaction type 6 - Purchase and Order type 1 - Normal order.
  • On the order line for the capital asset, Visma Business checks the field Exempt from warehousing.
  • If the order line is finished, withdraw the finished quantity. If anything is reserved for the shipments that this line has created, cancel these reservations before entering of the capital asset number is possible. If cancelling the reservations is impossible this line cannot be used and this product has to be withdrawn as a normal withdrawal, see above.
  • This line will be posted to the capital asset, instead of the account, for product purchase. The field for Capital asset proc. is set to 1 - Acquisition.
Note:
Entering a valid value in this field is mandatory, when a voucher line is entered, where the debit account or credit account contains a capital asset no. If not, the voucher line will not be possible to update. On capital asset transactions, therefore the field will always contain a valid value.
The capital asset processing determines which fields in the Capital asset balance table that will be updated and is essential to achieve correct depreciations.
A look-up in this field gives you the following list of possible values:
1 - Acquisition
To be used on records concerning the main acquisition of capital assets. E.g. cars, or buildings.
2 - Addition
To be used on records concerning additions. The definition of an "addition" is e.g. winter tyres for a car or marquises on a building. Additions can be given a lifetime, that differs from the main acquisition.
3 - Revaluation
To be used on records meant to adjust the total value of a capital asset. An example when a revaluation can be performed is when a very old real estate has a much higher market value, than the book value.
Note:
Revaluation shall NOT be performed when a capital asset has a lower value than expected due to under-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.
Note:
Revaluation of capital assets is in most countries surrounded by legal restrictions and shall be performed only after accurate consideration.
4 - Devaluation
To be used on records meant to adjust the total value of a capital asset. An example when a devaluation can be performed is when the value of a real estate falls under the book value due to a financial crisis or another extraordinary occurrence.
Note:
Devaluation shall NOT be performed when a capital asset has a higher value than expected due to over-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.
Note:
Devaluation of capital assets might be surrounded by legal restrictions in your country and shall be performed only after accurate consideration.
5 - Sale
To be used on records concerning sales of capital assets.
6 - Discarded
To be used on records concerning discard of capital assets.
7 - (Not in use)
Not in use.
8 - Back transfer
Resets depreciation when capital assets are sold or discarded.
9 - Depreciation on investment
10 - Depreciation on addition
11 - Depreciation on revaluation
12 - Depreciation on devaluation
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCapital asset proc.Integer
SQL namePropPrcThe database field name.
API identifiercapitalAssetProcessingThe API identifier used in GraphQL.
Number11016 

CID code

The CID code is updated during the printout of an invoice.

During the printout calculation, the CID code is generated and copied from the order to the Product transaction table. This field is updated on invoicing of orders from the printout calculation. The calculation is only performed for orders that come from the invoice printout. When realising a selected purchase order you can enter the CID code in the Invoice receival dialog.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCID codeText (30)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCIDThe database field name.
API identifiercidThe API identifier used in GraphQL.
Number11591 

Compensate

How much the customer must compensate of the products returned from hire or loan.

Tip:
If you want to change compensate quantity, you can use the Compensate NOW field to increase or reduce the compensated quantity.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoCompThe database field name.
API identifiercompensateThe API identifier used in GraphQL.
Number4478 

Compensation price

The product price in connection with hire/loan , in the actual currency.

You can also use the field if the customer decides to buy the hire object.

For hire/loan, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCompPrThe database field name.
API identifiercompensationPriceInCurrencyThe API identifier used in GraphQL.
Number4480 

Compensation price (dom.)

The product price in connection with hire/loan , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDCompPrThe database field name.
API identifiercompensationPriceDomesticThe API identifier used in GraphQL.
Number4773 

Compensation price in EURO

The product price in connection with hire/loan , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Source columnCompensation priceEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiercompensationPriceInEuroThe API identifier used in GraphQL.
Number7825 

Confirmed delivery date

The confirmed delivery date.

The value in this field is calculated in different ways depending on the Transaction type:
1 - Sales
The current date plus the values in the Adm. time, Lead time and Transport time fields.
5 - Further processing
The value from the Required delivery date field minus the value from the Production time field from the structure head. If you have filled in the Des. prod. start date field in the Order table, the value will be set to the date when the product is available in stock.
6 - Purchase
The current date plus the value in the Lead time field.
7 - Production
The value from the Required delivery date or Order date field from the Order table. If you have filled in the Des. prod. start date field in the Order table, the value will be set to the value from Des. prod. start date plus Production time.
When you run the Confirmed processing, the selected order lines are updated with the date that you enter in the dialog box.
Note:
If you select the Do not enter confirmed delivery date when entering data check box in the Calculate delivery date field in the Company information table this field will not to be filled in automatically.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCfDelDtThe database field name.
API identifierconfirmedDeliveryDateThe API identifier used in GraphQL.
Number3719 

Confirmed delivery week

The confirmed delivery date saved as day of week number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierconfirmedDeliveryWeekThe API identifier used in GraphQL.
Number5631 

Contact

Used for entering a contact person for the order.

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.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLiaActNoThe database field name.
API identifiercontact1The API identifier used in GraphQL.
Number6225 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateContact1
  • Contact

Contact 2

An additional contact person if needed.

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.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLiaAct2The database field name.
API identifiercontact2The API identifier used in GraphQL.
Number11161 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateContact2
  • Contact 2

Control status

A free field that is editable. You can use it to label transactions.

Control status/Product trans. texts for different languages can be defined in the Text table. These texts has text type 54.
Note:
If you double-click or press * in this field, you can look up a Control status/Product trans. in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainControl status/Product trans.Integer
SQL nameCtrlThe database field name.
API identifiercontrolStatusThe API identifier used in GraphQL.
Number4352 

Corrected stock value; realisation journal line no.

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.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCorStcValRealLnNoThe database field name.
API identifiercorrectedStockValue_RealisationJournalLineNoThe API identifier used in GraphQL.
Number16605 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
Realisation journal lineCorrectedStockValue_RealisationJournalLine
  • Corrected stock value; realisation journal no.
  • Corrected stock value; realisation journal line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Corrected stock value; realisation journal no.

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.
DomainJournal no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCorStcValRealJNoThe database field name.
API identifiercorrectedStockValue_RealisationJournalNoThe API identifier used in GraphQL.
Number16604 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
Realisation journalCorrectedStockValue_RealisationJournal
  • Corrected stock value; realisation journal no.
Realisation journal lineCorrectedStockValue_RealisationJournalLine
  • Corrected stock value; realisation journal no.
  • Corrected stock value; realisation journal line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Cost currency no.

The cost currency.

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.
DomainCurrency no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCstCurThe database field name.
API identifiercostCurrencyNoThe API identifier used in GraphQL.
Number4869 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCostCurrency
  • Cost currency no.

Cost exchange rate

The currency for the costs prices.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainExchange rateDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCstExRtThe database field name.
API identifiercostExchangeRateThe API identifier used in GraphQL.
Number4870 

Cost price

The cost price for the product , in the actual currency.

The cost price in production orders is updated when the invoice is received, if the product has a new price when it is purchased.

The cost price is retrieved from the Average cost price field in the Stock balance table when order lines have transaction type:

  • 1 - Sales
  • 2 - Hire
  • 3 - Loan
  • 4 - Adjustment/internal issue
  • 5 - Further processing

The cost price is retrieved from the Average cost price field in the Price- and discount matrix table, if have not:

  • selected the Cost price from the price and discount matrix if sold out field under Price/discount processing in the Company information table
  • 0.00 in the Average cost price field in the Stock balance table

and the order lines have transaction type:

  • 6 - Purchase
  • 7 - Production

Reservations are updated correctly upon reservation. If you have selected the Calculate avg. cost price on the order line field under Processing method or in the Company information table, the order line is updated with the average cost price from reservations.

Note:
When the average cost price is being calculated, and the order line is allocated to a purchase or production order, the cost price is always updated with the value from the purchase order even if reservations have also been made against stock. This means that order lines with both allocation and reservation against stock do not have the correct cost price.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCCstPrThe database field name.
API identifiercostPriceInCurrencyThe API identifier used in GraphQL.
Number3448 

Cost price (dom.)

The cost price for the product , in the default currency.

Note:
If you change the value in this field, the Cost price (dom.) and Cost exchange rate fields are not changed. If you use currency adjustment this produces an error. You must therefore make a change in the Cost exchange rate field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCstPrThe database field name.
API identifiercostPriceDomesticThe API identifier used in GraphQL.
Number4871 

Cost price addition %

The percentage by which the net purchase price after line discounts must increase to match the cost price. Consignment costs are also included in the cost prices. This is only applicable for purchase orders.

The cost price addition is posted to the debit and credit cost addition accounts when the invoice is received on the purchase order. After that it is part of the cost price of the shipment, and it is not posted separately on sales or stock corrections.

If you use cost addition distribution from the order head, this field is calculated based on distributed cost price addition.

The field is suggested from the Product or Delivery alternative table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCstPrAddThe database field name.
API identifiercostPriceAdditionPercentThe API identifier used in GraphQL.
Number4933 

Cost price addition (dom.)

Displays the calculated Cost price addition in domestic amount.

The field displays the difference between Price and Cost price on the purchase order line, in domestic currency. The amount is calculated based on one of two options:
  • Cost price addition distributed from the order head calculated based on the values set in the Order table fields Cost price addition (dom.) and Freight processing
  • Cost price addition % calculated from Price and currency rate on the order line

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDCstAdThe database field name.
API identifiercostPriceAdditionDomesticThe API identifier used in GraphQL.
Number15903 

Country no.

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.
DomainCountry no.Integer
SQL nameCtryThe database field name.
API identifiercountryNoThe API identifier used in GraphQL.
Number17537 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
CountryCountry
  • Country no.

Currency no.

The currency for the order line.

The original value in the field is suggested based on the value in the Associate 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.
DomainCurrency no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCurThe database field name.
API identifiercurrencyNoThe API identifier used in GraphQL.
Number3451 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency
  • Currency no.

Cust. no.

The customer for sale, hire and loan orders.

The original value in the field is suggested based on the value in the Order table.

Tip:
You can use the processing Split to split the order up into one order per customer.

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.
DomainCust. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCustNoThe database field name.
API identifiercustomerNoThe API identifier used in GraphQL.
Number3436 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateCustomer
  • Cust. no.
Product customerProductCustomer
  • Product no.
  • Cust. no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Customer transactionCustomerTransaction
  • Cust. no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Customer price gr. 1

A group to which the customer belongs. The group is used for finding the correct price and discount.

Note:
The field is suggested on the basis of the invoice customer number. If you select the Price/discount on buyer check box in the Price/discount processing field in the Company information table price and discount rules for the buyer are used.

Customer price group 1 texts for different languages can be defined in the Text table. These texts has text type 12.
Note:
If you double-click or press * in this field, you can look up a Customer price group 1 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCustomer price group 1Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCustPrGrThe database field name.
API identifiercustomerPriceGroup1The API identifier used in GraphQL.
Number3749 

Customer price gr. 2

A group to which the customer belongs. The group is used for finding the correct price and discount.

Note:
The field is suggested on the basis of the invoice customer number. If you select the Price/discount on buyer check box in the Price/discount processing field in the Company information table price and discount rules for the buyer are used.

Customer price group 2 texts for different languages can be defined in the Text table. These texts has text type 73.
Note:
If you double-click or press * in this field, you can look up a Customer price group 2 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCustomer price group 2Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCustPrG2The database field name.
API identifiercustomerPriceGroup2The API identifier used in GraphQL.
Number5718 

Customer price gr. 3

A group to which the customer belongs. The group is used for finding the correct price and discount.

Note:
The field is suggested on the basis of the invoice customer number. If you select the Price/discount on buyer check box in the Price/discount processing field in the Company information table price and discount rules for the buyer are used.

Customer price group 3 texts for different languages can be defined in the Text table. These texts has text type 146.
Note:
If you double-click or press * in this field, you can look up a Customer price group 3 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCustomer price group 3Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCustPrG3The database field name.
API identifiercustomerPriceGroup3The API identifier used in GraphQL.
Number8673 

Customs

The customs duty for the product.

For purchase order lines, the original value in the field is suggested based on the value in the Delivery alternative table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmount or percentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCusThe database field name.
API identifiercustomsThe API identifier used in GraphQL.
Number6475 

Del. alt. no.

The delivery alternative. The value is used to retrieve the supplier's product number and description when printing out inquiries and purchases.

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.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDelAltNoThe database field name.
API identifierdeliveryAlternativeNoThe API identifier used in GraphQL.
Number4807 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
Delivery alternativeDeliveryAlternative
  • Product no.
  • Del. alt. no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Delivery associate no.

The delivery associate.

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.
DomainAssociate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDelActNoThe database field name.
API identifierdeliveryAssociateNoThe API identifier used in GraphQL.
Number4925 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateDeliveryAssociate
  • Delivery associate no.

Delivery method

The mode of transportation that will be used for the order line.

Delivery method texts for different languages can be defined in the Text table. These texts has text type 5.
Note:
If you double-click or press * in this field, you can look up a Delivery method in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDelivery methodInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDelMtThe database field name.
API identifierdeliveryMethodThe API identifier used in GraphQL.
Number4936 

Density per unit

The density of the product in the relevant per unit factor.

The original value in the field is suggested based on the value in the Product table, if it is not overridden by the value in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDensUThe database field name.
API identifierdensityPerUnitThe API identifier used in GraphQL.
Number6265 

Des. prod. start date

The desired production start date.

The original value in the field is suggested based on the value in the Order table.

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 nameDesProDtThe database field name.
API identifierdesiredProductionStartDateThe API identifier used in GraphQL.
Number11594 

Description

In the Order line table the Description field is automatically filled when you complete the Product no. field.

If you have filled in the Overridden description field in the Price- and discount matrix table, this description is used. The same applies when expanding structure products that have been given a different description in the Structure table.

When running processing Generate order from the Appointment table, it is the description from the appointment that is transferred and not the product description. If there is no description for the appointment, the product description is used.

When transferring from voucher lines when exporting, the product description is used if not the voucher type processing Voucher text to order line is selected.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDescriptionText (60)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDescrThe database field name.
API identifierdescriptionThe API identifier used in GraphQL.
Number3440 

Disc. %

The discount percent per unit.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc1PThe database field name.
API identifierdiscountPercent1The API identifier used in GraphQL.
Number3455 

Disc. % 2

The discount percent per unit.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc2PThe database field name.
API identifierdiscountPercent2The API identifier used in GraphQL.
Number3457 

Disc. % 3

The discount percent per unit.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc3PThe database field name.
API identifierdiscountPercent3The API identifier used in GraphQL.
Number6776 

Disc. % 4

The discount percent per unit.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc4PThe database field name.
API identifierdiscountPercent4The API identifier used in GraphQL.
Number6779 

Disc. % 5

The discount percent per unit.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc5PThe database field name.
API identifierdiscountPercent5The API identifier used in GraphQL.
Number6782 

Disc. % 6

The discount percent per unit.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc6PThe database field name.
API identifierdiscountPercent6The API identifier used in GraphQL.
Number6785 

Disc. amount

The discount amount per unit , in the actual currency.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc1AmThe database field name.
API identifierdiscountAmount1InCurrencyThe API identifier used in GraphQL.
Number3456 

Disc. amount (dom.)

The discount amount per unit , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc1DAmThe database field name.
API identifierdiscountAmount1DomesticThe API identifier used in GraphQL.
Number3587 

Disc. amount 2

The discount amount per unit , in the actual currency.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc2AmThe database field name.
API identifierdiscountAmount2InCurrencyThe API identifier used in GraphQL.
Number3458 

Disc. amount 2 (dom.)

The discount amount per unit , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc2DAmThe database field name.
API identifierdiscountAmount2DomesticThe API identifier used in GraphQL.
Number3588 

Disc. amount 2 in EURO

The discount amount per unit , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Source columnDisc. amount 2Euro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscountAmount2InEuroThe API identifier used in GraphQL.
Number7761 

Disc. amount 3

The discount amount per unit , in the actual currency.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc3AmThe database field name.
API identifierdiscountAmount3InCurrencyThe API identifier used in GraphQL.
Number6777 

Disc. amount 3 (dom.)

The discount amount per unit , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc3DAmThe database field name.
API identifierdiscountAmount3DomesticThe API identifier used in GraphQL.
Number6778 

Disc. amount 3 in EURO

The discount amount per unit , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Source columnDisc. amount 3Euro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscountAmount3InEuroThe API identifier used in GraphQL.
Number7815 

Disc. amount 4

The discount amount per unit , in the actual currency.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc4AmThe database field name.
API identifierdiscountAmount4InCurrencyThe API identifier used in GraphQL.
Number6780 

Disc. amount 4 (dom.)

The discount amount per unit , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc4DAmThe database field name.
API identifierdiscountAmount4DomesticThe API identifier used in GraphQL.
Number6781 

Disc. amount 4 in EURO

The discount amount per unit , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Source columnDisc. amount 4Euro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscountAmount4InEuroThe API identifier used in GraphQL.
Number7816 

Disc. amount 5

The discount amount per unit , in the actual currency.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc5AmThe database field name.
API identifierdiscountAmount5InCurrencyThe API identifier used in GraphQL.
Number6783 

Disc. amount 5 (dom.)

The discount amount per unit , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc5DAmThe database field name.
API identifierdiscountAmount5DomesticThe API identifier used in GraphQL.
Number6784 

Disc. amount 5 in EURO

The discount amount per unit , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Source columnDisc. amount 5Euro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscountAmount5InEuroThe API identifier used in GraphQL.
Number7817 

Disc. amount 6

The discount amount per unit , in the actual currency.

If you have selected to suggest this value on the Discount page in the Discount suggestion field in the Company information table, the original value in the field is suggested based on the value in the Price- and discount matrix table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc6AmThe database field name.
API identifierdiscountAmount6InCurrencyThe API identifier used in GraphQL.
Number6786 

Disc. amount 6 (dom.)

The discount amount per unit , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDc6DAmThe database field name.
API identifierdiscountAmount6DomesticThe API identifier used in GraphQL.
Number6787 

Disc. amount 6 in EURO

The discount amount per unit , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Source columnDisc. amount 6Euro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscountAmount6InEuroThe API identifier used in GraphQL.
Number7818 

Disc. amount in EURO

The discount amount per unit , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Source columnDisc. amountEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdiscountAmount1InEuroThe API identifier used in GraphQL.
Number7760 

Discarded

How much of the product is not returned to the warehouse and are discarded now when the product is returned from hire or loan.

Tip:
If you want to change compensate quantity, you can use the Discard NOW field to increase or reduce the discarded quantity.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoScrThe database field name.
API identifierdiscardedThe API identifier used in GraphQL.
Number4479 

Distributed discounts

The total line, group and total discounts for the order line , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDstDcThe database field name.
API identifierdistributedDiscountsInCurrencyThe API identifier used in GraphQL.
Number4188 

Distributed discounts (dom.)

The total line, group and total discounts for the order line , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDDstDcThe database field name.
API identifierdistributedDiscountsDomesticThe API identifier used in GraphQL.
Number4744 

Distributed discounts in EURO

The total line, group and total discounts for the order line , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Source columnDistributed discountsEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierdistributedDiscountsInEuroThe API identifier used in GraphQL.
Number7765 

Empl. no.

The employee that is performing the service. The field is used when entering hours.

The Empl. no. is a unique number identifying one specific Employee.

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.
DomainEmpl. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEmpNoThe database field name.
API identifieremployeeNoThe API identifier used in GraphQL.
Number3434 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateEmployee
  • Empl. no.

Employee price gr.

The employee price group used as the basis when looking up in the Price- and discount matrix table.

Employee price group texts for different languages can be defined in the Text table. These texts has text type 14.
Note:
If you double-click or press * in this field, you can look up a Employee price group in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEmployee price groupInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEmpPrGrThe database field name.
API identifieremployeePriceGroupThe API identifier used in GraphQL.
Number3747 

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

This field is a visualisation of the Count number from serial no. check box on the Serial number page in theProc. method 1 field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierenterSerialNoThe API identifier used in GraphQL.
Number6538 

EU goods stat. no.

The number identifying type of product which makes it possible to gather unified data on the same type of product throughout the EU. All deliveries made and received within the EU during the reporting period must be reported in the INTRASTAT declarations.

The original value in the field is suggested based on the value in the Product table.

This text type domain can hold 10 digits in order to comply with EU regulations.

EU goods stat. no. texts for different languages can be defined in the Text table. These texts has text type 135.
Note:
If you double-click or press * in this field, you can look up a EU goods stat. no. in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEU goods stat. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEUStatNoThe database field name.
API identifiereuGoodsStatisticsNoThe API identifier used in GraphQL.
Number5028 

Exchange quantity

If the customer finances the purchase of the product by exchanging another product or raw material, you specify the quantity per unit in this field.

For example the amount of grams of gold per unit of a ring.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameExQtyThe database field name.
API identifierexchangeQuantityThe API identifier used in GraphQL.
Number4574 

Exchange rate

The prevailing exchange rate.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainExchange rateDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameExRtThe database field name.
API identifierexchangeRateThe API identifier used in GraphQL.
Number3452 

Expected return date

The date when the goods hired or loaned are expected to be returned.

The suggested value for the field is the value from the To field plus the Disassemble time field.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameERetDtThe database field name.
API identifierexpectedReturnDateThe API identifier used in GraphQL.
Number5023 

Expected return week

The date when the goods hired or loaned are expected to be returned saved as day of week number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierexpectedReturnWeekThe API identifier used in GraphQL.
Number5663 

Factor 3

Instead of entering a quantity directly in the Order line table, you can have it calculated as the difference between the To and From fields or as the product of them and the Factor 3 field.

When the quantity is calculated as the difference between the To and From fields, it can be expressed as a quantity, time or date, depending on the quantity format selected in the Proc. method 1 field in the Order line table. If the Factor 3 field does not have any value in the Order line table, the value in this field will be imported.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFactor3The database field name.
API identifierfactor3The API identifier used in GraphQL.
Number5041 

Finish at

The time of the last finish in the order line.

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 nameFinTmThe database field name.
API identifierfinishAtThe API identifier used in GraphQL.
Number6742 

Finish date

The date when the order was last finished.

When finishing the current date is always used for the transactions. You can override the value by entering manually in the Manual finish date field.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFinDtThe database field name.
API identifierfinishDateThe API identifier used in GraphQL.
Number6542 

Finish week

The date when the order was last finished saved as day of week number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierfinishWeekThe API identifier used in GraphQL.
Number6543 

Finished by

The name of the person who last finished something in the order line.

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 nameFinByThe database field name.
API identifierfinishedByThe API identifier used in GraphQL.
Number5983 

Finished year/period

When an order line is finished, the Finished year/period field is updated in the Product transaction table. The field is derived from the Finish date field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainYear/Per.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFinYrPrThe database field name.
API identifierfinishedYearAndPeriodThe API identifier used in GraphQL.
Number9270 

Finished year/week

When an order line is finished, the Finished year/period field is updated in the Product transaction table. The field is derived from the Finish date field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainRealised year/weekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFinYrWkThe database field name.
API identifierfinishedYearAndWeekThe API identifier used in GraphQL.
Number9271 

Free 1

Additional numeric information about the order line.

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

Free 2

Additional numeric information about the order line.

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

Free 3

Additional numeric information about the order line.

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

Free 4

Additional numeric information about the order line.

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

Free quantity

The free quantity for which the customer will not be invoiced.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFreeNoThe database field name.
API identifierfreeQuantityThe API identifier used in GraphQL.
Number5811 

Freight 1

These fields are suggested from the Delivery alternative table for purchase order lines are included in the cost prices.

See also: Delivery alternative

Note:
The calculation basis for Freight and customs in % is always price before discount (domestic), as the discount given by suppliers does not normally influence calculated freight costs.

The value in these fields are shown per unit and in the default currency.

When you invoice via Business NXT EDI and you have entered product numbers in the Product no. freight 1 - Product no. freight 4 fields, you can enter the freight amount in the Freight 1 - Freight 4 fields. The freight amounts are accumulated to the freight and freight zone addition segments in the XML file. If any of the products are also present as separate order lines, these order lines are accumulated to the same segment and are not written as separate product lines.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFreight @Decimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFrAm1The database field name.
API identifierfreight1The API identifier used in GraphQL.
Number5973 

Freight 2

These fields are suggested from the Delivery alternative table for purchase order lines are included in the cost prices.

See also: Delivery alternative

Note:
The calculation basis for Freight and customs in % is always price before discount (domestic), as the discount given by suppliers does not normally influence calculated freight costs.

The value in these fields are shown per unit and in the default currency.

When you invoice via Business NXT EDI and you have entered product numbers in the Product no. freight 1 - Product no. freight 4 fields, you can enter the freight amount in the Freight 1 - Freight 4 fields. The freight amounts are accumulated to the freight and freight zone addition segments in the XML file. If any of the products are also present as separate order lines, these order lines are accumulated to the same segment and are not written as separate product lines.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFreight @Decimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFrAm2The database field name.
API identifierfreight2The API identifier used in GraphQL.
Number5974 

Freight 3

These fields are suggested from the Delivery alternative table for purchase order lines are included in the cost prices.

See also: Delivery alternative

Note:
The calculation basis for Freight and customs in % is always price before discount (domestic), as the discount given by suppliers does not normally influence calculated freight costs.

The value in these fields are shown per unit and in the default currency.

When you invoice via Business NXT EDI and you have entered product numbers in the Product no. freight 1 - Product no. freight 4 fields, you can enter the freight amount in the Freight 1 - Freight 4 fields. The freight amounts are accumulated to the freight and freight zone addition segments in the XML file. If any of the products are also present as separate order lines, these order lines are accumulated to the same segment and are not written as separate product lines.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFreight @Decimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFrAm3The database field name.
API identifierfreight3The API identifier used in GraphQL.
Number5975 

Freight 4

These fields are suggested from the Delivery alternative table for purchase order lines are included in the cost prices.

See also: Delivery alternative

Note:
The calculation basis for Freight and customs in % is always price before discount (domestic), as the discount given by suppliers does not normally influence calculated freight costs.

The value in these fields are shown per unit and in the default currency.

When you invoice via Business NXT EDI and you have entered product numbers in the Product no. freight 1 - Product no. freight 4 fields, you can enter the freight amount in the Freight 1 - Freight 4 fields. The freight amounts are accumulated to the freight and freight zone addition segments in the XML file. If any of the products are also present as separate order lines, these order lines are accumulated to the same segment and are not written as separate product lines.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFreight @Decimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFrAm4The database field name.
API identifierfreight4The API identifier used in GraphQL.
Number5976 

From

Used in conjunction with the To field for calculating the quantity.

When the quantity is calculated as the difference between to and from, it can be expressed as a quantity, time, date or factor, depending on the quantity format selected on the Editing page in the Proc. method 1 field in the Order line table.

In connection with hire/loan, you can enter the hire start date in this field when the quantity format is set to date.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFrNoThe database field name.
API identifierfromThe API identifier used in GraphQL.
Number3444 

Gross profit

The gross profit, in the default currency.

The gross profit is the difference between invoiceable amount (credit amount) and incurred costs (debit amount). Gross profit is calculated for the Transaction type = 1 - Sales.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainGross profitDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiergrossProfitDomesticThe API identifier used in GraphQL.
Number3485 

Gross weight

The sum of values in the Net weight and Tare fields.

Prices and discounts can be specified not only on the basis of the ordinary quantity field but also this field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiergrossWeightThe API identifier used in GraphQL.
Number5947 

Gross weight per unit

Calculated on the basis of the Net weight per unit and Tare fields.

The field cannot be overridden.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiergrossWeightPerUnitThe API identifier used in GraphQL.
Number5931 

Height per unit

The height of the product in the relevant per unit factor.

Suggested from the Product table, if it is not overridden by the field in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameHgtUThe database field name.
API identifierheightPerUnitThe API identifier used in GraphQL.
Number5934 

Hire period

The number of days of the hire/loan period.

This is in addition to the normal quantity field, which shows the number of copies hired/loaned.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainHire periodInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTenancyThe database field name.
API identifierhirePeriodThe API identifier used in GraphQL.
Number6171 

Inc. cost

The total incurred costs , in the actual currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCIncCstThe database field name.
API identifierincurredCostInCurrencyThe API identifier used in GraphQL.
Number3484 

Inc. cost (dom.)

The total incurred costs , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameIncCstThe database field name.
API identifierincurredCostDomesticThe API identifier used in GraphQL.
Number4873 

Incm. doc. no.

Reference to the corresponding Document comment table entry.

This field is used for order match functionality.

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.
DomainNo.Integer
SQL nameInDocNoThe database field name.
API identifierincomingDocumentNoThe API identifier used in GraphQL.
Number17822 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
Incoming documentIncomingDocument
  • Incm. doc. no.

Incurred

How much has been consumed. For various reasons, this may deviate from the invoiceable quantity. The field is relevant only for sales.

The incurred quantity is divided by the same share as the Quantity field on finishing so that the field shows the remaining incurred quantity in the order line. It is enough to enter either the quantity or the incurred quantity if they are the same.
Note:
The field is not calculated for transaction type 4 - Adjustment/internal issue and 5 - Further processing, as these are realised directly on finishing. Therefore the Inc. cost field is not calculated.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoRegThe database field name.
API identifierincurredThe API identifier used in GraphQL.
Number3446 

Inflow

The quantity that is flowing in and not finished.

These are product transactions for purchase and production orders that have not been received/finished.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInIncThe database field name.
API identifierinflowThe API identifier used in GraphQL.
Number15460 

Invoice customer no.

If the person paying the invoice is not the customer, it can be entered here. Used by the Split processing to split the order up into one order per customer.

If the Invoice customer no. field is filled in in the order head, you cannot edit the Invoice customer no. field in order lines.

When you enter a customer number in the Cust. no. field in the order head, the Invoice customer no. field in the order line is given the same value. This means that the Invoice customer no. field always has a value in the order head when you invoice a customer. You can therefore only edit the Invoice customer no. field in order lines when you are using the Split processing for an order, as you are then not entering the customer number in the order head, but in the order lines.

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.
DomainCust. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvoCustThe database field name.
API identifierinvoiceCustomerNoThe API identifier used in GraphQL.
Number3748 
Table 19. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateInvoiceCustomer
  • Invoice customer no.

Invoice date

Contains the latest date for when the order was invoiced.

If you select the Invoice date from the invoice plan option in the Order documents dialog box under the Invoicing tab, the date is retrieved from the invoice plan; otherwise the date is retrieved from the dialog box.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvoDtThe database field name.
API identifierinvoiceDateThe API identifier used in GraphQL.
Number4519 

Invoice no.

Stores the last document number of the invoice printed for the order.

The document numbers are retrieved from the voucher and document series 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.
DomainDoc. no.Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvoNoThe database field name.
API identifierinvoiceNoThe API identifier used in GraphQL.
Number4518 
Table 20. Table relations
To tablePurposeFrom columnsTo columnsComments
Customer transactionCustomerTransaction
  • Cust. no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Supplier transactionSupplierTransaction
  • Sup. no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
General ledger transactionGeneralLedgerAccountTransaction
  • Invoice no.
Capital asset transactionCapitalAssetTransaction
  • Cap. asset no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
General ledger transactionAccountTransactionVoucherNo
  • Invoice no.

Invoice reference

The number of the invoice to which the credit note refers. This is used as a cross reference in the debtors/creditors ledger entries so that it is possible to match credit notes to invoices.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDoc. no.Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvoRefThe database field name.
API identifierinvoiceReferenceThe API identifier used in GraphQL.
Number4594 

Invoice week

Here you can see the Invoice date field expressed as day number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierinvoiceWeekThe API identifier used in GraphQL.
Number5661 

Last realisation journal no.

The last realisation number that this transaction was included in.

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.
DomainJournal no.Integer
SQL nameRealJNoThe database field name.
API identifierlastRealisationJournalNoThe API identifier used in GraphQL.
Number13897 
Table 21. Table relations
To tablePurposeFrom columnsTo columnsComments
Realisation journalRealisationJournal
  • Last realisation journal no.

Length

The length of the unit used to specify the stock for the product.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLgtLThe database field name.
API identifierlengthThe API identifier used in GraphQL.
Number5948 

Length per unit

The length of the product in the relevant per unit factor.

The original value in the field is suggested based on the value in the Product table, if it is not overridden by the value in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLgtUThe database field name.
API identifierlengthPerUnitThe API identifier used in GraphQL.
Number5932 

Location

The item's location, for example a shelf number and rack number.

If you double-click or press * in the field, you will be referred to the Location or Item location table, depending of which table you have chosen to look up in the Reservation processing in the Company information table, where you can see the physical appearance and location of the item.

If you have not selected Use location control in Reservation processing in the Company information table, you are only given a warning that the location cannot be found, but you can also decide yourself what should be here.

The location for goods you receive and the value is included in shipments. In increase order lines, the location is suggested as the normal location from the Stock balance table. You can edit them in the Shipment table later. If you need more values, you can join to the Reservation table and enter a value in the equivalent field there and, if necessary, split the shipments afterwards.

When a stock transfer is performed, the value in the Location field in the Order line table is selected ahead of the value in the Location field from the Shipment from which it is picked.

If the location is not filled in on the order lines but on the reservations, the reservation rows are not overwritten on finishing.
Note:
The field is editable in the product transaction table and can affect regeneration of stock balance.

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.
DomainLocationText (18)
SQL nameLocThe database field name.
API identifierlocationThe API identifier used in GraphQL.
Number3396 
Table 22. Table relations
To tablePurposeFrom columnsTo columnsComments
LocationLocation
  • Warehouse no.
  • Location
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Margin

Calculated on the basis of the Amount field and incurred costs in the default currency in sales order lines.

The margin is calculated as the gross profit divided by the value in the Amount field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMarginDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiermarginThe API identifier used in GraphQL.
Number3486 

Memo file name

The file name for the Memo attached to the order line.

The memo file 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)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoteNmThe database field name.
API identifiermemoFileNameThe API identifier used in GraphQL.
Number4922 

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.
Number19240 
Table 23. Table relations
To tablePurposeFrom columnsTo columnsComments
MemoMemo
  • Memo no.

Net weight

The net weight of the unit used to specify the stock for the product.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNWgtLThe database field name.
API identifiernetWeightThe API identifier used in GraphQL.
Number5945 

Net weight per unit

The net weight of the product in the relevant per unit factor.

Suggested from the Product table, if it is not overridden by the field in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNWgtUThe database field name.
API identifiernetWeightPerUnitThe API identifier used in GraphQL.
Number5929 

Order jour. no.

The Order jour. no. from the Reservation table.

In the future the Order jour. no. together with the Trans. no. is used to correct or delete the product transaction.

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.
DomainJournal no.Integer
Primary keyYesOrder jour. no., Trans. no.
SQL nameJNoThe database field name.
API identifierorderJournalNoThe API identifier used in GraphQL.
Number3738 
Table 24. Table relations
To tablePurposeFrom columnsTo columnsComments
Order journalOrderJournal
  • Order jour. no.
Realisation journal lineRealisationJournalLineJournal
  • Order jour. no.
  • Trans. no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Order line no.

The Order line no. from 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.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrdLnNoThe database field name.
API identifierorderLineNoThe API identifier used in GraphQL.
Number16211 
Table 25. Table relations
To tablePurposeFrom columnsTo columnsComments
Order lineOrderLine
  • Order no.
  • Order line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Order no.

The Order no. from the Order 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.
DomainOrder no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrdNoThe database field name.
API identifierorderNoThe API identifier used in GraphQL.
Number3387 
Table 26. Table relations
To tablePurposeFrom columnsTo columnsComments
OrderOrder
  • Order no.
Realisation journal lineRealisationJournalLineOrderNo
  • Order no.
General ledger transactionAccountTransactionOrderNo
  • Order no.
Order lineOrderLine
  • Order no.
  • Order line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Order lineStructureHeadOrderLine
  • Order no.
  • Struct. head line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Order type

The value in this field is inherited from the order.

This field has only informational purposes and will show the Order type from when the transaction was created. It can be useful if the order type has been changed, or the order has been deleted. The field will only get values when the order is created or changed after upgrade to version 11.00.0.

You can change both transaction type and order type for an order which has already been entered. Business NXT will then reverse the processing of the old transaction or order type to the extent necessary in relation to the new one.

Note:
You must not change the transaction type and order type of an order that has been processed. This can mean that the order will not be processed or that stock is incorrect. If you change the order type from 1 - Normal order to 2 - Direct order, this can mean that cost prices and stock will not be correct after invoicing.

You can combine the transaction type with one of eight different order types:

Business NXT suggests order type 1 - Normal order in the Order type field in the Order head page element when entering sales orders, loan/hire orders and purchase orders. Orders generated from the Appointment table are also allocated this order type, although you can change this in the Company information table.

When you invoice direct and cash orders and save realised orders, Business NXT reserves everything you ask for, even if it is not available. If necessary, shipments are produced with negative availability.

A look-up in this field gives you the following list of possible values:
1 - Normal order
You use this for agreed or planned future goods out/goods received. You can part-deliver an order. You must finish a Normal order before you can realise it. Orders generated from the Appointment table are given this order type, but you can change this in the Company information table. This is the only order type for which you can print an order confirmation, pick list, packing slip and consignment note.
2 - Direct order
You can use direct order if you want to enter the invoicing details directly. You cannot print a pick list for this order type. Business NXT can reserve more than what is available when entering direct orders.
Note:
This applies even if you have not selected the Add shipments with negative availability field, which you can find under the Processing/Processing method/Warehouse menu item in the products or the order lines. You cannot part-deliver a direct order, as it is finished when the invoice is printed.
If you do not have enough products in stock for a "Direct order" that is to be invoiced, a separate shipment is created for the negative quantity.
3 - Cash order
A cash order is the same as a direct order, but the invoice printout is launched when you save the order. When an invoice is printed for a cash order, the current date is used as the order date when VAT is calculated. When you save a cash order a dialog box appears containing payment information. This contains information on the order amount and a field in which you can key in the amount received. You can see the difference in the Outstanding field. The dialog box also contains a field in which you enter the method of payment. The accounts are updated directly via a batch per cash order. If you do not have enough products in stock for a "Cash order" that is to be invoiced, a separate shipment is created for the negative quantity.
Note:
Credit note on cash order is allowed, if user has function access to "Allow credit note on cash order".
4 - Realised order
This order type is realised when saved, i.e. stock and statistics are updated immediately.
Note:
We recommend that this order type is not used together with transaction type 1 - Sales, as you are not able to print out or transfer to accounts.
You can use this order type when no order documents are used, e.g. in the event of adjustments.
5 - Quotation/Inquiry
You can print this order type as a quotation or inquiry, but no processing is involved. If the quotation is accepted you must change the order type to 1 - Normal order, 2 - Direct order or 3 - Cash order for the order to be processed.
6 - Unprocessed order
This order type corresponds to the quotation order, although you cannot print it out as a quotation. The order does not generate any processing, and you must change it to another order type before you can process it. An unprocessed order is useful for imported orders. When the import is complete you can change the order type so that it can be processed.
7 - Advance order
An advance order uses the same processing method as a normal order, although Business NXT does not check stock availability during order entry or whether the credit limit has been/will be exceeded.
8 - Budget order
If you select this order type it means that the order lines will not be processed, in the same way as for Unprocessed orders.
9 - Credit card order
Note:
You cannot use order type 9 - Credit card order with manual entry. It must be imported via the EDI clock.
Note:
If you change a credit card order to a different order type you cannot reset it to a credit card order, and the amount is cancelled at the card company.
You cannot enter this order type manually. You must import it using the EDI clock. This order type is intended for Internet trading programs such as Zpider, and is dependent on Zpider being installed with communication to the card company. Upon invoicing, the reserved amount is activated at the card company, with the effect that the amount is transferred from the card company. If you delete or edit order type 9 - Credit card order, the reserved amount is cancelled at the card company. It is not possible to increase the amount of such an order over and above what is specified for Invoice customer no. in the Credit card reservation addition % field. A credit card order must be finished before it can be invoiced. Order type 9 - Credit card order also requires that the Invoice reference, Currency no., Contract amount and Invoice customer no. fields are filled in for the order. The following fields are locked for editing in a credit card order:
  • Invoice customer no.
  • Invoice reference
  • Masked card no.
  • Contract amount
  • Contract amount (dom.)
  • Currency no.
  • Card company
There is a separate tab in "Order status" for credit card orders, providing information about deviations and omissions for this order type.
Note:
When you copy such an order type, all you have to do is check the box for the credit note to show that it contains order type "9. Credit card order" and a credit is sent to the card company. A credit card order may only be credited once.
It is not possible to edit such an order unless you have selected "Allow change to credit card order" for the access group under the processing "Function access/Misc.". An increase in the amount is not approved over and above the credit card reservation addition rate, even at this access level.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrder typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrdTpThe database field name.
API identifierorderTypeThe API identifier used in GraphQL.
Number17736 

Organisational unit 1

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number3468 
Table 27. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number3469 
Table 28. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number3470 
Table 29. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number3471 
Table 30. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number3472 
Table 31. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

Organisational unit 6

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number3473 
Table 32. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number9480 
Table 33. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number9481 
Table 34. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number9482 
Table 35. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number9483 
Table 36. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number9484 
Table 37. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

The organisational unit the order line is assigned to.

The original value in the field is suggested based on the value in the Order table.

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.
Number9485 
Table 38. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Original confirmed delivery date

The original confirmed delivery date.

Note:
If you have selected the Do not enter confirmed delivery date when entering data field under Calculate delivery date in the Company information table, this field will not be updated when allocating orders before the purchase order is confirmed.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFCfDelDtThe database field name.
API identifieroriginalConfirmedDeliveryDateThe API identifier used in GraphQL.
Number6304 

Original confirmed delivery week

The original confirmed delivery date saved as day of week number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifieroriginalConfirmedDeliveryWeekThe API identifier used in GraphQL.
Number6303 

Original cost price (dom.)

If you sell a product just before you change the cost price, this field records the original cost price on the product. Later you can create a voucher for the original price.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrCstPrThe database field name.
API identifieroriginalCostPriceDomesticThe API identifier used in GraphQL.
Number6813 

Original cost price addition (dom.)

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrDCstAdThe database field name.
API identifieroriginalCostPriceAdditionDomesticThe API identifier used in GraphQL.
Number18497 

Original duty

If you sell a product just before you change the duty, this field records the originally duty on the product. Later you can create a voucher for the original price.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmount or percentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrCusAmThe database field name.
API identifieroriginalDutyThe API identifier used in GraphQL.
Number6818 

Original freight 1

If you sell a product just before you change the freight, this field records the originally freight on the product. Later you can create a voucher for the original price.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFreight @Decimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrFrAmThe database field name.
API identifieroriginalFreight1The API identifier used in GraphQL.
Number6814 

Original freight 2

If you sell a product just before you change the freight, this field records the originally freight on the product. Later you can create a voucher for the original price.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFreight @Decimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrFrAm2The database field name.
API identifieroriginalFreight2The API identifier used in GraphQL.
Number6815 

Original freight 3

If you sell a product just before you change the freight, this field records the originally freight on the product. Later you can create a voucher for the original price.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFreight @Decimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrFrAm3The database field name.
API identifieroriginalFreight3The API identifier used in GraphQL.
Number6816 

Original freight 4

If you sell a product just before you change the freight, this field records the originally freight on the product. Later you can create a voucher for the original price.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainFreight @Decimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameOrFrAm4The database field name.
API identifieroriginalFreight4The API identifier used in GraphQL.
Number6817 

Original quantity

The first time you save an order line, this field is updated with the value in the Quantity field.

Note:
In production orders you can use the Calculate production start / costs processing to update the field with new values after a production run has changed. You can then use it to produce a preliminary costing before you start production.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoOrgThe database field name.
API identifieroriginalQuantityThe API identifier used in GraphQL.
Number15377 

Other location

Contains the location of where the product came from, or to which location the product is going. Valuable information when tracking the shipment transfers.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainLocationText (18)
SQL nameToLocThe database field name.
API identifierotherLocationThe API identifier used in GraphQL.
Number16411 

Other shipment no.

Contains the shipment no. of where the product came from, or to which shipment no. the product is going. Valuable information when tracking the shipment transfers.

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.
DomainShipment no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameToShpNoThe database field name.
API identifierotherShipmentNoThe API identifier used in GraphQL.
Number4808 
Table 39. Table relations
To tablePurposeFrom columnsTo columnsComments
ShipmentOtherShipment
  • Product no.
  • Other warehouse no.
  • Other shipment no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Other warehouse no.

Contains the warehouse no. of where the product came from, or to which warehouse no. the product is going. Valuable information when tracking the shipment transfers.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameToStcThe database field name.
API identifierotherWarehouseNoThe API identifier used in GraphQL.
Number3751 
Table 40. Table relations
To tablePurposeFrom columnsTo columnsComments
WarehouseTransferToWarehouse
  • Other warehouse no.
ShipmentOtherShipment
  • Product no.
  • Other warehouse no.
  • Other shipment no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Stock balanceToStockBalance
  • Product no.
  • Other warehouse no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Payment supplier no.

The alternative supplier the purchase payment is to be paid to, if it is someone else than the supplier on the order.

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.
DomainSup. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRmtSupThe database field name.
API identifierremittanceSupplierNoThe API identifier used in GraphQL.
Number4330 
Table 41. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateRemittanceSupplier
  • Payment supplier no.

Period key

The period key to be transferred to the voucher line for accrual accounting of the sales and consumed goods accounts, e.g. products for rent and licence.

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.
DomainPeriod keyInteger
SQL namePrKThe database field name.
API identifierperiodKeyNoThe API identifier used in GraphQL.
Number15864 
Table 42. Table relations
To tablePurposeFrom columnsTo columnsComments
Period keyPeriodKey
  • Period key

Picture file name

A link to the picture file for the order line.

The picture file is copied from the from the product to the order line if the Copy picture from product check box on the Misc. page in the Proc. method 1 field is selected.

Tip:
Double-clicking or pressing * in this box opens the picture. If the box is empty, a dialog box for selecting a picture file will open.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPicture file nameText (260)
SQL namePictFNmThe database field name.
API identifierpictureFileNameThe API identifier used in GraphQL.
Number8562 

Plan type

The invoice plan type, used for Invoicing according to plan.

The original value in the field is suggested based on the value in the Product table.

A look-up in this field gives you the following list of possible values:
1 - On account
This value can be selected if 1 - On account/settlement is selected in the Inv. according to plan field in the Order table.
2 - Fixed price
3 - Additional expenses
4 - Settlement
There is to be a settlement invoice on the date specified, and the fields for specifying what and how much you are to invoice will have no significance.

This value can be selected if 1 - On account/settlement is selected in the Inv. according to plan field in the Order table.

5 - Invoiced on account
This plan type is allocated automatically.
6 - Invoiced fixed price
This plan type is allocated automatically.
7 - Invoiced additional expenses
This plan type is allocated automatically.
8 - Invoiced settlement
This plan type is allocated automatically.
9 - Settled on account
This plan type is allocated automatically.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPlan typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameInvoPlLnThe database field name.
API identifierplanTypeThe API identifier used in GraphQL.
Number5750 

Price

The price of the product , in the actual currency.

The price is retrieved when you enter or change the quantity, and when you change other price criteria such as customer price group or department. Only the guideline price, from the row in which the sales price is found, is retrieved into the Order line table.

The original value in the field is suggested based on the value in the Price- and discount matrix table.

A look-up in this column opens the calculator.
Note:

Do not use this field for entry as it does not calculate back to the price field. This results in posted amounts deviating from invoice amounts in the accounts.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePriceThe database field name.
API identifierpriceInCurrencyThe API identifier used in GraphQL.
Number3454 

Price (dom.)

The price of the product , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDPriceThe database field name.
API identifierpriceDomesticThe API identifier used in GraphQL.
Number3586 

Price after discount

The unit price for the product after the line discount , in the actual currency.

Calculated on the basis of the prices and discounts in the line. If you override this field, the Disc. amount 6 field is updated.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierpriceAfterDiscountInCurrencyThe API identifier used in GraphQL.
Number4481 

Price after discount (dom.)

The unit price for the product after the line discount , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierpriceAfterDiscountDomesticThe API identifier used in GraphQL.
Number4482 

Price after discount in EURO

The unit price for the product after the line discount , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Source columnPrice after discountEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierpriceAfterDiscountInEuroThe API identifier used in GraphQL.
Number7826 

Price factor

A factor by which Price and Quantity fields can be multiplied, when calculating line amounts.

In connection with hire/loan, the hire period is generally multiplied by price and quantity when calculating line amounts. If you check the Price factor for hire orders box under Price/discount processing in the Company information table, the price factor is suggested from a table of price factors for various hire periods and multiplies by this factor. This is applicable when the amount is not to tally directly with the hire period.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePriceFThe database field name.
API identifierpriceFactorThe API identifier used in GraphQL.
Number6286 

Price in EURO

The price of the product , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Source columnPriceEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierpriceInEuroThe API identifier used in GraphQL.
Number7759 

Price qty.

The number of units the price is valid for.

The price types which will be considered the price quantity in their calculations are defined in the Price quantity extent field in the Company information table. If the field is empty or has the value 1, the given price is used as the price per unit.

The price quantity cannot be changed if there are shipments linked to the product. You can only override the price quantity in order lines which are exempt from warehousing.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePrNoThe database field name.
API identifierpriceQuantityThe API identifier used in GraphQL.
Number6175 

Price type

The type of price, for example a campaign price.

The original value in the field is suggested based on the value in the Price- and discount matrix table.

Price type texts for different languages can be defined in the Text table. These texts has text type 126.
Note:
If you double-click or press * in this field, you can look up a Price type in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPrice typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePrTpThe database field name.
API identifierpriceTypeThe API identifier used in GraphQL.
Number6395 

Price unit

The unit measurement for which prices, cost prices and consignment costs are valid.

The original value in the field is suggested based on the value in the Product table.

A look-up in this field gives you the following list of possible values:
1 - Quantity in base unit
2 - Length
3 - Area
4 - Volume
5 - Net weight
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPrice unitInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL namePrUnThe database field name.
API identifierpriceUnitThe API identifier used in GraphQL.
Number5980 

Proc. method 1

Settings defining the behaviour of the order line.

The original value in the field is suggested based on the value in the Product and Structure tables.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProcMtThe database field name.
API identifierprocessingMethod1The API identifier used in GraphQL.
Number4396 

Proc. method 2

Settings defining the behaviour of the order line.

The original value in the field is suggested based on the value in the Product and Structure tables.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameExcPrintThe database field name.
API identifierprocessingMethod2The API identifier used in GraphQL.
Number3664 

Proc. method 3

Settings defining the behaviour of the order line.

The original value in the field is suggested based on the value in the Product and Structure tables.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEditPrefThe database field name.
API identifierprocessingMethod3The API identifier used in GraphQL.
Number6551 

Proc. method 4

Settings defining the behaviour of the order line.

The original value in the field is suggested based on the value in the Product and Structure tables.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameEdFmtThe database field name.
API identifierprocessingMethod4The API identifier used in GraphQL.
Number3752 

Proc. method 5

Settings defining the behaviour of the order line.

The original value in the field is suggested based on the value in the Product and Structure tables.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSpecFuncThe database field name.
API identifierprocessingMethod5The API identifier used in GraphQL.
Number3439 

Product no.

The identifier of the product in question.

When you type in a product number in the order lines, the associated description is suggested in the Description field. You can change the description if you wish.

Note:
It is not possible to change product numbers on an order line that has reservation lines.
Note:
When entering a barcode in this field, the data will be fetched from the Product table, not from Barcode. To fetch Barcode data, enter the barcode value in the Barcode field on the order line.

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)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdNoThe database field name.
API identifierproductNoThe API identifier used in GraphQL.
Number3438 
Table 43. Table relations
To tablePurposeFrom columnsTo columnsComments
ProductProduct
  • Product no.
Search productSearchProduct
  • Product no.
Product customerProductCustomer
  • Product no.
  • Cust. no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
ShipmentShipment
  • Product no.
  • Warehouse no.
  • Shipment no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Delivery alternativeDeliveryAlternative
  • Product no.
  • Del. alt. no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
ShipmentOtherShipment
  • Product no.
  • Other warehouse no.
  • Other shipment no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Stock balanceFromStockBalance
  • Product no.
  • Warehouse no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Stock balanceToStockBalance
  • Product no.
  • Other warehouse no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Product price gr. 1

A group to which the product belongs. The value is used for looking up in the price and discount matrix.

The original value in the field is suggested based on the value in the Product table.

Product price group 1 texts for different languages can be defined in the Text table. These texts has text type 13.
Note:
If you double-click or press * in this field, you can look up a Product price group 1 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct price group 1Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdPrGrThe database field name.
API identifierproductPriceGroup1The API identifier used in GraphQL.
Number3750 

Product price gr. 2

A group to which the product belongs. The value is used for looking up in the price and discount matrix.

The original value in the field is suggested based on the value in the Product table.

Product price group 2 texts for different languages can be defined in the Text table. These texts has text type 21.
Note:
If you double-click or press * in this field, you can look up a Product price group 2 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct price group 2Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdPrG2The database field name.
API identifierproductPriceGroup2The API identifier used in GraphQL.
Number5716 

Product price gr. 3

A group to which the product belongs. The value is used for looking up in the price and discount matrix.

The original value in the field is suggested based on the value in the Product table.

Product price group 3 texts for different languages can be defined in the Text table. These texts has text type 72.
Note:
If you double-click or press * in this field, you can look up a Product price group 3 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct price group 3Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdPrG3The database field name.
API identifierproductPriceGroup3The API identifier used in GraphQL.
Number5717 

Product type 1

A group to which the product belongs.

The original value in the field is suggested based on the value in the Product or Structure table.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdTpThe database field name.
API identifierproductType1The API identifier used in GraphQL.
Number3479 

Product type 2

A group to which the product belongs.

The original value in the field is suggested based on the value in the Product or Structure table.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdTp2The database field name.
API identifierproductType2The API identifier used in GraphQL.
Number5029 

Product type 3

A group to which the product belongs.

The original value in the field is suggested based on the value in the Product or Structure table.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdTp3The database field name.
API identifierproductType3The API identifier used in GraphQL.
Number6107 

Product type 4

A group to which the product belongs.

The original value in the field is suggested based on the value in the Product or Structure table.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdTp4The database field name.
API identifierproductType4The API identifier used in GraphQL.
Number6108 

Purchase product

The product is a purchase product that is not normally held in stock.

Shows the same value as the Purchase product check box on the Misc. page in the Processing method dialog box.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBooleanInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierpurchaseProductThe API identifier used in GraphQL.
Number6375 

Quantity

The number of units for the product/service.

The field is reduced upon finishing in such a way that the outstanding quantity is displayed in the order line. On printouts the Quantity field is used to display the quantity which the printout covers. If you need to display the outstanding quantity at the same time you can call up the Outstanding field. If you want to withdraw a reservation for a product in an order, you must have zero in the Quantity field in the order line.

Note:
When there is an reduction/increase in quantity on an allocated order line, you are asked whether the order lines should be connected to order lines with the foreign key Order no.->Allocated order no., Line no.->Alloc. order line no. This connection is made from version 5.20, so you do not need to make a decision about this. If there is a connection in the settings this is used.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoInvoAbThe database field name.
API identifierquantityThe API identifier used in GraphQL.
Number3447 

Quantity in basis unit

The product of the relevant per unit factor and the quantity fields in the order line.

The Quantity in basis unit field is used as the basis when updating tables which concern the warehouse.

Note:
When changing a unit or quantity in a base unit, the shipment will be corrcted in the shipment. If the line is finished the quantity will be withdrawn and the quantity must be finished again.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoUnThe database field name.
API identifierquantityInBasisUnitThe API identifier used in GraphQL.
Number5726 

Quantity per unit

The quantity of the unit used to specify the stock for the product.

Suggested from the Product table, if it is not overridden by the field in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStUnRtThe database field name.
API identifierquantityPerUnitThe API identifier used in GraphQL.
Number3443 

Realised stock change; realisation journal line no.

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.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStcChRealLnNoThe database field name.
API identifierrealisedStockChange_RealisationJournalLineNoThe API identifier used in GraphQL.
Number16601 
Table 44. Table relations
To tablePurposeFrom columnsTo columnsComments
Realisation journal lineRealisedStockChange_RealisationJournalLine
  • Realised stock change; realisation journal no.
  • Realised stock change; realisation journal line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Realised stock change; realisation journal no.

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.
DomainJournal no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStcChRealJNoThe database field name.
API identifierrealisedStockChange_RealisationJournalNoThe API identifier used in GraphQL.
Number16600 
Table 45. Table relations
To tablePurposeFrom columnsTo columnsComments
Realisation journalRealisedStockChange_RealisationJournal
  • Realised stock change; realisation journal no.
Realisation journal lineRealisedStockChange_RealisationJournalLine
  • Realised stock change; realisation journal no.
  • Realised stock change; realisation journal line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Realised stock value; realisation journal line no.

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.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStcValRealLnNoThe database field name.
API identifierrealisedStockValue_RealisationJournalLineNoThe API identifier used in GraphQL.
Number16603 
Table 46. Table relations
To tablePurposeFrom columnsTo columnsComments
Realisation journal lineRealisedStockValue_RealisationJournalLine
  • Realised stock value; realisation journal no.
  • Realised stock value; realisation journal line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Realised stock value; realisation journal no.

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.
DomainJournal no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStcValRealJNoThe database field name.
API identifierrealisedStockValue_RealisationJournalNoThe API identifier used in GraphQL.
Number16602 
Table 47. Table relations
To tablePurposeFrom columnsTo columnsComments
Realisation journalRealisedStockValue_RealisationJournal
  • Realised stock value; realisation journal no.
Realisation journal lineRealisedStockValue_RealisationJournalLine
  • Realised stock value; realisation journal no.
  • Realised stock value; realisation journal line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Realised year/period

The realised date as year/period. Updated when you run an approval of an invoice printout.

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.
DomainYear/Per.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameYrPrThe database field name.
API identifierrealisedYearAndPeriodThe API identifier used in GraphQL.
Number5748 
Table 48. Table relations
To tablePurposeFrom columnsTo columnsComments
Statistics periodStatisticsPeriod
  • Realised year/period

Realised year/week

The Realised year/week field uses the invoice date, transaction date or the finished date as the basis for showing the year/period according to statistical periods.

Works in the same way as the Year/Per. and Account. year/period fields.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainRealised year/weekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameYrWkThe database field name.
API identifierrealisedYearAndWeekThe API identifier used in GraphQL.
Number5749 

Reference

Optional field for additional information.

The value in the field is copied to the Product transaction table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRefNoThe database field name.
API identifierreferenceThe API identifier used in GraphQL.
Number3464 

Refund no.

When you approve printed refund requests, a document number is inserted in this field.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRepNoThe database field name.
API identifierrefundNoThe API identifier used in GraphQL.
Number6507 

Required delivery date

the required delivery date.

The value is suggested based on the Transaction type of the order.

For sales, this field is suggested as equal to the order/transaction date plus administration time, lead time and transport time, and for purchases and production the lead time is added.

For hire/loan, the required delivery date is suggested as equal to the date in the From field minus the assemble time.

When you save a production order, the Required delivery date and Confirmed delivery date fields are updated in the Order line table.

The Required delivery date and Confirmed delivery date fields are calculated as follows:

  • Transaction type 7 - Production: Required delivery date and Confirmed delivery date will be set equal to the Required delivery date field from the Order table, if filled in.
  • Transaction type 5 - Further processing: Required delivery date and Confirmed delivery date will be set to Required delivery date - Production time from the structure head. Confirmed delivery date is set to the date when the product is available in stock.

If you have filled in the Des. prod. start date field in the Order table, the Desired delivery date and Confirmed delivery date will be calculated as follows:

  • Transaction type 7 - Production Required delivery date and Confirmed delivery date will be set to Desired production start date + Production time.
  • Transaction type 5 - Further processing Required delivery date will be set to Desired delivery Date - Production time from the structure head. date - Production time from the structure head. Confirmed delivery date is set to the date when the product is available in stock.
Note:
You can select an option for this field not to be filled in automatically in Calculate delivery date in the Company information table.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDelDtThe database field name.
API identifierrequiredDeliveryDateThe API identifier used in GraphQL.
Number3466 

Required delivery week

the required delivery date saved as day of week number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierrequiredDeliveryWeekThe API identifier used in GraphQL.
Number5630 

Res. no.

The Res. no. field from the Appointment table, for orders generated from the Order line table.

You can enter resource no. manually, but then the value will not have any effect on the time schedule balance for the resource.

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.
DomainRes. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameResNoThe database field name.
API identifierresourceNoThe API identifier used in GraphQL.
Number4345 
Table 49. Table relations
To tablePurposeFrom columnsTo columnsComments
ResourceResource
  • Res. no.

Responsible

The person responsible. You normally enter the official in the order head, but can override the field in the order lines.

The Empl. no. is a unique number identifying one specific Employee.

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.
DomainEmpl. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRspThe database field name.
API identifierofficialThe API identifier used in GraphQL.
Number3375 
Table 50. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateOfficial
  • Responsible

Returned

How much has been returned from hire or loan.

Tip:
If you want to change returned quantity, you can use the Return NOW field to increase or reduce the returned quantity or you can run the Returned processing in the Order, Order line or Reservation table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameNoRetThe database field name.
API identifierreturnedThe API identifier used in GraphQL.
Number4404 

Scan doc. no.

The ID of the scanned document.

Is used in connection with Visma Document Center.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL namePLDNoThe database field name.
API identifierscanDocumentNoThe API identifier used in GraphQL.
Number11193 

Scan status

The status of the scanned document.

Is used in connection with Visma Document Center.

A look-up in this field gives you the following list of possible values:
1 - Scanned document
2 - Document on flow
4 - Document finished
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainScan statusInteger
SQL namePLDFlowThe database field name.
API identifierscanStatusThe API identifier used in GraphQL.
Number11194 

Seller/buyer

You normally enter the seller/buyer in the order head, but can override the value in the order lines.

The Empl. no. is a unique number identifying one specific Employee.

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.
DomainEmpl. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSelBuyThe database field name.
API identifiersellerOrBuyerThe API identifier used in GraphQL.
Number3374 
Table 51. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateSellerOrBuyer
  • Seller/buyer

Sent date

The date on purchase orders when the goods were sent from the supplier.

The date is set when you run the Sent processing.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameRlDelDtThe database field name.
API identifiersentDateThe API identifier used in GraphQL.
Number3735 

Sent week

The date on purchase orders when the goods were sent from the supplier saved as day of week number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiersentWeekThe API identifier used in GraphQL.
Number5662 

Serial no.

The serial number for goods you receive and the number is included in shipments.

When you enter a serial number in the field, the shipment is updated with the lowest shipment number that this serial number matches.

When you enter the shipment number and the serial number is loaded, there is no check on the serial number. If you re-renter the serial number, a check is performed on the serial number.

If you have set up the product to produce a shipment for each serial number when stock increases, or to produce a reservation for each serial number when stock is reduced, and the Quantity field is greater than 1, you must enter the serial number in the reservation lines.

Note:
If the Serial no. field is blank on the order line, the reservations will not be overwritten if there is a value in Serial no. in the Reservation table at stock increase.
Note:
If you want to add in serial no. before finishing the stock increase in the Reservation table, you can select the "Calculate "Finish NOW" when entering serial no." field under the "Serial no." tab in the Processing method dialog box on the order line.
Note:
The field is editable in the product transaction table and can affect regeneration of stock balance.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainSerial no.Text (40)
SQL nameSerNoThe database field name.
API identifierserialNoThe API identifier used in GraphQL.
Number3395 

Shipment no.

The shipment from which the goods are taken or to which the goods are delivered. The field contains no value if it is not overridden, as this information is contained in the Reservation table.

If the product is set up as a serial no. product and with a check in Calculate Finish NOW when entering serial no. in the Processing method dialog box, this will also retrieve the respective shipment for this serial number.

Note:
You can turn off the function for restricting in the dialog box for the Order processing 1 field in the Company information table. If you select the field No selection on warehouse/product on shipment lookup the look-up shows all shipments regardless of the product.
Note:
To be able to reserve to shipment with an inflow quantity you must select Reserve from shipments with inflow qty. in the Reservation processing field in the Company information table.
Note:
The Processing method Allow non-existent shipment numbers will not be applicable on stock transfer orders.

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.
DomainShipment no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameShpNoThe database field name.
API identifiershipmentNoThe API identifier used in GraphQL.
Number3394 
Table 52. Table relations
To tablePurposeFrom columnsTo columnsComments
ShipmentShipment
  • Product no.
  • Warehouse no.
  • Shipment no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Shipment Trans Info 1

Information from the shipment.

If field is filled out on the shipment, this information will be transferred to the reservation at the time of the dispatch order and further on to the product transactions on realization.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (22)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameShpTrIn1The database field name.
API identifiershipmentTransactionInformation1The API identifier used in GraphQL.
Number11836 

Shipment Trans Info 2

Information from the shipment.

If field is filled out on the shipment, this information will be transferred to the reservation at the time of the dispatch order and further on to the product transactions on realization.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (22)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameShpTrIn2The database field name.
API identifiershipmentTransactionInformation2The API identifier used in GraphQL.
Number11837 

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

Source type

Information about the origin of the transaction.

The Source type field is copied to the Product transaction table. Product transactions that occur without being entered for an order are also given a value in the Source type field.

The automatically generated transactions are labelled as to their origin (for example reminder, interest note or payments). The "Origin" field is copied to the Product transaction table. Product transactions that occur without being entered for an order are also given a value in the "Origin" field.

A look-up in this field gives you the following list of possible values:
1 - Manually
2 - EDI
3 - Agreements
4 - Time to next order
5 - Generated order
6 - Split order
7 - Order copy
8 - Transfer
9 - Separate
10 - Credit order
11 - Outlay
12 - Purchase suggestion
13 - Add line
14 - Imported
15 - Stock count
16 - Visma Business Services
17 - AutoInvoice
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrder originInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSrcTpThe database field name.
API identifiersourceTypeThe API identifier used in GraphQL.
Number13783 

Sp. tax code

The special tax code for the transaction.

You can override special tax processing in the VAT- and accounting information table.

A look-up in this field gives you the following list of possible values:
1 - % of standard unit price
2 - % of line amount (after line discounts)
3 - % of line amount after distributed group and total discounts
4 - Fixed amount per unit
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainSp. tax codeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSpcTxCdThe database field name.
API identifierspecialTaxCodeThe API identifier used in GraphQL.
Number4190 

Standard price

A copy of the value in the Price field, in order to be able to post the correct discount/addition at a later stage if you should want to override the price , in the actual currency.

The standard price can also be used as the basis when calculating special tax. You can override this function for each individual product by selecting the field Do not calculate discount from standard price in the Processing method.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStPrThe database field name.
API identifierstandardPriceInCurrencyThe API identifier used in GraphQL.
Number3453 

Standard price (dom.)

A copy of the value in the Price field, in order to be able to post the correct discount/addition at a later stage if you should want to override the price , in the default currency.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameDStPrThe database field name.
API identifierstandardPriceDomesticThe API identifier used in GraphQL.
Number3585 

Standard price in EURO

A copy of the value in the Price field, in order to be able to post the correct discount/addition at a later stage if you should want to override the price , in Euro.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
Source columnStandard priceEuro
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifierstandardPriceInEuroThe API identifier used in GraphQL.
Number7758 

Stat. value 1

This is a free field where you can enter break line totals.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStat1The database field name.
API identifierstatisticsValue1The API identifier used in GraphQL.
Number5565 

Stat. value 2

This is a free field where you can enter break line totals.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStat2The database field name.
API identifierstatisticsValue2The API identifier used in GraphQL.
Number5566 

Stock change

Keeps track of stock movement within a warehouse.

The stock change will for each transaction show how the product has moved in and out of the warehouse. Movements that lead to a stock reduction are displayed as a negative figure prefixed with -. Changes that increase the stock are displayed as a positive figure.

The Stock change field displays almost the same value as the Quantity in basis unit field, the only difference is that the Stock change field also has a prefixed sign.

In the Stock change field, you can create part totals, i.e. by sorting on Product. If you have the Stock change field on the screen, you can choose to display Break lines by adding a check in the sorting.

When a hire/loan order is returned, the Stock change field is reset. If you discard the hire/loan order, the Stock change field remains with a negative discarded quantity.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStcMovThe database field name.
API identifierstockChangeThe API identifier used in GraphQL.
Number10580 

Stock costs (dom.)

The total stock cost including freight and costs.

Note:
Updated when the Cost price and Original cost price (dom.) fields are updated.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStcCstThe database field name.
API identifierwarehouseCostDomesticThe API identifier used in GraphQL.
Number15904 

Struct. head line no.

Can be used to link order lines and the main product in an expanded structure.

On an order you can link expanded order lines that belong together and the main product in a structure. When you have such a link after expanding you can use these in connection with calculation of quantity and calculation of time and date.

When the structure is expanded the expanded order lines will be linked to the structure head on the level above by inheriting the order line number that the structure head has for this order.

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.
DomainNo.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStHLnNoThe database field name.
API identifierstructureHeadLineNoThe API identifier used in GraphQL.
Number16212 
Table 53. Table relations
To tablePurposeFrom columnsTo columnsComments
Order lineStructureHeadOrderLine
  • Order no.
  • Struct. head line no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Structure level

When a structure is expanded, the structure lines are given the level of the structure head + 1.

A structure line thus has structure level 1 when the structure head has structure level 0. Any substructure lines have the value 2 and so on.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainStructure levelInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameStrStThe database field name.
API identifierstructureLevelThe API identifier used in GraphQL.
Number3672 

Suggested price

The suggested price.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
SQL nameSugPrThe database field name.
API identifiersuggestedPriceThe API identifier used in GraphQL.
Number9269 

Sup. no.

The supplier of the product.

If you have not entered the supplier number in the order head, you can enter it in the order lines. You can use the Split processing to split the order up into one order per supplier.

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.
DomainSup. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSupNoThe database field name.
API identifiersupplierNoThe API identifier used in GraphQL.
Number3437 
Table 54. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateSupplier
  • Sup. no.
Supplier transactionSupplierTransaction
  • Sup. no.
  • Invoice no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Tare

The packaging weight of the unit used to specify the stock for the product.

Allows prices and discounts to be specified not only on the basis of the ordinary quantity field but also the Tare field.

The value is suggested in the Order line table if it is not overridden by the field in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTareLThe database field name.
API identifiertareThe API identifier used in GraphQL.
Number5946 

Tare per unit

The tare of the product in the relevant per unit factor.

Suggested from the Product table, if it is not overridden by the field in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTareUThe database field name.
API identifiertarePerUnitThe API identifier used in GraphQL.
Number5930 

To

Used in conjunction with the From field for calculating the quantity.

When the quantity is calculated as the difference between to and from, it can be expressed as a quantity, time, date or factor, depending on the quantity format selected on the Editing page in the Proc. method 1 field in the Order line table.

In connection with hire/loan, you can enter the hire start date in this field when the quantity format is set to date.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameToNoThe database field name.
API identifiertoThe API identifier used in GraphQL.
Number3445 

Trans. date

The transaction date for the order.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTrDtThe database field name.
API identifiertransactionDateThe API identifier used in GraphQL.
Number3433 

Trans. group 1

A group to which the order line belongs.

The original value in the field is suggested based on the value in the Order table.

Transaction group 1 texts for different languages can be defined in the Text table. These texts has text type 20.
Note:
If you double-click or press * in this field, you can look up a Transaction group 1 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTransaction group 1Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTransGrThe database field name.
API identifiertransactionGroup1The API identifier used in GraphQL.
Number4327 

Trans. group 2

A group to which the order line belongs.

The original value in the field is suggested based on the value in the Order table.

Transaction group 2 texts for different languages can be defined in the Text table. These texts has text type 59.
Note:
If you double-click or press * in this field, you can look up a Transaction group 2 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTransaction group 2Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTransGr2The database field name.
API identifiertransactionGroup2The API identifier used in GraphQL.
Number5032 

Trans. group 3

A group to which the order line belongs.

The original value in the field is suggested based on the value in the Order table.

Transaction group 3 texts for different languages can be defined in the Text table. These texts has text type 110.
Note:
If you double-click or press * in this field, you can look up a Transaction group 3 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTransaction group 3Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTransGr3The database field name.
API identifiertransactionGroup3The API identifier used in GraphQL.
Number6101 

Trans. group 4

A group to which the order line belongs.

The original value in the field is suggested based on the value in the Order table.

Transaction group 4 texts for different languages can be defined in the Text table. These texts has text type 111.
Note:
If you double-click or press * in this field, you can look up a Transaction group 4 in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTransaction group 4Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTransGr4The database field name.
API identifiertransactionGroup4The API identifier used in GraphQL.
Number6102 

Trans. information 1

Optional field for additional information.

Note:
You can finish an order on the basis of Trans. information 1 using the Finish processing in the Order table.
Note:
Trans. information 2 is used for the customer's product number if you have selected the Suggest customer product no. option in the Order processing 2 field in the Company information table.

The original value in the field is suggested based on the value in the Product or Structure table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTrInf1The database field name.
API identifiertransactionInformation1The API identifier used in GraphQL.
Number6119 

Trans. information 2

Optional field for additional information.

Note:
You can finish an order on the basis of Trans. information 1 using the Finish processing in the Order table.
Note:
Trans. information 2 is used for the customer's product number if you have selected the Suggest customer product no. option in the Order processing 2 field in the Company information table.

The original value in the field is suggested based on the value in the Product or Structure table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTrInf2The database field name.
API identifiertransactionInformation2The API identifier used in GraphQL.
Number6120 

Trans. information 3

Optional field for additional information.

Note:
You can finish an order on the basis of Trans. information 1 using the Finish processing in the Order table.
Note:
Trans. information 2 is used for the customer's product number if you have selected the Suggest customer product no. option in the Order processing 2 field in the Company information table.

The original value in the field is suggested based on the value in the Product or Structure table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTrInf3The database field name.
API identifiertransactionInformation3The API identifier used in GraphQL.
Number7084 

Trans. information 4

Optional field for additional information.

Note:
You can finish an order on the basis of Trans. information 1 using the Finish processing in the Order table.
Note:
Trans. information 2 is used for the customer's product number if you have selected the Suggest customer product no. option in the Order processing 2 field in the Company information table.

The original value in the field is suggested based on the value in the Product or Structure table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. information @Text (40)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTrInf4The database field name.
API identifiertransactionInformation4The API identifier used in GraphQL.
Number7085 

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

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.
DomainNo.Integer
Primary keyYesOrder jour. no., Trans. no.
SQL nameTrNoThe database field name.
API identifiertransactionNoThe API identifier used in GraphQL.
Number3386 
Table 55. Table relations
To tablePurposeFrom columnsTo columnsComments
Realisation journal lineRealisationJournalLineJournal
  • Order jour. no.
  • Trans. no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Trans. status

Changes automatically depending on the choices you made earlier with regard to costs and corrections.

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

Realisation

Temporary costs
The stock reduction has been picked from a shipment that has not been realised.
Costs corrected
The product transaction has been processed running the Post cost processing, so that the line is not processed again.
Corrected costs posted
Complete costs posted
The product transaction has been processed running the Post cost processing, so that the line is not processed again.
Costs posted on product in work
Temp. stock value accounted
The product transaction has been processed running the ../../../business/auto/task/t_p_producttransaction_posttemporarystockvalue.html processing, so that the line is not processed again.
Reversed temp. stock value accounted
The product transaction has been processed running the Reverse temporary stock value processing, so that the line is not processed again.
Waiting for realisation
The stock increase has not been realised.
Quantity corrected
The quantity has been changed in relation to when it was created. For example the order is cancelled, or a stock transfer is undertaken before receipt of invoice, or a split of shipments.

Internal accounting

Internal invoiced
The product transaction has been processed using the Internal invoicing menu item, so that the line is not processed again.
Activated as capital asset
When you activate a product transactions where you enter a fixed asset, then this will be checked automatically, so you can not activate the same transaction multiple times.
Account debit/credit freight 1-4 and customs on purchase
If you have selected this field then purchase orders that are added with freight 1-4 and maybe custom duties. Sales orders are not affected by this choice. You will automatically get this field selected if you have selected it in the corresponding fields in Transp. agr. processing in Company information table. Selection can also be set in the VAT and accounting processing field in the VAT- and accounting information table and in the Processing method field in the Product table. 

Processing of appointments

Transferred from appointments
The order line was created running the ../../../business/auto/task/t_p_appointment_generateorder.html processing.
Time schedule approved
The activity line was approved in the time schedule before transfer.
Transferred to wage
The activity line was transferred to the salary file before transfer.

Corrected

Manually corrected
DDS reference overflow
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTrans. statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTransStThe database field name.
API identifiertransactionStatusThe API identifier used in GraphQL.
Number6812 

Trans. week

The transaction date for the order saved as day of week number, week number and year.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiertransactionWeekThe API identifier used in GraphQL.
Number5626 

Trans. Year/period

Contains the year and period on the basis of the transaction date in the format YYYYPP in the database.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainYear/Per.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTrYrPrThe database field name.
API identifiertransactionYearAndPeriodThe API identifier used in GraphQL.
Number11008 

Transaction type

The transaction type for the product defining the way the goods move in or out of the warehouse.

Note:
It is not possible to change the transaction type in an order line that is Reserved, Picked or Finished; in this case you must withdraw the reservation.
A look-up in this field gives you the following list of possible values:
1 - Sales
Normal sale.

The goods move out of the warehouse.

2 - Hire
Hire against payment.

The goods move out of the warehouse.

3 - Loan
Loan of goods without payment.

The goods move out of the warehouse.

4 - Adjustment/internal issue
Registration of goods that have been lost.

The goods move out of the warehouse.

5 - Further processing
Internal consumption of goods for further processing.

The goods move out of the warehouse.

6 - Purchase
Goods that are purchased from other parties.

The goods move into of the warehouse.

7 - Production
Goods produced by the company itself.

The goods move into of the warehouse.

8 - Stock transfer
Transfer of stock between the company's own warehouses.

You can also use this transaction type when performing a stock transfer of unrealised transactions. It is not possible to reserve or finish inflow transactions on stock transfer orders.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainTransaction typeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameTrTpThe database field name.
API identifiertransactionTypeThe API identifier used in GraphQL.
Number3711 

Transp. agr. no.

The supplier's transport agreement number.

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.
DomainTransp. agr. no.Integer
SQL nameTspAgrNoThe database field name.
API identifiertransportAgreementNoThe API identifier used in GraphQL.
Number9068 
Table 56. Table relations
To tablePurposeFrom columnsTo columnsComments
Transport agreementTransportAgreement
  • Transp. agr. no.

Unit

The unit for the product.

The default unit from the Delivery alternative table if it is entered, or the Default unit from the Product table.

Unit texts for different languages can be defined in the Text table. These texts has text type 16.
Note:
If you double-click or press * in this field, you can look up a Unit 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.
DomainUnitInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameUnThe database field name.
API identifierunitThe API identifier used in GraphQL.
Number3442 
Table 57. Table relations
To tablePurposeFrom columnsTo columnsComments
UnitUnit
  • Unit

Use by date

The use by date for goods you receive.

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 nameDurDtThe database field name.
API identifieruseByDateThe API identifier used in GraphQL.
Number3397 

Use by week

The use by date for goods you receive saved as day of week number, week number and year.

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 identifieruseByWeekThe API identifier used in GraphQL.
Number5632 

VAT and accounting group

The VAT and accounting group for the product that controls tax processing and determines which accounts and organisational units are used for accounting.

Together with the account set on the Order line, this field refers to the VAT- and accounting information table.

If you do not complete this field in the Product table, the Default VAT and accounting group is retrieved 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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameProdGrThe database field name.
API identifiertaxAndAccountingGroupThe API identifier used in GraphQL.
Number3378 
Table 58. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT- and accounting informationTaxAndAccountingInformation
  • VAT and accounting group
  • Account set
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
VAT and accounting groupTaxAndAccGroup
  • VAT and accounting group

VAT code

The tax code from the order.

In the VAT code field in the order head you can override the tax code.

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 codeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVatNoThe database field name.
API identifiertaxCodeThe API identifier used in GraphQL.
Number3461 
Table 59. Table relations
To tablePurposeFrom columnsTo columnsComments
VAT codeTaxCode
  • VAT code

VAT rate

The VAT rate on the line.

On order documents you can choose to edit out the VAT rate.

The VAT rate will be copied from the order line to the product transaction. The VAT rate will be updated from the order line if it has been changed after the product transaction was created and before the invoice was printed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPercentDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVatRtThe database field name.
API identifiervatRateThe API identifier used in GraphQL.
Number16314 

Visma ID

The ID of the scanned document.

Is used in connection with Visma Document Center.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
SQL nameWfIdThe database field name.
API identifiervismaIdThe API identifier used in GraphQL.
Number11192 

Volume

The volume of the unit used to specify the stock for the product.

This field allows prices and discounts to be specified not only on the basis of the ordinary Quantity field but also the Volume field. This field is totalled in the order head in order to be able to calculate the order's total volume.

The value is suggested in the Order line table if it is not overridden by the field in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVolLThe database field name.
API identifiervolumeThe API identifier used in GraphQL.
Number5950 

Volume per unit

The volume of the product in the relevant per unit factor.

Suggested from the Product table, if it is not overridden by the field in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameVolUThe database field name.
API identifiervolumePerUnitThe API identifier used in GraphQL.
Number5936 

Wage info 1

Can be used for integration with payroll systems.

You complete the fields if you have a wage sort which requires additional information for presentation in the employee's PAYE report. When transferring from appointments, the value from there is used.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWage info 1Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAdWage1The database field name.
API identifierpayrollInformation1The API identifier used in GraphQL.
Number3475 

Wage info 2

Can be used for integration with payroll systems.

You complete the fields if you have a wage sort which requires additional information for presentation in the employee's PAYE report. When transferring from appointments, the value from there is used.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWage info 2Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameAdWage2The database field name.
API identifierpayrollInformation2The API identifier used in GraphQL.
Number3476 

Wage rate no.

The rate to be used for the wage sort in the transfer to the wage file.

The value is transferred to the Appointment table. It will be used when appointments are exported to file and sent to the wage system.

Wage rate no. texts for different languages can be defined in the Text table. These texts has text type 15.
Note:
If you double-click or press * in this field, you can look up a Wage rate no. in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWage rate no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWageRtNoThe database field name.
API identifierpayrollRateNoThe API identifier used in GraphQL.
Number3435 

Wage sort

The type of wage used in the transfer to the wage file.

The value is transferred to the Appointment table. It will be used when appointments are exported to file and sent to the wage system.

Tip:
It is recommended to place the wage sort in the Product table, to avoid typing it in the Appointment table for each appointment.
Note:
There is no validation against the Wage sort register. The value must correspond with the payroll system.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWage sortText (10)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWageSrtThe database field name.
API identifierpayrollSortThe API identifier used in GraphQL.
Number3474 

Warehouse no.

The warehouse from which the goods are collected or to which the goods are delivered.

When you enter a value in the Delivery associate no. field, the warehouse number is suggested.

Increase order lines that do not have reservation rows, for example credit orders with transaction type 1 - Sales, are not blocked from changing the warehouse number.

You can change the Warehouse no. on order lines that lead to a stock increase as long as it has not be reserved by other orders, or as long as something has been realised on the order line.

Note:
If something is finished on the line, this will be withdrawn if the warehouse no is changed and it must be finished again against the new warehouse.

When processing the order lines, the information in the order head is used if it has not been filled in in the order lines. Information specified in the order lines overrides the information in the order head. This applies, for example, to warehouse numbers. The warehouse number specified in the order line overrides the warehouse number specified in the order head. The warehouse number in the order head is suggested again based on the consignee. If a consignee is not specially specified, it is the same as the customer or supplier, depending on the transaction type.

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
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameFrStcThe database field name.
API identifierwarehouseNoThe API identifier used in GraphQL.
Number3441 
Table 60. Table relations
To tablePurposeFrom columnsTo columnsComments
WarehouseWarehouse
  • Warehouse no.
ShipmentShipment
  • Product no.
  • Warehouse no.
  • Shipment no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
LocationLocation
  • Warehouse no.
  • Location
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.
Stock balanceFromStockBalance
  • Product no.
  • Warehouse no.
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Web page

The address of a web page for the order line. The default value is the web page from the product.

Double-click or press * to open the web page in your web browser.

Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.

On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeb pageText (260)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWebPgThe database field name.
API identifierwebPageThe API identifier used in GraphQL.
Number8930 

Width per unit

The width of the product in the relevant per unit factor.

Suggested from the Product table, if it is not overridden by the field in the Unit or Barcode table.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameWdtUThe database field name.
API identifierwidthPerUnitThe API identifier used in GraphQL.
Number5933 

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 61. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.