Product transaction before compression
This table keeps a copy of product transactions before they were compressed.
Rows are added by the Compress transactions processing in the Product transaction table.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | ProdTr2 | The table name in the database. |
| API identifier | productTransaction2 | The API identifier used in GraphQL. |
| Table no. | 342 | The 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.
The original value in the field is suggested based on the value in the Order table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account set | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcSet | The database field name. |
| API identifier | accountSet | The API identifier used in GraphQL. |
| Number | 14037 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT- and accounting information | TaxAndAccountingInformation |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcYrPr | The database field name. |
| API identifier | accountingYearAndPeriod | The API identifier used in GraphQL. |
| Number | 14209 |
Accounting document no.
The accounting document no refers to Incoming accounting document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | InAcDocNo | The database field name. |
| API identifier | incomingAccountingDocumentNo | The API identifier used in GraphQL. |
| Number | 17967 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting document | IncomingAccountingDocument |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RlRetDt | The database field name. |
| API identifier | actualReturnDate | The API identifier used in GraphQL. |
| Number | 14105 |
Actual return week
The actual return date as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | actualReturnWeek | The API identifier used in GraphQL. |
| Number | 14106 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | LnPurcNo | The database field name. |
| API identifier | allocatedOrderLineNo | The API identifier used in GraphQL. |
| Number | 14219 |
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.
Order lines can be joined to purchase orders via allocated order numbers to see which sales order lines are allocated to them.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PurcNo | The database field name. |
| API identifier | allocatedOrderNo | The API identifier used in GraphQL. |
| Number | 14073 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | AllocatedOrder |
| ||
| Order line | AllocatedOrderLine |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Am | The database field name. |
| API identifier | amountInCurrency | The API identifier used in GraphQL. |
| Number | 14033 |
Amount (dom.)
The residual value of the order line , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DAm | The database field name. |
| API identifier | amountDomestic | The API identifier used in GraphQL. |
| Number | 14035 |
Amount before discount
The amount before line discounts , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | amountBeforeDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 14030 |
Amount before discount (dom.)
The amount before line discounts , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | amountBeforeDiscountDomestic | The API identifier used in GraphQL. |
| Number | 14032 |
Amount before discount in EURO
The amount before line discounts , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount before discount | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | amountBeforeDiscountInEuro | The API identifier used in GraphQL. |
| Number | 14031 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | amountInEuro | The API identifier used in GraphQL. |
| Number | 14034 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AreaL | The database field name. |
| API identifier | area | The API identifier used in GraphQL. |
| Number | 14135 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AreaU | The database field name. |
| API identifier | areaPerUnit | The API identifier used in GraphQL. |
| Number | 14129 |
Arrival/departure date
The arrival or departure date of the product.
- Confirmed delivery date plus Transport time.
- Required delivery date plus Transport time.
- Trans. date plus Lead time and Transport time.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ArDt | The database field name. |
| API identifier | arrivalOrDepartureDate | The API identifier used in GraphQL. |
| Number | 14111 |
Arrival/departure week
The arrival or departure date of the product saved as day of week number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | arrivalOrDepartureWeek | The API identifier used in GraphQL. |
| Number | 14112 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Barcode | Text (52) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SCd | The database field name. |
| API identifier | barcode | The API identifier used in GraphQL. |
| Number | 14102 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Barcode | 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| SQL name | PropNo | The database field name. |
| API identifier | capitalAssetNo | The API identifier used in GraphQL. |
| Number | 14208 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | CapitalAsset |
| ||
| Capital asset transaction | CapitalAssetTransaction |
| 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.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset proc. | Integer |
| SQL name | PropPrc | The database field name. |
| API identifier | capitalAssetProcessing | The API identifier used in GraphQL. |
| Number | 14207 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | CID code | Text (30) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CID | The database field name. |
| API identifier | cid | The API identifier used in GraphQL. |
| Number | 14214 |
Compensate
How much the customer must compensate of the products returned from hire or loan.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoComp | The database field name. |
| API identifier | compensate | The API identifier used in GraphQL. |
| Number | 14007 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CompPr | The database field name. |
| API identifier | compensationPriceInCurrency | The API identifier used in GraphQL. |
| Number | 14009 |
Compensation price (dom.)
The product price in connection with hire/loan , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DCompPr | The database field name. |
| API identifier | compensationPriceDomestic | The API identifier used in GraphQL. |
| Number | 14011 |
Compensation price in EURO
The product price in connection with hire/loan , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Source column | Compensation price | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | compensationPriceInEuro | The API identifier used in GraphQL. |
| Number | 14010 |
Confirmed delivery date
The confirmed delivery date.
- 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.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CfDelDt | The database field name. |
| API identifier | confirmedDeliveryDate | The API identifier used in GraphQL. |
| Number | 14053 |
Confirmed delivery week
The confirmed delivery date saved as day of week number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | confirmedDeliveryWeek | The API identifier used in GraphQL. |
| Number | 14054 |
Contact
Used for entering a contact person for the order.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LiaActNo | The database field name. |
| API identifier | contact1 | The API identifier used in GraphQL. |
| Number | 14151 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Contact1 |
|
Contact 2
An additional contact person if needed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LiaAct2 | The database field name. |
| API identifier | contact2 | The API identifier used in GraphQL. |
| Number | 14210 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Contact2 |
|
Control status
A free field that is editable. You can use it to label transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Control status/Product trans. | Integer |
| SQL name | Ctrl | The database field name. |
| API identifier | controlStatus | The API identifier used in GraphQL. |
| Number | 14084 |
Corrected stock value; realisation journal line no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CorStcValRealLnNo | The database field name. |
| API identifier | correctedStockValue_RealisationJournalLineNo | The API identifier used in GraphQL. |
| Number | 16611 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal line | CorrectedStockValue_RealisationJournalLine |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CorStcValRealJNo | The database field name. |
| API identifier | correctedStockValue_RealisationJournalNo | The API identifier used in GraphQL. |
| Number | 16610 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal | CorrectedStockValue_RealisationJournal |
| ||
| Realisation journal line | CorrectedStockValue_RealisationJournalLine |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstCur | The database field name. |
| API identifier | costCurrencyNo | The API identifier used in GraphQL. |
| Number | 14094 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | CostCurrency |
|
Cost exchange rate
The currency for the costs prices.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstExRt | The database field name. |
| API identifier | costExchangeRate | The API identifier used in GraphQL. |
| Number | 14095 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CCstPr | The database field name. |
| API identifier | costPriceInCurrency | The API identifier used in GraphQL. |
| Number | 14096 |
Cost price (dom.)
The cost price for the product , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstPr | The database field name. |
| API identifier | costPriceDomestic | The API identifier used in GraphQL. |
| Number | 14012 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstPrAdd | The database field name. |
| API identifier | costPriceAdditionPercent | The API identifier used in GraphQL. |
| Number | 14100 |
Cost price addition (dom.)
Displays the calculated Cost price addition in domestic amount.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DCstAd | The database field name. |
| API identifier | costPriceAdditionDomestic | The API identifier used in GraphQL. |
| Number | 15905 |
Country no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Country no. | Integer |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 17538 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | Country |
|
Currency no.
The currency for the order line.
The original value in the field is suggested based on the value in the Associate table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 14013 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cust. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustNo | The database field name. |
| API identifier | customerNo | The API identifier used in GraphQL. |
| Number | 13983 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Customer |
| ||
| Product customer | ProductCustomer |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Customer transaction | CustomerTransaction |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Customer price group 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustPrGr | The database field name. |
| API identifier | customerPriceGroup1 | The API identifier used in GraphQL. |
| Number | 13985 |
Customer price gr. 2
A group to which the customer belongs. The group is used for finding the correct price and discount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Customer price group 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustPrG2 | The database field name. |
| API identifier | customerPriceGroup2 | The API identifier used in GraphQL. |
| Number | 14117 |
Customer price gr. 3
A group to which the customer belongs. The group is used for finding the correct price and discount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Customer price group 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CustPrG3 | The database field name. |
| API identifier | customerPriceGroup3 | The API identifier used in GraphQL. |
| Number | 14193 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount or percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cus | The database field name. |
| API identifier | customs | The API identifier used in GraphQL. |
| Number | 14157 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelAltNo | The database field name. |
| API identifier | deliveryAlternativeNo | The API identifier used in GraphQL. |
| Number | 14092 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Delivery alternative | DeliveryAlternative |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Associate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelActNo | The database field name. |
| API identifier | deliveryAssociateNo | The API identifier used in GraphQL. |
| Number | 14099 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | DeliveryAssociate |
|
Delivery method
The mode of transportation that will be used for the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Delivery method | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelMt | The database field name. |
| API identifier | deliveryMethod | The API identifier used in GraphQL. |
| Number | 14101 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DensU | The database field name. |
| API identifier | densityPerUnit | The API identifier used in GraphQL. |
| Number | 14152 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | DesProDt | The database field name. |
| API identifier | desiredProductionStartDate | The API identifier used in GraphQL. |
| Number | 14215 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Description | Text (60) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 13993 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc1P | The database field name. |
| API identifier | discountPercent1 | The API identifier used in GraphQL. |
| Number | 14021 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc2P | The database field name. |
| API identifier | discountPercent2 | The API identifier used in GraphQL. |
| Number | 14025 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc3P | The database field name. |
| API identifier | discountPercent3 | The API identifier used in GraphQL. |
| Number | 14163 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc4P | The database field name. |
| API identifier | discountPercent4 | The API identifier used in GraphQL. |
| Number | 14167 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc5P | The database field name. |
| API identifier | discountPercent5 | The API identifier used in GraphQL. |
| Number | 14171 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc6P | The database field name. |
| API identifier | discountPercent6 | The API identifier used in GraphQL. |
| Number | 14175 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc1Am | The database field name. |
| API identifier | discountAmount1InCurrency | The API identifier used in GraphQL. |
| Number | 14022 |
Disc. amount (dom.)
The discount amount per unit , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc1DAm | The database field name. |
| API identifier | discountAmount1Domestic | The API identifier used in GraphQL. |
| Number | 14024 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc2Am | The database field name. |
| API identifier | discountAmount2InCurrency | The API identifier used in GraphQL. |
| Number | 14026 |
Disc. amount 2 (dom.)
The discount amount per unit , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc2DAm | The database field name. |
| API identifier | discountAmount2Domestic | The API identifier used in GraphQL. |
| Number | 14028 |
Disc. amount 2 in EURO
The discount amount per unit , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Disc. amount 2 | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | discountAmount2InEuro | The API identifier used in GraphQL. |
| Number | 14027 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc3Am | The database field name. |
| API identifier | discountAmount3InCurrency | The API identifier used in GraphQL. |
| Number | 14164 |
Disc. amount 3 (dom.)
The discount amount per unit , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc3DAm | The database field name. |
| API identifier | discountAmount3Domestic | The API identifier used in GraphQL. |
| Number | 14166 |
Disc. amount 3 in EURO
The discount amount per unit , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Disc. amount 3 | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | discountAmount3InEuro | The API identifier used in GraphQL. |
| Number | 14165 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc4Am | The database field name. |
| API identifier | discountAmount4InCurrency | The API identifier used in GraphQL. |
| Number | 14168 |
Disc. amount 4 (dom.)
The discount amount per unit , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc4DAm | The database field name. |
| API identifier | discountAmount4Domestic | The API identifier used in GraphQL. |
| Number | 14170 |
Disc. amount 4 in EURO
The discount amount per unit , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Disc. amount 4 | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | discountAmount4InEuro | The API identifier used in GraphQL. |
| Number | 14169 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc5Am | The database field name. |
| API identifier | discountAmount5InCurrency | The API identifier used in GraphQL. |
| Number | 14172 |
Disc. amount 5 (dom.)
The discount amount per unit , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc5DAm | The database field name. |
| API identifier | discountAmount5Domestic | The API identifier used in GraphQL. |
| Number | 14174 |
Disc. amount 5 in EURO
The discount amount per unit , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Disc. amount 5 | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | discountAmount5InEuro | The API identifier used in GraphQL. |
| Number | 14173 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc6Am | The database field name. |
| API identifier | discountAmount6InCurrency | The API identifier used in GraphQL. |
| Number | 14176 |
Disc. amount 6 (dom.)
The discount amount per unit , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Dc6DAm | The database field name. |
| API identifier | discountAmount6Domestic | The API identifier used in GraphQL. |
| Number | 14178 |
Disc. amount 6 in EURO
The discount amount per unit , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Disc. amount 6 | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | discountAmount6InEuro | The API identifier used in GraphQL. |
| Number | 14177 |
Disc. amount in EURO
The discount amount per unit , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Source column | Disc. amount | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | discountAmount1InEuro | The API identifier used in GraphQL. |
| Number | 14023 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoScr | The database field name. |
| API identifier | discarded | The API identifier used in GraphQL. |
| Number | 14008 |
Distributed discounts
The total line, group and total discounts for the order line , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DstDc | The database field name. |
| API identifier | distributedDiscountsInCurrency | The API identifier used in GraphQL. |
| Number | 14039 |
Distributed discounts (dom.)
The total line, group and total discounts for the order line , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DDstDc | The database field name. |
| API identifier | distributedDiscountsDomestic | The API identifier used in GraphQL. |
| Number | 14041 |
Distributed discounts in EURO
The total line, group and total discounts for the order line , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Distributed discounts | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | distributedDiscountsInEuro | The API identifier used in GraphQL. |
| Number | 14040 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EmpNo | The database field name. |
| API identifier | employeeNo | The API identifier used in GraphQL. |
| Number | 13980 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Employee |
|
Employee price gr.
The employee price group used as the basis when looking up in the Price- and discount matrix table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Employee price group | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EmpPrGr | The database field name. |
| API identifier | employeePriceGroup | The API identifier used in GraphQL. |
| Number | 13981 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | enterSerialNo | The API identifier used in GraphQL. |
| Number | 13996 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | EU goods stat. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EUStatNo | The database field name. |
| API identifier | euGoodsStatisticsNo | The API identifier used in GraphQL. |
| Number | 14107 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExQty | The database field name. |
| API identifier | exchangeQuantity | The API identifier used in GraphQL. |
| Number | 14079 |
Exchange rate
The prevailing exchange rate.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 14014 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ERetDt | The database field name. |
| API identifier | expectedReturnDate | The API identifier used in GraphQL. |
| Number | 14103 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | expectedReturnWeek | The API identifier used in GraphQL. |
| Number | 14104 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Factor3 | The database field name. |
| API identifier | factor3 | The API identifier used in GraphQL. |
| Number | 14110 |
Finish at
The time of the last finish in the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FinTm | The database field name. |
| API identifier | finishAt | The API identifier used in GraphQL. |
| Number | 14162 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FinDt | The database field name. |
| API identifier | finishDate | The API identifier used in GraphQL. |
| Number | 14160 |
Finish week
The date when the order was last finished saved as day of week number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | finishWeek | The API identifier used in GraphQL. |
| Number | 14159 |
Finished by
The name of the person who last finished something in the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FinBy | The database field name. |
| API identifier | finishedBy | The API identifier used in GraphQL. |
| Number | 14142 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FinYrPr | The database field name. |
| API identifier | finishedYearAndPeriod | The API identifier used in GraphQL. |
| Number | 14197 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Realised year/week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FinYrWk | The database field name. |
| API identifier | finishedYearAndWeek | The API identifier used in GraphQL. |
| Number | 14198 |
Free 1
Additional numeric information about the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 14188 |
Free 2
Additional numeric information about the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 14189 |
Free 3
Additional numeric information about the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 14190 |
Free 4
Additional numeric information about the order line.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 14191 |
Free quantity
The free quantity for which the customer will not be invoiced.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FreeNo | The database field name. |
| API identifier | freeQuantity | The API identifier used in GraphQL. |
| Number | 14122 |
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
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrAm1 | The database field name. |
| API identifier | freight1 | The API identifier used in GraphQL. |
| Number | 14137 |
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
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrAm2 | The database field name. |
| API identifier | freight2 | The API identifier used in GraphQL. |
| Number | 14138 |
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
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrAm3 | The database field name. |
| API identifier | freight3 | The API identifier used in GraphQL. |
| Number | 14139 |
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
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrAm4 | The database field name. |
| API identifier | freight4 | The API identifier used in GraphQL. |
| Number | 14140 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrNo | The database field name. |
| API identifier | from | The API identifier used in GraphQL. |
| Number | 14002 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Gross profit | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | grossProfitDomestic | The API identifier used in GraphQL. |
| Number | 14070 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | grossWeight | The API identifier used in GraphQL. |
| Number | 14133 |
Gross weight per unit
Calculated on the basis of the Net weight per unit and Tare fields.
The field cannot be overridden.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | grossWeightPerUnit | The API identifier used in GraphQL. |
| Number | 14125 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | HgtU | The database field name. |
| API identifier | heightPerUnit | The API identifier used in GraphQL. |
| Number | 14128 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Hire period | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Tenancy | The database field name. |
| API identifier | hirePeriod | The API identifier used in GraphQL. |
| Number | 14149 |
Inc. cost
The total incurred costs , in the actual currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CIncCst | The database field name. |
| API identifier | incurredCostInCurrency | The API identifier used in GraphQL. |
| Number | 14097 |
Inc. cost (dom.)
The total incurred costs , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | IncCst | The database field name. |
| API identifier | incurredCostDomestic | The API identifier used in GraphQL. |
| Number | 14069 |
Incm. doc. no.
Reference to the corresponding Document comment table entry.
This field is used for order match functionality.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | InDocNo | The database field name. |
| API identifier | incomingDocumentNo | The API identifier used in GraphQL. |
| Number | 17823 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Incoming document | IncomingDocument |
|
Incurred
How much has been consumed. For various reasons, this may deviate from the invoiceable quantity. The field is relevant only for sales.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoReg | The database field name. |
| API identifier | incurred | The API identifier used in GraphQL. |
| Number | 14004 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InInc | The database field name. |
| API identifier | inflow | The API identifier used in GraphQL. |
| Number | 15461 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cust. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoCust | The database field name. |
| API identifier | invoiceCustomerNo | The API identifier used in GraphQL. |
| Number | 13984 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | InvoiceCustomer |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoDt | The database field name. |
| API identifier | invoiceDate | The API identifier used in GraphQL. |
| Number | 13975 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 13974 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Customer transaction | CustomerTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Supplier transaction | SupplierTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger transaction | GeneralLedgerAccountTransaction |
| ||
| Capital asset transaction | CapitalAssetTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| General ledger transaction | AccountTransactionVoucherNo |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoRef | The database field name. |
| API identifier | invoiceReference | The API identifier used in GraphQL. |
| Number | 14049 |
Invoice week
Here you can see the Invoice date field expressed as day number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | invoiceWeek | The API identifier used in GraphQL. |
| Number | 13976 |
Last realisation journal no.
The last realisation number that this transaction was included in.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| SQL name | RealJNo | The database field name. |
| API identifier | lastRealisationJournalNo | The API identifier used in GraphQL. |
| Number | 14220 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal | RealisationJournal |
|
Length
The length of the unit used to specify the stock for the product.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LgtL | The database field name. |
| API identifier | length | The API identifier used in GraphQL. |
| Number | 14134 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LgtU | The database field name. |
| API identifier | lengthPerUnit | The API identifier used in GraphQL. |
| Number | 14126 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Location | Text (18) |
| SQL name | Loc | The database field name. |
| API identifier | location | The API identifier used in GraphQL. |
| Number | 14075 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Location | 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Margin | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | margin | The API identifier used in GraphQL. |
| Number | 14071 |
Memo file name
The file name for the Memo attached to the order line.
On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.
Double-click or press * to open the Select file dialog box to manually select a memo file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 14098 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo no. | Integer |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19241 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
Net weight
The net weight of the unit used to specify the stock for the product.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NWgtL | The database field name. |
| API identifier | netWeight | The API identifier used in GraphQL. |
| Number | 14131 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NWgtU | The database field name. |
| API identifier | netWeightPerUnit | The API identifier used in GraphQL. |
| Number | 14123 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Primary key | Yes | Order jour. no., Trans. no. |
| SQL name | JNo | The database field name. |
| API identifier | orderJournalNo | The API identifier used in GraphQL. |
| Number | 13971 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order journal | OrderJournal |
| ||
| Realisation journal line | RealisationJournalLineJournal |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdLnNo | The database field name. |
| API identifier | orderLineNo | The API identifier used in GraphQL. |
| Number | 16213 |
Order no.
The Order no. from the Order table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 13973 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
| ||
| Realisation journal line | RealisationJournalLineOrderNo |
| ||
| General ledger transaction | AccountTransactionOrderNo |
| ||
| Order line | OrderLine |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | StructureHeadOrderLine |
| 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.
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.
- 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: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.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.
- 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:You can use this order type when no order documents are used, e.g. in the event of adjustments.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.
- 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: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: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.
- Invoice customer no.
- Invoice reference
- Masked card no.
- Contract amount
- Contract amount (dom.)
- Currency no.
- Card company
Note: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.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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdTp | The database field name. |
| API identifier | orderType | The API identifier used in GraphQL. |
| Number | 17737 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 14057 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 14058 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 14059 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 14060 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 14061 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 14062 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 14199 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 14200 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 14201 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 14202 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 14203 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 14204 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Original confirmed delivery date
The original confirmed delivery date.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FCfDelDt | The database field name. |
| API identifier | originalConfirmedDeliveryDate | The API identifier used in GraphQL. |
| Number | 14155 |
Original confirmed delivery week
The original confirmed delivery date saved as day of week number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | originalConfirmedDeliveryWeek | The API identifier used in GraphQL. |
| Number | 14154 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrCstPr | The database field name. |
| API identifier | originalCostPriceDomestic | The API identifier used in GraphQL. |
| Number | 14180 |
Original cost price addition (dom.)
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrDCstAd | The database field name. |
| API identifier | originalCostPriceAdditionDomestic | The API identifier used in GraphQL. |
| Number | 18498 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount or percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrCusAm | The database field name. |
| API identifier | originalDuty | The API identifier used in GraphQL. |
| Number | 14185 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrFrAm | The database field name. |
| API identifier | originalFreight1 | The API identifier used in GraphQL. |
| Number | 14181 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrFrAm2 | The database field name. |
| API identifier | originalFreight2 | The API identifier used in GraphQL. |
| Number | 14182 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrFrAm3 | The database field name. |
| API identifier | originalFreight3 | The API identifier used in GraphQL. |
| Number | 14183 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Freight @ | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrFrAm4 | The database field name. |
| API identifier | originalFreight4 | The API identifier used in GraphQL. |
| Number | 14184 |
Original quantity
The first time you save an order line, this field is updated with the value in the Quantity field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoOrg | The database field name. |
| API identifier | originalQuantity | The API identifier used in GraphQL. |
| Number | 15378 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Location | Text (18) |
| SQL name | ToLoc | The database field name. |
| API identifier | otherLocation | The API identifier used in GraphQL. |
| Number | 16412 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Shipment no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ToShpNo | The database field name. |
| API identifier | otherShipmentNo | The API identifier used in GraphQL. |
| Number | 14093 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Shipment | OtherShipment |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ToStc | The database field name. |
| API identifier | otherWarehouseNo | The API identifier used in GraphQL. |
| Number | 13998 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | TransferToWarehouse |
| ||
| Shipment | OtherShipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Stock balance | ToStockBalance |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RmtSup | The database field name. |
| API identifier | remittanceSupplierNo | The API identifier used in GraphQL. |
| Number | 13987 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | RemittanceSupplier |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period key | Integer |
| SQL name | PrK | The database field name. |
| API identifier | periodKeyNo | The API identifier used in GraphQL. |
| Number | 15865 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Period key | PeriodKey |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Picture file name | Text (260) |
| SQL name | PictFNm | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 14192 |
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.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Plan type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoPlLn | The database field name. |
| API identifier | planType | The API identifier used in GraphQL. |
| Number | 14121 |
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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Price | The database field name. |
| API identifier | priceInCurrency | The API identifier used in GraphQL. |
| Number | 14018 |
Price (dom.)
The price of the product , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DPrice | The database field name. |
| API identifier | priceDomestic | The API identifier used in GraphQL. |
| Number | 14020 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | priceAfterDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 14080 |
Price after discount (dom.)
The unit price for the product after the line discount , in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | priceAfterDiscountDomestic | The API identifier used in GraphQL. |
| Number | 14081 |
Price after discount in EURO
The unit price for the product after the line discount , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Source column | Price after discount | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | priceAfterDiscountInEuro | The API identifier used in GraphQL. |
| Number | 14029 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PriceF | The database field name. |
| API identifier | priceFactor | The API identifier used in GraphQL. |
| Number | 14153 |
Price in EURO
The price of the product , in Euro.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Source column | Price | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | priceInEuro | The API identifier used in GraphQL. |
| Number | 14019 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrNo | The database field name. |
| API identifier | priceQuantity | The API identifier used in GraphQL. |
| Number | 14150 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrTp | The database field name. |
| API identifier | priceType | The API identifier used in GraphQL. |
| Number | 14156 |
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.
- 1 - Quantity in base unit
- 2 - Length
- 3 - Area
- 4 - Volume
- 5 - Net weight
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price unit | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrUn | The database field name. |
| API identifier | priceUnit | The API identifier used in GraphQL. |
| Number | 14141 |
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.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProcMt | The database field name. |
| API identifier | processingMethod1 | The API identifier used in GraphQL. |
| Number | 13994 |
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.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExcPrint | The database field name. |
| API identifier | processingMethod2 | The API identifier used in GraphQL. |
| Number | 13992 |
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.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EditPref | The database field name. |
| API identifier | processingMethod3 | The API identifier used in GraphQL. |
| Number | 14161 |
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.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 4 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EdFmt | The database field name. |
| API identifier | processingMethod4 | The API identifier used in GraphQL. |
| Number | 14001 |
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.
Warehousing
- Exempt from warehousing
- The product is, for example, a service and is not held in any
warehouse must not be included in the warehousing routine. No tracking will be done
for stock balances and stock changes, and there will be no shipments processed.
Note:If an increase order line has some reservations linked to the order line's shipments, it will not be possible to select this field. You must first cancel the decrease orders that have reservations against this order line.
The new row after invoicing and finishing for hire of products will automatically be exempt from warehousing. If you have registered an order with a product which is to be hired out and the product which you have registered is in stock, the stock will be reduced on finishing.
Note:If you try to write or copy a number that contains this check box, and something is reserved against the shipments for this order line, the following message appears in the Status bar: You are not allowed to turn off warehousing when something is reserved against any shipments on the reservation lines of the order line.
Reservation method
- Reserve on save
- The quantity will be reserved when you save.
- Reserve from given shipment
- The reservation on the order will only take place from this
shipment.
When entering an order, you can also reserve the product on the order line from the transaction types 2 - Hire and 3 - Loan.
This only works if a shipment number has been entered on the order line regardless of the transaction type. If a full delivery cannot be made, the surplus quantity is assigned to back order.
If this check box is not selected and a shipment number has been entered, the shipment number that is specified will be reserved. If the Shipment no. field is blank, it will be reserved in accordance with FIFO.
- Only reserve if the whole quantity is available in stock
- This option works with the parameter Reserve only if the whole quantity is available.
- Suggest shipment no. 1
- Shipment number 1 is suggested when you enter the product number on
order lines. Tip:If you always want to use shipment number 1 you can select the Only one shipment field in the Company information table.Note:This is a method that we do not recommend for those running warehouse management of the products.
- No reservation on goods received
- Sales order lines are not reserved against purchase and production order lines when goods are received.
- (From the Structure table)
- Reserve available quantity
- Reserve only if the whole quantity is available
- The shipment is not reserved unless the whole quantity is available.
- Meet reservations req. even if not available
- This field is no longer in use. Be aware the field may be removed in later versions.
Picking method
- Pick complete order line
- If you have chosen to pick the entire order line, the order line is only included on printouts of pick lists if there are more of the remaining quantity that you can pick. If you have to pick the whole structure or the same share of the structure lines, this can also block structures from being picked. If you have to pick the whole order in one lot, you can find a corresponding option in the dialog box for customer and order options.
- Do not withdraw picking if finishing less
- No previous reservations or items picked will be withdrawn when you finish them in an order line or reservation line.
- Picking after invoicing
- This option allows reservation handling to be postponed until
invoicing has been done. The products are not picked on finishing and invoicing, and
you can pick after invoicing. If you select this check box, and do not create
reservations before invoicing, the following items are reduced on picking instead of
on finishing/invoicing:
- Stock and reservations in the Stock balance table.
- Shipments.
- Unrealised stock changes in the Stock balance and Stock change tables.
Note:If the products are not picked before finishing or invoicing, only the Finished and Invoiced/realised quantity fields in the order lines are updated, and accounting vouchers are generated. Product transactions are not created, as there is nowhere to save the references. Only when the lines are picked, either by printing a pick list or using the Pick NOW field, are Reservation and Product transaction updated together with the Shipment, Stock balance and Stock change tables.Picking after invoicing will not work if using Reserve on save or creating manual reservations.Note:There are no product transactions for these invoicing actions until after picking.Note:Order lines that are processed in this way have two realisation journal lines:- One on invoicing, which does not have a product transaction to refer to.
- One on picking, which does not have a Voucher jour. no. to refer to.
Note:If you would like to get payments in advance, the recommended method is to use the processing Create prepayment line in Order table.If you have selected the Picking after invoicing field, two lines are created in the Realisation journal table instead of one. One is created on invoicing, and one when the order is picked. The two lines have a different value in the Origin field:- 9 - Order processing
- 38 - Order processing with picking after invoicing
- Finish picked quantity with menu choice
- You select this option if you want to finish what is missing by finishing the entire picked quantity.
- Keep reservations even if picking less
- No previous reservations beyond those already picked will be withdrawn when you finish them in an order line or reservation line.
Exception
- Allow non-existent shipment numbers
- A warning is given when you enter a shipment number that does not exist for a product or stock combination in an order line. If the shipment does not exist, a new shipment will be created with this number. The shipment can also have been deleted because it has been emptied. If you want to retain shipments you must select the Keep shipments check box under the Order processing 2 field in the Company information table.
- Do not process shipments in FIFO order
- Shipments are not investigated in FIFO order unless the reservation requirements can be satisfied.
- Add shipments with negative availability
- Shipments with negative availability will be added if there is still a
balance to reserve, after all shipments of the product have been investigated. This
also applies if it is a direct order, a cash order or a realised order.Note:You can use the Add shipments with negative availability field to return goods in unrealised purchase order lines, even if the goods are reserved in a sales order.When you create a negative shipment, the Serial no., Location, Use by date, Order no. and Cost price fields from the order line are transferred to the shipment. They are then also included in the Reservation table, in product transactions and when posting to accounts.Note:In such instances no new "negative new shipment" is created, but instead the shipment to which the goods were delivered is assigned negative availability.
Serial number
Reservation
- One shipment per unit at stock increase
- You will have one shipment per item for a product. One shipment for each serial number is generated if there is a goods receipt, production credit note or other stock increases.
- One reservation line per unit at stock reduction
- You will have one reservation row per serial number for a product. One
reservation row for each serial number is generated if there is a finished sales
order, further processing, production or other stock reductions.
Select this field if you only want to generate reservations for outgoing deliveries with serial numbers and not for receipts. This will guarantee traceability of serial numbers, because one stock transaction is produced for each reservation.
- Reserve serial no. at picking
- By default there is no reservation when you have registered a product as a serial number. You must select this check box if you want the pick list to generate reservation lines. The order lines are processed by the pick list, which enables you to run the pick list and define which serial numbers were picked upon finishing. The Stock balance table is updated with the quantity reserved without reservation lines being automatically generated. The order line is updated in the Picked and Picked without reservation fields. When this order line is finished, the Stock balance table is not updated with the quantity reserved, as this was done when the pick list was printed.
- Calculate "Finish NOW" when entering serial no.
- The value in the Finish NOW field in the
order line increases when you register the serial number in the Order line, Reservation and Serial no. tables. If you delete the
serial number the value in the Finish NOW field is
reduced.Note:If you want to add the serial number before finishing the stock increase in the Reservation table, you cannot select this check box.
Reject
- Duplicate serial no.
- You select this check box if you want to reject duplications of the same serial number for an order line in the Serial no. and Reservation tables. This also prevents duplicate entry with the bar code reader. If there is a stock increase in the Order line and Reservation tables, a check will be made in the Product transaction table to see whether this serial number has been used before.
- Non-existent serial no.
- A check is done if the registered serial number is in the Shipment table. You receive a message in the status bar from the Order line and Reservation tables if the serial number already exists, while in the Serial no. table you receive a message dialog box on screen.
Structure
Structure head
- Product is structure head
Expand structure on transaction type
- Sales
- Hire
- Loan
- Adjustment/internal issue
- Further processing
- Purchase
- Production
- Stock transfer
Picking of structures
- (From the Structure table)
- Pick individual structure lines
- Pick same fraction of structure lines
- The same proportion of the quantities in all structure lines is picked as is included in the structure. The order line with the lowest share determines how much is picked. If not everything in the structure line is picked, the share is calculated as follows: The quantity picked in each structure line is rounded off to the closest number divisible by the quotient of the total number of structure lines and the total number in the structure head. The Balance to pick field in the structure head shows how many complete structure still have to be picked.
- Pick complete structure
- The structure can only be picked if the quantities can be picked.
- Distribute amounts on structure lines
- The amount in the structure head is distributed among the structure
lines when the structure is expanded.
- Weights: distribution then takes place in accordance with the values in the Structure weight field in the Structure table. The amount in a structure line is set equal to the amount in the structure head multiplied by the weight of the line and divided by the sum of the weights.
- Calculate prices: The prices in the structure lines are calculated at the same time as the amount in the line divided by the quantity in the line. This selection applies to structure heads with transaction type 1, and mean that the check box is selected so that prices are not retrieved for structure lines when the structure is expanded.
- Process substructures: If you choose to expand substructures in the Structure table, the amount in a substructure line is distributed down among sub-product lines. You must check the option to distribute amounts among structure lines in the 2nd column in the dialog box for the structure head or in the Structure table.
- Recalculate: If you change prices, discounts or other fields that change the amount in the current currency in the order line for a structure heading, the amounts and prices in the structure line will be recalculated.
- Finish structure line from structure head
- You can finish a structure from the Main product and it will calculate a relationship for the structure lines. This also assumes that the check for Pick same fraction of structure lines has been used.
- Do not calculate price quantity in structure head
- The amount in the structure head is multiplied by the price quantity of the product in the structure head, and not by the price quantity of orders with transaction type 7 - Production.
Structure lines
Accumulate in structure head
- Revenue
- Revenue in sales order lines will be accumulated in the structure head. If you have orders with transaction types 2 - Hire and 3 - Loan, you must have specified the hire price in the Price- and discount matrix table. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding check box for posting revenue in the After processing tab.
- Sales costs
- The costs in sales order lines will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting costs in the After processing tab.
- Production costs
- Costs and amounts in production orders will be accumulated in the structure head. Accumulation takes place when you save and in order documents. To avoid duplicate posting, you must select the corresponding box for posting production costs in the After processing tab.
- Fixed quantity (regardless of qty. in structure head)
- The quantity in the structure line is not multiplied by the quantity in the structure head when the structure expands, or if you subsequently change the quantity in the structure head.
- Add lead time from structure head
- The lead time and transport time in the structure head are added when calculating the preferred delivery date and arrival/departure date for purchase and production orders. The lead time and transport time from the structure line are also added.
- Expand substructure
- Display the substructures in the order lines.
- Raw material
Prices
Do not get
- Sales price
- The sales price is not called up to sales order lines.
- Cost price on sale
- The cost price is not called up to sales order lines.
- Cost price on production
- The cost price and the price are not called up to production order lines.
Resuggesting price
- Do not resuggest price/discount
- No lookup is performed in the Price- and discount matrix in the
sales, hire and purchase order lines. This only applies if you have already filled in
the Price field.
Reserving from shipment will override the cost price even if the setting is
on.Note:This selection does not affect the updating of prices when you run the Recalculate prices processing. Nor does it affect price updates made elsewhere in Business NXT. This selection only affects the price update when entering an order.
- Set "Do not resuggest price/discount" when saving
- Do not use "price from quantity format" even if flag is set
Discount calculation
- Do not calculate discount from standard price
- You select this check box if you do not want to calculate a discount from the standard price fields in the current currency and default currency when referring to the Price and discount matrix. Applies to sales, hire and purchase order lines. When you post to the accounts, any change to the price in the order line compared to the price suggested from the Price and discount matrix is not posted as a discount.
- Suggest price after discount and rounding
- The discount is deducted from the price immediately by referring to the Price- and discount matrix in the sales and hire order lines.
- Exempt from total discount
- No total discount is calculated for such order lines.
Quantity and price calculation
- Calculate price from quantity format
- The price rather than the quantity is calculated from the From, To and Factor 3 fields. This depends on which quantity format you have selected. No reference is made to the Price- and discount matrix.
- Amount/Share specifies amount to be invoiced so far
- The amount or share in the order line is treated as invoiced so far after this invoice. This can apply to both on account and fixed prices.
- Share calculated from total incurred costs
- The price is calculated as a share of the value in the Inc. cost total field on the order instead of the default Contract amount field.
Cost price calculation
- Get cost price from price and discount matrix
- The cost price in decrease order lines is retrieved from the Price- and discount matrix instead of the Stock balance table. In the Reservation table the actual cost prices are still retrieved from the shipments. You should not check the box for services or other products that are not to be included in warehousing. In this instance the cost prices from the Price- and discount matrix will be retrieved. If you have selected the Get cost price from price and discount matrix and Do not resuggest price/discount fields, the cost price is retained, even if you select a shipment with another cost price. If you have not selected the Calculate cost from the order line's cost price field, the cost price of the shipment is also used for product transactions and in posting.
- Calculate avg. cost price on the order line
- You select this check box if you want to set the cost price in the order line as a weighted average of the cost prices in the reservation lines. The value is set when you reserve or change cost prices for decrease order lines in the Reservation table. This is based on the reserved quantities and cost prices when the entire quantity on the order line is reserved.
- Calculate cost from the order line's cost price
- The costs are calculated and posted from the order line's cost price.
Note:The Temporary costs field under Trans. status will then not be selected, and the product transactions are not updated with the correct cost price upon receipt of goods, but retain the value from the order line.
The cost price will follow the transaction throughout the chain. The cost price in the order line is used for posting and statistics. This means that this cost price is not updated if the product is delivered on a subsequent occasion with a different cost price. You must therefore make changes in the accounts yourself if prices change.
- Do not update sales order lines for price refunds
- The prices in the sales order lines and refund lines are not updated.
Visma.net settings
- Do not deduct VAT from Expense price on orders
Editing
Quantity format
- (From the Structure table)
- Quantity
- Hours and minutes
- Start and end date exclusive
- Start and end date inclusive
- Factors
Quantity calculation
- Do not suggest incurred as quantity
- You can select this check box if you do not want to duplicate the values in the Incurred quantity field in the Quantity field. If you want to invoice anything you must complete the field yourself.
- Calculate quantity from weight/dimension
- You select this option if you want to calculate the Quantity field in the order lines when you enter the quantity in base unit, dimensions or weight in total for the line. The appropriate 'per unit' factor will automatically be divided.
- Delete rest when filling in "Finish NOW"
- There will be nothing left over, as the Quantity field is set equal to the Finish NOW field when you fill in Finish NOW. Disregard obligatory fields.
- Exchange arrangement
Enter
- Description
- The cursor stops in the Description field. This can be required if the product number acts as a common number for several products, or if there is a text line.
- From and to/factors
- The cursor stops in the From, To and Factor 3 fields and skips Incurred.
Restrictions
Exempt from
- Returning
- Finishing
- Acceptance
- Invoice received
- Goods received
- Sent from supplier
- Purchase confirmation
- Recalculate prices
- Cancelling
- Order generation
- The order line is not generated on automatic order generation. The Exempt from order generating flag is set automatically in the Order line status field when the order line is created.
- Calc. of additional cost
- The product will be exempt from cost price addition and freight costs
from the order head.
If you want to exempt entire orders from processing, you can find appropriate options in the 3rd column of the dialog box for the menu item.
Note:This does not apply for cost calculation.Exempt from cost calculation does not then complete the line with distributed costs from the order head.
Mandatory fields
- Locations on increase
- Disregard mandatory fields
- If you have selected the Mandatory box in the dialog box for the Edit/Entry rules menu item, you see red question marks in the fields in the order lines. If you select this check box the question marks will be hidden.
Processing methods
- Processing methods locked
Printout
Include on pick list
- (From the Structure table)
- The order line
- The structure
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
- The order
- Order lines are only included in pick lists if you pick something in them. Or you can choose to include them if something is picked in any of the lines. It can be a structure in which they are included, or when something is picked in the order. You can define the Structure option for both structure heads and structure lines. The option of whether the order line is printed in the pick list if something has been picked from the structure also applies if the structure head has been picked.
Suppress
- Product no.
- Product no. will be hidden. For example, it might be appropriate not to display product numbers if they are used as text and group discount codes.
- Quantity
- Quantity will be hidden.
- Price and discount
- Price and Discount will be hidden.
- Amount
- Amount will be hidden.
- Cost price and cost
- Cost price and cost will be hidden.
- Requested delivery date
- Required delivery date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Confirmed delivery date
- Confirmed delivery date will be hidden. You might want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Other dates
- Original confirmed delivery date, Sent date and Arrival/departure date will be hidden. You might also want to exempt delivery dates from printing on structure lines if you are going to delivery the structure collectively.
- Memo
- Order line memos will not be displayed on order documents.
Excluded on
- Invoices/credit notes
- The order line is excluded on invoices and credit notes.
Even if order lines are exempted from printing, they are still included in the totals. Invoices and credit notes are entered into the statistics and posted to the accounts.
- Consignment notes
- The order line is excluded on consignment notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Packing slips
- The order line is excluded on packing slips.
Even if order lines are exempted from printing, they are still included in the totals.
- Pick lists
- The order line is excluded on pick lists.
Even if order lines are exempted from printing, they are still included in the totals.
- Delivery notes
- The order line is excluded on delivery notes.
Even if order lines are exempted from printing, they are still included in the totals.
- Order confirmations
- The order line is excluded on order confirmations.
Even if order lines are exempted from printing, they are still included in the totals.
- Quotations
- The order line is excluded on quotations.
Even if order lines are exempted from printing, they are still included in the totals.
- Purchase orders
- The order line is excluded on purchase orders.
Even if order lines are exempted from printing, they are still included in the totals.
- Inquiries
- The order line is excluded on inquiries.
Even if order lines are exempted from printing, they are still included in the totals.
- Production orders
- The order line is excluded on production orders.
Even if order lines are exempted from printing, they are still included in the totals.
- If 0
- The order line is excluded if the quantity is 0.Tip:This can be relevant in connection with structures in which you enter quantities after expansion and do not want to display lines with no quantities.
Post processing
Do not include totals
- Revenue
- You can select the Revenue check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of amounts/weights and dimensions in the
structure head and structure lines. This can be when either the price is suggested in
both places, or amounts are accumulated in the structure head. Weights and dimensions
can also seperately be excluded from being calculated from the order line to the order
head.Note:Selecting this check box also omits the row from being posted.
- Sales costs
- You can select the Sales costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Production costs
- You can select the Production costs check box if you do not want an order line to be included in order totals and group
totals. You then avoid duplicate totalling of costs in the structure head and
structure lines. This can be when the cost price is suggested in both places, or costs
are accumulated in the structure head. Note:Selecting this check box also omits the row from being posted.
- Weight and Volume
- You can select the Weight and Volume check box if you do not want an order line to be included in order totals and group totals. You then avoid duplicate totalling weights and dimensions in the structure head and structure lines. This can be when values are suggested in both places, or accumulated in the structure head.
Exclude from accounting
- Revenue
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs
- If you select the Revenue check box the totals are not posted to accounts. When you choose to exempt totals, the corresponding check box to exempt from posting is greyed out. If the order line is not to be included when you post revenue, it is not included in the d/c ledger amount and in general ledger transactions for sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs are not to be included when you post to accounts, no voucher is produced with general ledger transactions for product cost, freight and customs. Even if amounts in structure lines are accumulated in the structure head, you can choose to post the structure lines instead of the structure head. This is useful because they can have different tax and accounting groups and account sets.
- Sales costs, if exempt from warehousing
- If you have selected this field and select the Exempt from warehousing field under Processing method/Warehouse, the Sales costs field is automatically selected under Processing method/Post processing/Exclude from accounting. If you deselect the Exempt from warehousing field, the Sales costs field is automatically deselected. This also applies to the Exempt from warehousing field in the Order line table.
- Production costs
- If you select the Revenue check box the totals are not posted to
accounts. When you choose to exempt totals, the corresponding check box to exempt from
posting is greyed out. If the order line is not to be included when you post revenue,
it is not included in the d/c ledger amount and in general ledger transactions for
sales, discounts, additions, special taxes, invoice fees, VAT and rounding. If costs
are not to be included when you post to accounts, no voucher is produced with general
ledger transactions for product cost, freight and customs. Even if amounts in
structure lines are accumulated in the structure head, you can choose to post the
structure lines instead of the structure head. This is useful because they can have
different tax and accounting groups and account sets.Note:Selecting this option will also exclude accounting of transaction types 5 - Further processing, 8 - Stock transfer and 4 - Adjustment/internal issue, including corrections from stock count.
Exclude from statistics
- Revenue
- The price fields and amounts are not filled in for product
transactions. Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Sales costs
- The cost price fields for sales are not filled in for product
transactions.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
- Production costs
- The cost price fields for incurred costs are not filled in for product
transactions. This selection applies to fields showing both current price/amount and
cost price etc.Note:If you have chosen not to include both revenue and costs in statistics, no product transactions are produced. This might be relevant, for example, when limiting space and time for products that you no longer need to follow up for statistical purposes.
Other accounting rules
- Post temp. stock value
- You post the debit/credit product cost upon finishing, and upon receipt of invoice and invoicing these postings are reversed.
- Accrual accounting to end of year
- You can apply accrual accounting of income and expenses from a sale
from the sales date until 31.12.Note:This calculation does not use accounting periods, but is valid for the calendar year.
Misc.
Group processing
- (From the Structure table)
- None
- Group discount
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
- Group total
- You can insert lines into orders to calculate group discounts or group totals. You enter the product number into a row in the Product table, where you have selected Group discount or Group total in the Processing dialog box. You can also insert default text in the Description field. You enter the size of the discount or addition in the Discount fields in the order line. You show additions with a minus sign. You can also complete the Discount fields yourself if you select Group total, which causes the discount to be deducted from the total that you see in the line.
Time to next invoice
- Weeks instead of months
- If you do not check the Weeks instead of months box, the time unit for the Time to next field is months.
- Always last day of month
- A check here leads to the next order line being set to the last day of the month and will therefore be 30th, 31st pr 28th, depending on how many days there are in the month.
- Use Quarter Days
- Not used in this country, but Quarter days is a term unique to the UK and applies to the letting of property. The days are 25.3, 24.6, 29.9 and 25.12. It is assumed that a check has been inserted for the last of the month and if Quarter days has been checked, the Last of the month will be set.
- One line per time unit
- If you select the 1 line per time unit check box, one line is displayed per week or month.
- No stock handling on new line
- If you have filled in the Time to next field on an order line, e.g. in connection with a hire order, a new order line will be added when invoicing. This order line will not be stock handled if you have selected the No stock handling on new line.
Misc.
- Product free of interest
- The order line will be exempt from interest calculation.
- Purchase product
- You can select this option if the product is a purchase product that is not normally held in stock. You can call up the Purchase product field to the order line, showing the same selection. If you want to change the field, the associated Processing method field is also updated.
- Suspended
- Selected automatically when processing incoming product catalogue, if
the product has transactions and is identified by the incoming catalogue as
"deleted".
The parameter is for information only and has no functional use.
Memos and pictures
- Copy memo from product
- The memo from the Product table is copied
to the order lines so that it appears in the order.Note:If you have selected the Copy memo from product or Copy memo from structure check boxes on the Misc. page in the Processing method field in the Product table, only the file reference is copied from the Product table to the Order line table, not the physical file.
If you do not want anyone to make changes in the memo files for products, you must write-protect them.
- Copy memo from structure
- The memo file name entered in the structure lines is copied to the order lines.
- Copy picture from product
- The picture file name from the Product table is copied to the order lines so that it appears in the order.
External
External processing
- Show on Web
- This product will be shown in Zpider.
- Exclude from CRM
- This product will not transferred to Visma CRM.
- Exclude from external system
- Exclude from Visma Mobile
- Exclude from Visma On Demand
Appointment
Agreement rules
- Appointment product
- Calculate full time over midnight
Update balance rules
- Do not update invoiceable
- The Quantity is not updated in the Time schedule balance table.
- Do not update incurred
- The Incurred is not updated in the Time schedule balance table.
- Do not update reserved
- The Time estimate in quantity is not updated in the Time schedule balance table.
- Update overtime
- The Overtime field in the Time schedule balance table
is updated.
Overtime affects the Appointment balance incurred time and Overtime fields of the Time schedule balance table and in turn also the Flextime CB field.
Note:Special for the Appointment table: To select this value, the Wage sort and Wage rate no. must be filled. If either of these fields have a value, the Res. no. must be filled in to retrieve Wage sort and Wage rate no. - Update flex correction
- The Flextime correction field in the Time schedule balance table is updated and in turn also the Flextime CB field.
Approval rules
- Approve disabled
- The Appointment cannot be
approved.Note:Can only be changed by User with the Allow update on appointment processing approve disabled option selected in the User pref. field in the User table. If the Appointment is confirmed, this change does not affect the Time schedule balance and you must update the Time schedule balance manually.
- Requires approval by responsible
- The Official field must be selected for the Appointment. Can be selected if you select the rule to apply in the CRM processing dialog box in the Company information table.
- Ignore credit check
- The Appointment is excluded from credit control.
Transfer to order rules
- Enabled
- Disabled
- Allow uncompleted
- Must approve time schedule
- Copy case number
- This setting depends on which organisational unit number is defined in the Company information table in the Case org. unit field. The value for this organisational unit is copied to order number, so that you avoid entering the same value twice when the order number has the same number as the specified organisational unit. The field is used by Visma Lawyer.
- Cost only
- The price will not be transferred to an order line.
- Get new price from price matrix
- New prices from the Price- and discount matrix table is obtained when transferring to order.
Booking rules
- Block overbooking
- You cannot reserve a resource more than once in the same period.
- Suppress partly booked message
- You do not receive a message when you enter time for a resource which you partly booked.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Proc. method 5 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SpecFunc | The database field name. |
| API identifier | processingMethod5 | The API identifier used in GraphQL. |
| Number | 13990 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 13988 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
| ||
| Product customer | ProductCustomer |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Shipment | Shipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Delivery alternative | DeliveryAlternative |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Shipment | OtherShipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Stock balance | FromStockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Stock balance | ToStockBalance |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product price group 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdPrGr | The database field name. |
| API identifier | productPriceGroup1 | The API identifier used in GraphQL. |
| Number | 13989 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product price group 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdPrG2 | The database field name. |
| API identifier | productPriceGroup2 | The API identifier used in GraphQL. |
| Number | 14115 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product price group 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdPrG3 | The database field name. |
| API identifier | productPriceGroup3 | The API identifier used in GraphQL. |
| Number | 14116 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product type 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdTp | The database field name. |
| API identifier | productType1 | The API identifier used in GraphQL. |
| Number | 14067 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product type 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdTp2 | The database field name. |
| API identifier | productType2 | The API identifier used in GraphQL. |
| Number | 14108 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product type 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdTp3 | The database field name. |
| API identifier | productType3 | The API identifier used in GraphQL. |
| Number | 14145 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product type 4 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdTp4 | The database field name. |
| API identifier | productType4 | The API identifier used in GraphQL. |
| Number | 14146 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | purchaseProduct | The API identifier used in GraphQL. |
| Number | 13995 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoInvoAb | The database field name. |
| API identifier | quantity | The API identifier used in GraphQL. |
| Number | 14005 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoUn | The database field name. |
| API identifier | quantityInBasisUnit | The API identifier used in GraphQL. |
| Number | 14118 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StUnRt | The database field name. |
| API identifier | quantityPerUnit | The API identifier used in GraphQL. |
| Number | 14000 |
Realised stock change; realisation journal line no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcChRealLnNo | The database field name. |
| API identifier | realisedStockChange_RealisationJournalLineNo | The API identifier used in GraphQL. |
| Number | 16607 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal line | RealisedStockChange_RealisationJournalLine |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcChRealJNo | The database field name. |
| API identifier | realisedStockChange_RealisationJournalNo | The API identifier used in GraphQL. |
| Number | 16606 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal | RealisedStockChange_RealisationJournal |
| ||
| Realisation journal line | RealisedStockChange_RealisationJournalLine |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcValRealLnNo | The database field name. |
| API identifier | realisedStockValue_RealisationJournalLineNo | The API identifier used in GraphQL. |
| Number | 16609 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal line | RealisedStockValue_RealisationJournalLine |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcValRealJNo | The database field name. |
| API identifier | realisedStockValue_RealisationJournalNo | The API identifier used in GraphQL. |
| Number | 16608 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal | RealisedStockValue_RealisationJournal |
| ||
| Realisation journal line | RealisedStockValue_RealisationJournalLine |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | YrPr | The database field name. |
| API identifier | realisedYearAndPeriod | The API identifier used in GraphQL. |
| Number | 14119 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Statistics period | StatisticsPeriod |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Realised year/week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | YrWk | The database field name. |
| API identifier | realisedYearAndWeek | The API identifier used in GraphQL. |
| Number | 14120 |
Reference
Optional field for additional information.
The value in the field is copied to the Product transaction table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RefNo | The database field name. |
| API identifier | reference | The API identifier used in GraphQL. |
| Number | 14050 |
Refund no.
When you approve printed refund requests, a document number is inserted in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RepNo | The database field name. |
| API identifier | refundNo | The API identifier used in GraphQL. |
| Number | 14158 |
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.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DelDt | The database field name. |
| API identifier | requiredDeliveryDate | The API identifier used in GraphQL. |
| Number | 14051 |
Required delivery week
the required delivery date saved as day of week number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | requiredDeliveryWeek | The API identifier used in GraphQL. |
| Number | 14052 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Res. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ResNo | The database field name. |
| API identifier | resourceNo | The API identifier used in GraphQL. |
| Number | 14063 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Resource | Resource |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Rsp | The database field name. |
| API identifier | official | The API identifier used in GraphQL. |
| Number | 14056 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Official |
|
Returned
How much has been returned from hire or loan.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | NoRet | The database field name. |
| API identifier | returned | The API identifier used in GraphQL. |
| Number | 14006 |
Scan doc. no.
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PLDNo | The database field name. |
| API identifier | scanDocumentNo | The API identifier used in GraphQL. |
| Number | 14212 |
Scan status
The status of the scanned document.
Is used in connection with Visma Document Center.
- 1 - Scanned document
- 2 - Document on flow
- 4 - Document finished
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Scan status | Integer |
| SQL name | PLDFlow | The database field name. |
| API identifier | scanStatus | The API identifier used in GraphQL. |
| Number | 14213 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SelBuy | The database field name. |
| API identifier | sellerOrBuyer | The API identifier used in GraphQL. |
| Number | 14055 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | SellerOrBuyer |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | RlDelDt | The database field name. |
| API identifier | sentDate | The API identifier used in GraphQL. |
| Number | 14082 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | sentWeek | The API identifier used in GraphQL. |
| Number | 14083 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Serial no. | Text (40) |
| SQL name | SerNo | The database field name. |
| API identifier | serialNo | The API identifier used in GraphQL. |
| Number | 14074 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Shipment no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ShpNo | The database field name. |
| API identifier | shipmentNo | The API identifier used in GraphQL. |
| Number | 14072 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Shipment | Shipment |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (22) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ShpTrIn1 | The database field name. |
| API identifier | shipmentTransactionInformation1 | The API identifier used in GraphQL. |
| Number | 14216 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (22) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ShpTrIn2 | The database field name. |
| API identifier | shipmentTransactionInformation2 | The API identifier used in GraphQL. |
| Number | 14217 |
Sort seq. no.
The order of the lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort seq. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Srt | The database field name. |
| API identifier | sortSequenceNo | The API identifier used in GraphQL. |
| Number | 16209 |
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.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order origin | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcTp | The database field name. |
| API identifier | sourceType | The API identifier used in GraphQL. |
| Number | 14218 |
Sp. tax code
The special tax code for the transaction.
You can override special tax processing in the VAT- and accounting information table.
- 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sp. tax code | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SpcTxCd | The database field name. |
| API identifier | specialTaxCode | The API identifier used in GraphQL. |
| Number | 14044 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StPr | The database field name. |
| API identifier | standardPriceInCurrency | The API identifier used in GraphQL. |
| Number | 14015 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DStPr | The database field name. |
| API identifier | standardPriceDomestic | The API identifier used in GraphQL. |
| Number | 14017 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Source column | Standard price | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | standardPriceInEuro | The API identifier used in GraphQL. |
| Number | 14016 |
Stat. value 1
This is a free field where you can enter break line totals.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Stat1 | The database field name. |
| API identifier | statisticsValue1 | The API identifier used in GraphQL. |
| Number | 14113 |
Stat. value 2
This is a free field where you can enter break line totals.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Stat2 | The database field name. |
| API identifier | statisticsValue2 | The API identifier used in GraphQL. |
| Number | 14114 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcMov | The database field name. |
| API identifier | stockChange | The API identifier used in GraphQL. |
| Number | 14205 |
Stock costs (dom.)
The total stock cost including freight and costs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcCst | The database field name. |
| API identifier | warehouseCostDomestic | The API identifier used in GraphQL. |
| Number | 15906 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StHLnNo | The database field name. |
| API identifier | structureHeadLineNo | The API identifier used in GraphQL. |
| Number | 16214 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Structure level | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StrSt | The database field name. |
| API identifier | structureLevel | The API identifier used in GraphQL. |
| Number | 13991 |
Suggested price
The suggested price.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | SugPr | The database field name. |
| API identifier | suggestedPrice | The API identifier used in GraphQL. |
| Number | 14196 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 13986 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
| ||
| Supplier transaction | SupplierTransaction |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TareL | The database field name. |
| API identifier | tare | The API identifier used in GraphQL. |
| Number | 14132 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TareU | The database field name. |
| API identifier | tarePerUnit | The API identifier used in GraphQL. |
| Number | 14124 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ToNo | The database field name. |
| API identifier | to | The API identifier used in GraphQL. |
| Number | 14003 |
Trans. date
The transaction date for the order.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrDt | The database field name. |
| API identifier | transactionDate | The API identifier used in GraphQL. |
| Number | 13978 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transaction group 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransGr | The database field name. |
| API identifier | transactionGroup1 | The API identifier used in GraphQL. |
| Number | 14068 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transaction group 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransGr2 | The database field name. |
| API identifier | transactionGroup2 | The API identifier used in GraphQL. |
| Number | 14109 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transaction group 3 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransGr3 | The database field name. |
| API identifier | transactionGroup3 | The API identifier used in GraphQL. |
| Number | 14143 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transaction group 4 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransGr4 | The database field name. |
| API identifier | transactionGroup4 | The API identifier used in GraphQL. |
| Number | 14144 |
Trans. information 1
Optional field for additional information.
The original value in the field is suggested based on the value in the Product or Structure table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrInf1 | The database field name. |
| API identifier | transactionInformation1 | The API identifier used in GraphQL. |
| Number | 14147 |
Trans. information 2
Optional field for additional information.
The original value in the field is suggested based on the value in the Product or Structure table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrInf2 | The database field name. |
| API identifier | transactionInformation2 | The API identifier used in GraphQL. |
| Number | 14148 |
Trans. information 3
Optional field for additional information.
The original value in the field is suggested based on the value in the Product or Structure table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrInf3 | The database field name. |
| API identifier | transactionInformation3 | The API identifier used in GraphQL. |
| Number | 14186 |
Trans. information 4
Optional field for additional information.
The original value in the field is suggested based on the value in the Product or Structure table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. information @ | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrInf4 | The database field name. |
| API identifier | transactionInformation4 | The API identifier used in GraphQL. |
| Number | 14187 |
Trans. no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Order jour. no., Trans. no. |
| SQL name | TrNo | The database field name. |
| API identifier | transactionNo | The API identifier used in GraphQL. |
| Number | 13972 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Realisation journal line | RealisationJournalLineJournal |
| 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.
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransSt | The database field name. |
| API identifier | transactionStatus | The API identifier used in GraphQL. |
| Number | 14179 |
Trans. week
The transaction date for the order saved as day of week number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | transactionWeek | The API identifier used in GraphQL. |
| Number | 13979 |
Trans. Year/period
Contains the year and period on the basis of the transaction date in the format YYYYPP in the database.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrYrPr | The database field name. |
| API identifier | transactionYearAndPeriod | The API identifier used in GraphQL. |
| Number | 14206 |
Transaction type
The transaction type for the product defining the way the goods move in or out of the warehouse.
- 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Transaction type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TrTp | The database field name. |
| API identifier | transactionType | The API identifier used in GraphQL. |
| Number | 13977 |
Transp. agr. no.
The supplier's transport agreement number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Transp. agr. no. | Integer |
| SQL name | TspAgrNo | The database field name. |
| API identifier | transportAgreementNo | The API identifier used in GraphQL. |
| Number | 14195 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Transport agreement | TransportAgreement |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Unit | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 13999 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | Unit |
|
Use by date
The use by date for goods you receive.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | DurDt | The database field name. |
| API identifier | useByDate | The API identifier used in GraphQL. |
| Number | 14076 |
Use by week
The use by date for goods you receive saved as day of week number, week number and year.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | useByWeek | The API identifier used in GraphQL. |
| Number | 14077 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VAT and accounting group | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdGr | The database field name. |
| API identifier | taxAndAccountingGroup | The API identifier used in GraphQL. |
| Number | 14036 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT- and accounting information | TaxAndAccountingInformation |
| 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 group | TaxAndAccGroup |
|
VAT code
The tax code from the order.
In the VAT code field in the order head you can override the tax code.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VAT code | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatNo | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 14038 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCode |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatRt | The database field name. |
| API identifier | vatRate | The API identifier used in GraphQL. |
| Number | 16315 |
Visma ID
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WfId | The database field name. |
| API identifier | vismaId | The API identifier used in GraphQL. |
| Number | 14211 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VolL | The database field name. |
| API identifier | volume | The API identifier used in GraphQL. |
| Number | 14136 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VolU | The database field name. |
| API identifier | volumePerUnit | The API identifier used in GraphQL. |
| Number | 14130 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Wage info 1 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AdWage1 | The database field name. |
| API identifier | payrollInformation1 | The API identifier used in GraphQL. |
| Number | 14065 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Wage info 2 | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AdWage2 | The database field name. |
| API identifier | payrollInformation2 | The API identifier used in GraphQL. |
| Number | 14066 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Wage rate no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WageRtNo | The database field name. |
| API identifier | payrollRateNo | The API identifier used in GraphQL. |
| Number | 13982 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Wage sort | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WageSrt | The database field name. |
| API identifier | payrollSort | The API identifier used in GraphQL. |
| Number | 14064 |
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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FrStc | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 13997 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | Warehouse |
| ||
| Shipment | Shipment |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Location | Location |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Stock balance | FromStockBalance |
| 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WebPg | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 14194 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WdtU | The database field name. |
| API identifier | widthPerUnit | The API identifier used in GraphQL. |
| Number | 14127 |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |