XAF General Ledger Information and Basics

The <ledgerAccount> element includes information about the accounts associated with the subsidiary for which you generated the XAF file.

Tag Name	Source Information
accID	If the Account Numbering feature is enabled in your NetSuite account, the data is sourced from the Account Number (acctnumber) field on the account record. If the account number is unavailable, the account name will be used. If the account name (Name field) is longer than 35 characters, the name will be truncated.
accDesc	Entry in the Name (acctname)field on the account record.
accTp	Based on the entry on the Type (accttype) field on the account record, this tag displays: B– For balance sheet accounts such as accounts payables, accounts receivables, bank, credit card, deferred Expense, deferred revenue, equity, fixed asset, long term liability, other asset, other current asset, other current liability, and unbilled receivables. P– For profit and loss accounts such as COGS, expense, income, other expense, and other income.

Tag Name

Source Information

accID

If the Account Numbering feature is enabled in your NetSuite account, the data is sourced from the Account Number (acctnumber) field on the account record. If the account number is unavailable, the account name will be used. If the account name (Name field) is longer than 35 characters, the name will be truncated.

accDesc

Entry in the Name (acctname)field on the account record.

accTp

Based on the entry on the Type (accttype) field on the account record, this tag displays:

B– For balance sheet accounts such as accounts payables, accounts receivables, bank, credit card, deferred Expense, deferred revenue, equity, fixed asset, long term liability, other asset, other current asset, other current liability, and unbilled receivables.
P– For profit and loss accounts such as COGS, expense, income, other expense, and other income.

Basics

The <basics> element contains the master data including items, employees, and other classifications as represented by the following codes:

Code	Source Information for basicType	Source Information for basicID	Source Information for basicDesc
02	Refers to the cost center. The data is sourced from the departments records, which can be viewed at Setup > Company > Classifications > Departments. Note: You can enable the Departments feature at Setup > Company > Setup Tasks > Enable Features. For more information, see Creating Departments.	Entry in the Name (name) field.	Entry in the Name (name) field.
03	Refers to products. The data is sourced from item records, which can be viewed at Lists > Accounting > Items.	Entry in the Item Name/Number (itemid) field.	Entry in the Display Name/Code (displayname) field.
04	Refers to projects. The data is sourced from project records, which can be viewed at Lists > Relationships > Projects. Note: You can enable the Projects feature at Setup > Company > Setup Tasks > Enable Features. For more information, see Enabling Project Features.	Entry in the Job ID (entityid) field.	Entry in the Project Name(companyname) field.
05	Refers to article groups. The data is sourced from classes, which can be viewed at Setup > Company > Classifications > Classes.	Entry in the Name (name) field.	Entry in the Name (name) field.
12	Refers to journals. NetSuite does not use the same journal types as referred to in XAF. Fiscal year information will be used. You can access the fiscal year record at Setup > Accounting > Manage G/L > Manage Accounting Periods.	The year you entered in the End Period (custpage_end_period) field on the Country Tax Report page when you generated the XAF file.	The year you entered in the End Period (custpage_end_period) field on the Country Tax Report page when you generated the XAF file.
14	Refers to quantities. The data is sourced from units of measure records, which can be viewed at Lists > Accounting > Units of Measure.	Entry in the Name column.	Entry in the Type Name (name) field.
30	Refers to users. The data is sourced from employee records associated with the transactions under a given subsidiary that you are reporting in the XAF file. You can view employee records at Lists > Employees >Employees	If you have the autonumbering feature enable for your employee records, then this tag displays the ID. If not, the entry in the Employee ID(entityid) field is used.	Entry in the Employee ID(entityid) field.

Code

Source Information for basicType

Source Information for basicID

Source Information for basicDesc

Refers to the cost center. The data is sourced from the departments records, which can be viewed at Setup > Company > Classifications > Departments.

Note:

You can enable the Departments feature at Setup > Company > Setup Tasks > Enable Features. For more information, see Creating Departments.

Entry in the Name (name) field.

Refers to products. The data is sourced from item records, which can be viewed at Lists > Accounting > Items.

Entry in the Item Name/Number (itemid) field.

Entry in the Display Name/Code (displayname) field.

Refers to projects. The data is sourced from project records, which can be viewed at Lists > Relationships > Projects.

Note:

You can enable the Projects feature at Setup > Company > Setup Tasks > Enable Features. For more information, see Enabling Project Features.

Entry in the Job ID (entityid) field.

Entry in the Project Name(companyname) field.

Refers to article groups. The data is sourced from classes, which can be viewed at Setup > Company > Classifications > Classes.

Entry in the Name (name) field.

Refers to journals. NetSuite does not use the same journal types as referred to in XAF. Fiscal year information will be used. You can access the fiscal year record at Setup > Accounting > Manage G/L > Manage Accounting Periods.

The year you entered in the End Period (custpage_end_period) field on the Country Tax Report page when you generated the XAF file.

Refers to quantities. The data is sourced from units of measure records, which can be viewed at Lists > Accounting > Units of Measure.

Entry in the Name column.

Entry in the Type Name (name) field.

Refers to users. The data is sourced from employee records associated with the transactions under a given subsidiary that you are reporting in the XAF file. You can view employee records at Lists > Employees >Employees

If you have the autonumbering feature enable for your employee records, then this tag displays the ID. If not, the entry in the Employee ID(entityid) field is used.

Entry in the Employee ID(entityid) field.

Basics

Related Topics: