Accounting period
This table contains one row for each accounting period.
You can divide each accounting year into as many accounting periods as desired for reporting and follow-up purposes, for example one period for each month, numbered 1 to 12, and an extra year-end period as number 13.
When you enter vouchers, Business NXT suggests the first accounting period the value date falls within, but you can also select a different period, when you post on a subsequent period.
The following fields exist in this table:
Acc. period processing
Settings defining the behaviour of the accounting period.
- Exempt from accrual accounting
- The accounting period will be omitted from accrual accounting. This
applies for calculation of both the start period and the number of periods over which
accrual accounting extends.
You will receive an error message if accounting periods are omitted. If you use 13 periods in the financial year, period 13 will usually be omitted from accrual accounting.
- Physical balance row created
- Closed
- This option is updated whenever the processing Move suspension date in Company information table is executed and cannot be changed manually in the dialog.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Acc. period processing | Integer |
| SQL name | ExPer | The database field name. |
| API identifier | accountingPeriodProcessing | The API identifier used in GraphQL. |
| Number | 5798 |
Description
The description of the accounting period.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 5581 |
From date
The first day in the date range for the accounting period.
This range is checked to determine the accounting period to which individual vouchers belong.
If you press + in this field, the first day of the period in relation to the previous row will be suggested.
You define which month the financial year starts with in the 1. accounting month field in the Company information table. The default value is January.
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 |
| SQL name | FrDt | The database field name. |
| API identifier | fromDate | The API identifier used in GraphQL. |
| Number | 527 |
Next period batch no.
Defines the next period batch in the Batch table.
If you press + in the Period batch no. field in the Batch table, this number will be used.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | NxtPrBt | The database field name. |
| API identifier | nextPeriodBatchNo | The API identifier used in GraphQL. |
| Number | 10560 |
Period
The number of the accounting period, within the year.
Accounting data can be retained for several years, which is why both year and period are entered. Different financial years are permitted, and there are no restrictions on the number of accounting periods per year.
The most common method is to use monthly periods, i.e. periods 01 to 12. You can also have one or more year-end periods.
If you press + in this field, the next period in relation to the previous row will be suggested.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Period | Integer |
| Primary key | Yes | Year, Period |
| SQL name | Pr | The database field name. |
| API identifier | period | The API identifier used in GraphQL. |
| Number | 526 |
To date
The last day in the date range for the accounting period.
This range is checked to determine the accounting period to which individual vouchers belong.
If you press + in this field, the last day of the period in relation to the previous row will be suggested.
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 |
| SQL name | ToDt | The database field name. |
| API identifier | toDate | The API identifier used in GraphQL. |
| Number | 528 |
Year
The year of the accounting period.
Accounting data can be retained for several years, which is why both year and period are entered. Different financial years are permitted, and there are no restrictions on the number of accounting periods per year.
The most common method is to use monthly periods, i.e. periods 01 to 12. You can also have one or more year-end periods.
You only need to enter the last two numbers of the year. If you press + in this field, the same year as in the previous row will be suggested.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Year | Integer |
| Primary key | Yes | Year, Period |
| SQL name | Yr | The database field name. |
| API identifier | year | The API identifier used in GraphQL. |
| Number | 525 |
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 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 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. |