Business NXT documentation

Home
Logistics
Business NXT is specially developed for companies with high demands on inventory and logistics management. The broad and advanced functionality facilitates the work of optimising logistics flows.
Products
Product information in Business NXT is divided into a number of tables.
Product customer
This table is used to save the customer's own product number which will be suggested in the Trans. information 2 field on the Order line if you have selected Suggest customer product no. in the Order processing 2 field in the Company information table.

Logistics
Business NXT is specially developed for companies with high demands on inventory and logistics management. The broad and advanced functionality facilitates the work of optimising logistics flows.
- Base data
  The tables in this section include base data that applies to products.
- Products
  Product information in Business NXT is divided into a number of tables.
  - Product
    The Product table contains one row for each goods or service.
  - Product processings
    The following processings are available from the Product table:
  - Product reports
    The following report is available for the Product table:
  - Delivery alternative
    This table is used when creating purchase estimates, purchase orders and generating orders.
  - Barcode
    This table contains one row for each barcode, including product number, unit and other fields.
  - Unit
    This table contains one row for each unit. You can enter descriptions of the various units in which you buy and sell products.
  - Product category
    This table contains one row for each product category and can be used to group products hierarchically.
  - Product description
    In the Product description table you can enter an alternative product description per language.
  - Alternative product
    In the Alternative product table, you enter which alternative products can replace a product if the original product is currently sold out or you have too few in stock.
  - Product customer
    This table is used to save the customer's own product number which will be suggested in the Trans. information 2 field on the Order line if you have selected Suggest customer product no. in the Order processing 2 field in the Company information table.
  - Structure
    The Structure table defines which sub products each structure product consists of.
  - Structure processings
    The following processing is available for the Structure table.
  - Search product
    When you search in the Product no. field, the search is made in both number and description fields.
  - Price calculation
    Price calculation is performed during order entry, generating price lists and printing product catalogues. Business NXT will always suggest the most favourable price and/or discount for the customer/supplier.
  - Processing method
    The Processing method menu item in the Processing menu in the Product table has a large number of options that you can use to control how Business NXT processes each product or underlying structure products.
  - VAT- and accounting information
    You divide the products into groups using the VAT and accounting group field in the Product table, while in the Associate table you can refer customers/suppliers to Account set cust./ Account set sup..
  - Import of product data
    Product data can be imported to Business NXT from Visma AutoInvoice as a product catalogue XML file.
- Warehouse
  This section deals with the various tables, layouts and processes that affect the warehouse.
- Purchase estimates
  The purchase estimate process is described in the Order processes section.
- Order processes
- Orders
  Business NXT provides a variety of functionalities to ensure efficient handling of orders.
- Statistics
  The following tables and processes are related to statistics.

Product customer

This table is used to save the customer's own product number which will be suggested in the Trans. information 2 field on the Order line if you have selected Suggest customer product no. in the Order processing 2 field in the Company information table.

See also: Company information

Property	Value	Description
Database	Company	This table is in the company databases.
SQL name	ProdCust	The table name in the database.
API identifier	productCustomer	The API identifier used in GraphQL.
Table no.	185	The table number in the data model.

The following fields exist in this table:

Cust. no.

The customer you want to define a product for.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Cust. no.	Integer
Primary key	Yes	Product no., Cust. no.
SQL name	CustNo	The database field name.
API identifier	customerNo	The API identifier used in GraphQL.
Number	6705

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Associate	Customer	Cust. no.	Cust. no.

Customer's product no.

A unique number identifying the product for the customer.

Tip:

If you have selected the Customer's product no. check box in the Order processing 2 field in the Company information table, this value is suggested in the Trans. information 2 field in the Order line table when you enter the Product no. or Cust. no..

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Product no.	Text (40)
SQL name	CProdNo	The database field name.
API identifier	customersProductNo	The API identifier used in GraphQL.
Number	6706

Default unit

The default sales unit to be used on the Order, if it differs from the unit defined for the product and the customer.

Unit texts for different languages can be defined in the Text table. These texts has text type 16.

Note:

If you double-click or press * in this field, you can look up a Unit in the Text table.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Unit	Integer
SQL name	StSaleUn	The database field name.
API identifier	unit	The API identifier used in GraphQL.
Number	11937

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Unit	Unit	Default unit	Unit

Inf. 1

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf	The database field name.
API identifier	information1	The API identifier used in GraphQL.
Number	6968

Inf. 2

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf2	The database field name.
API identifier	information2	The API identifier used in GraphQL.
Number	6969

Inf. 2

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf2	The database field name.
API identifier	information2	The API identifier used in GraphQL.
Number	6969

Inf. 3

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf3	The database field name.
API identifier	information3	The API identifier used in GraphQL.
Number	6970

Inf. 4

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf4	The database field name.
API identifier	information4	The API identifier used in GraphQL.
Number	9261

Inf. 5

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf5	The database field name.
API identifier	information5	The API identifier used in GraphQL.
Number	9262

Inf. 6

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf6	The database field name.
API identifier	information6	The API identifier used in GraphQL.
Number	9263

Inf. 7

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf7	The database field name.
API identifier	information7	The API identifier used in GraphQL.
Number	9264

Inf. 8

Additional product customer information.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf8	The database field name.
API identifier	information8	The API identifier used in GraphQL.
Number	9265

Product no.

The product to link to the customer.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Product no.	Text (40)
Primary key	Yes	Product no., Cust. no.
SQL name	ProdNo	The database field name.
API identifier	productNo	The API identifier used in GraphQL.
Number	6704

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Product	Product	Product no.	Product no.
Search product	SearchProduct	Product no.	Product no.

Quantity per unit

Quantity per unit to be used on the Order, if it differs from the quantity defined for the product and the customer.

This could for example be Box, where the box contains a different quantity depending on the product and supplier concerned.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	StUnRt	The database field name.
API identifier	quantityPerUnit	The API identifier used in GraphQL.
Number	11938

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.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

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.

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.