Order line

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.

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.

For sales order lines, the original value in the field is suggested based on the value in the Stock balance table.

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

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.

The value is updated in both sales orders and purchase/production orders when saved.

The value increases in connection with allocation and is reduced when withdrawing an allocated quantity. The quantity ordered or produced is based on Total quantity minus Reserved quantity in the order line from which the purchase/production order is generated.

If the value in the Allocated order no. field on the production order is deleted, the value in the Allocated field on the production order and the purchase order will be reset. A negative quantity on an order cannot be finished if the allocated quantity is positive.

It is not possible to reduce the quantity without removing the value in the Allocated order no. field and then entering the value again. In order to increase the quantity, the purchase order quantity must be changed first and then the value in the Allocated order no. field has to be deleted and created.

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.

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.

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.

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.

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.

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.

This is the maximum quantity which is available for picking and is also the quantity suggested when printing pick lists.

When the structure head is exempted from warehousing, the picked quantity is saved in the structure head. The Balance to pick field is then also calculated. If the Finish picked quantity with menu choice check box in the Proc. method 1 field is selected, the structure head will also be finished when finishing the picked quantity.

If the box to Pick same fraction of structure lines and the Pick complete structure check boxes in the Proc. method 1 field both are selected, the picked quantity is calculated as the share which has been picked. Otherwise the full quantity applies.

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.

This field is selected when you run the Cancel processing in the Order or Order line 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.

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

Used in the integration between Zpider and Business NXT. With this field, the changes you make in Business NXT are updated in Zpider immediately.

When you save the value in this field reduces the stock level and is accumulated in the Lost field in the Shipment table and updates the Compensate field.

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.

When you save the quantity is updated in the Confirmed field.

The date is validated using the regional settings in Windows.

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.

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.

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

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

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

The value itself is not relevant. The reason for having a value rather than a check box is that you can have several group of order lines in one order by assigning them different numbers. The order lines in a group need not be consecutive.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

When you save the value in this field reduces the stock level and is accumulated in the Lost field in the Shipment table and updates the Discarded field.

This field is a visualisation of the Discontinued from range check box in the Order line status field.

The field also contains internal duplications on the order line, e.g. between quantity and incurred. If you override the values on the order lines, the flags will be turned off. You cannot edit this field.

Order date

Currency no.

Exchange rate

Seller/buyer

Responsible

Organisational unit 1

Organisational unit 2

Organisational unit 3

Organisational unit 4

Organisational unit 5

Organisational unit 6

Account set

VAT code

Cust. no.

Invoice customer no.

Customer price gr. 1

Sup. no.

Payment supplier no.

Trans. group 1

Warehouse no.

Transf. to warehouse

Required delivery date

Confirmed delivery date

Invoice reference

Incurred quantity

Invoiceable quantity

Empl. no.

Employee price gr.

Wage rate no.

Cost currency no.

Cost exchange rate

Country no.

If you override the values on the order lines, the flags will be turned off. You cannot edit this field.

Delivery associate no.

Delivery method

Transaction type

Expected return date

Trans. group 2

Price description

Price wage sort

Arrival/departure date

Customer price gr. 2

Trans. group 3

Trans. group 4

Price tax code

Price price type

Customer price gr. 3

Transp. agr. no.

Organisational unit 7

Organisational unit 8

Organisational unit 9

Organisational unit 10

Organisational unit 11

Organisational unit 12

Cap. asset no.

Des. prod. start date

Period key

Free 1

Free 2

Free 3

Free 4

Corporate company no.

Status

Shows what happened to changes after the import of EDI messages.

Line is edited

Line added by supplier

Line added by buyer

Awaiting processing

DDS reference overflow

Location error

Shows which location roles do not have a value in the EAN loc. code field in the Associate table. If you have selected the Set unprocessed if error field under EDI processing in the Company information table, the order is set to order type 6 - Unprocessed order, if it is an EAN loc. code error.

You can remove these selections manually to run the order.

Customer

Invoice customer

Delivery associate

Supplier

Stock

Product

AutoInvoice

Shows updates made to the order line based on incoming documents received through AutoInvoice.

Rejected by supplier

When set, the order line has been automatically cancelled by the supplier.

Delivery date changed

Order line has been confirmed by the supplier with a new delivery date.

Quantity confirmed

Order line quantity has been confirmed by the supplier.

Quantity partially confirmed

Parts of the order line quantity has been confirmed by the supplier.

Quantity increased by supplier

Order line quantity has been increased based on data in an incoming document.

Product not found

Product number was not identified when the order line was updated while processing an incoming document.

Product replaced

Order line product was replaced based on a change made by the supplier.

Price changed by supplier

The order line price was updated based on a change made by the supplier.

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

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

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.

If you have selected Exchange arrangement in the Proc. method 1 field the value is calculated as the product of the Exchange price field in the Order table, the Exchange quantity field and the relevant quantity in the Order line table.

This field is a visualisation of the Exempt from warehousing check box on the Warehousing page in the Proc. method 2 field.

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.

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.

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.

When you save the quantity is updated in the Finished field.

Limitations to changing the field

Finish 0 and release reservations

If you enter 0 in the field and finish, the reservation is withdrawn and you can print a new pick list. The Finish 0 and release reservations check box in the Order line status field is temporary selected. After saving or processing of the order, the check box is cleared. It is only stored temporarily so that the system can read keying of the value 0 as a 0 entry, because the default value in the field is also 0.

There is also a corresponding field in the Reservation table, but this field does not have the same logic for 0 entry.

Finish negative numbers

You are allowed to finish a negative quantity if you have selected the Delete rest when filling in "Finish NOW" check box on the Editing page in the Processing method field. This causes the total quantity to be reduced. If you want to withdraw the quantity and keep it for a later interim delivery, you must deselect Delete rest when filling in "Finish NOW", otherwise the quantity will be reset to zero.

The value in this field constitutes the total of the values in the Finished field in the relevant rows in the Reservation table.

The field shows the font family, style and size within square brackets. In the database there are three separate fields for font family, font style and font size. The field shown on the screen keeps the font size in the database.

Is normally set with the Font command (in the Design group in the Home tab).

The font size may be set as a percentage (e.g. 120) of the normal font size, cf. the Relative option in the Type drop-down list in the dialog box.

When invoices are approved after printing, the part of the free quantity that has been used from the Free quantity field is totalled in the this field.

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.

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.

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.

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.

Specify in %

Freight 1

Freight 2

Freight 3

Freight 4

Customs

Calculate customs from

Freight 1

Freight 2

Freight 3

Freight 4

Additional cost distribution

From order line

Amount

Net weight

Gross weight

Volume

Quantity

The time spent in will be converted to a decimal value in the (Weekday) quantity field, and the total of all days will be accumulated in the Quantity field.

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.

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.

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.

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.

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.

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

The field cannot be overridden.

On the Misc. page in the Proc. method 1 field you can configure a product to be used as a Group discount or Group total. When using several group discount on an order, those can be linked into one. If they is to be handled separately you can add a value in this field.

Group discounts and totals are calculated by the above order lines up to any initial group separator and can be combined in an unlimited number of levels. This field indicates the beginning of the group.

When you use groups inside other groups without a group separator in between, you produce chain discounts/additions of discounts/additions granted previously.

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

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