Statistical Journal Entry Body and Sublist Fields

When you create a statistical journal entry, you must define certain body fields, and you must create at least one sublist line.

The required body fields are described in the following table.

Field	Description
Unit of Measure Type	This field must reference an existing field listed at Lists > Accounting > Units of Measure. Later, when you populate the sublist, the account associated with each line must be of this unit type. This field cannot be updated after the statistical journal entry record has been created.
Subsidiary (OneWorld only)	This field must reference an existing subsidiary listed at Company > Setup > Subsidiaries. Later, when you populate the sublist, each account you choose must be a valid account for this subsidiary. This field cannot be updated after the statistical journal entry record has been created. However, you can update this field through the user interface. To update the field, delete the lines from the sublist, select a new subsidiary, add new lines, and then save the modified record.

Field

Description

Unit of Measure Type

This field must reference an existing field listed at Lists > Accounting > Units of Measure. Later, when you populate the sublist, the account associated with each line must be of this unit type.

This field cannot be updated after the statistical journal entry record has been created.

Subsidiary (OneWorld only)

This field must reference an existing subsidiary listed at Company > Setup > Subsidiaries. Later, when you populate the sublist, each account you choose must be a valid account for this subsidiary.

This field cannot be updated after the statistical journal entry record has been created. However, you can update this field through the user interface. To update the field, delete the lines from the sublist, select a new subsidiary, add new lines, and then save the modified record.

Note:

As of 2015.2, you can also map a Memo field for the body of statistical journal entry. This field is in addition to the Memo field available in the Lines sublist.

Every statistical journal entry record must have at least one sublist line. Each line must include values for the fields described in the following table.

Field	Description
Account	This field must reference an existing statistical account listed at Lists > Accounting > Accounts. The account you choose must be valid for the Subsidiary body field value, and it must use the same unit of measure specified in the Unit of Measure Type body field.
Amount	This field takes a double value that represents the adjustment you want to make to the account. Entering a positive amount increases the value of the account. Entering a negative amount decreases the value.

Field

Description

Account

This field must reference an existing statistical account listed at Lists > Accounting > Accounts. The account you choose must be valid for the Subsidiary body field value, and it must use the same unit of measure specified in the Unit of Measure Type body field.

Amount

This field takes a double value that represents the adjustment you want to make to the account. Entering a positive amount increases the value of the account. Entering a negative amount decreases the value.

For more details about fields that can be mapped, refer to the SOAP Schema Browser’s statistical journal entry reference page. You can use the field definitions here as a basis for creating your own CSV import template file. For information about working with the SOAP Schema Browser, see SOAP Schema Browser.

The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.

Related Topics