Global Account Mapping
For accounts using Multi-Book Accounting, the global account mapping record enables you to configure secondary accounting books to post to accounts different from the primary book. These mappings are used by transactions where the user can manually select the account to which the transaction posts.
The internal ID for this record is globalaccountmapping.
Using this record requires that, as part of your Multi-Book configuration, you select the Chart of Accounts Mapping option at Setup > Company > Enable Features, on the Accounting subtab, in addition to the other setup steps required for Multi-Book Accounting.
In the UI, you access this record at Setup > Accounting > Global Account Mappings > New.
For help working with this record in the UI, see Global Account Mapping.
See the SuiteScript Records Browser for all internal IDs associated with this record.
For information about using the SuiteScript Records Browser, see Working with the SuiteScript Records Browser in the NetSuite Help Center.
For information about scripting with this record in SuiteScript, see the following help topics:
Supported Script Types
This record is scriptable in server SuiteScript only.
All three user events are supported: beforeLoad, beforeSubmit, and afterSubmit.
Supported Functions
This record is fully scriptable, which means it can be created, updated, copied, deleted, and searched using SuiteScript.
Code Samples
The following samples show how to create global account mapping records and perform other basic tasks.
// Create Record
var gamRec = record.create({
type: record.Type.GLOBAL_ACCOUNT_MAPPING
});
gamRec.setValue({
fieldId: 'effectivedate',
value: new Date('4/4/2004')
});
gamRec.setValue({
fieldId: 'accountingbook',
value: '2'
});
gamRec.setValue({
fieldId: 'sourceaccount',
value: '6'
});
gamRec.setValue({
fieldId: 'subsidiary',
value: '1'
});
gamRec.setText({
fieldId: 'class',
text: 'Class US'
});
gamRec.setText({
fieldId: 'department',
text: 'Department US'
});
gamRec.setText({
fieldId: 'location',
text: 'Location US'
});
gamRec.setValue({
fieldId: 'destinationaccount',
text: '6'
});
var id = gamRec.save();
// Update Record
var gamRec = record.load({
type: record.Type.GLOBAL_ACCOUNT_MAPPING,
id: '102'
});
gamRec.setValue({
fieldId: 'effectivedate',
value: new Date('5/5/2005')
});
gamRec.setText({
fieldId: 'sourceaccount',
value: 'Advances Paid'
});
gamRec.setText({
fieldId: 'destinationaccount',
value: 'ABN Withholding'
});
var id = gamRec.save();
// Delete Record
var gamRec = record.delete({
type: record.Type.GLOBAL_ACCOUNT_MAPPING,
id: '102'
});
// Copy Record
var gamRec = record.copy({
type: record.Type.GLOBAL_ACCOUNT_MAPPING,
id: '103'
});
gamRec.setValue({
fieldId: 'effectivedate',
value: new Date('5/5/2005')
});
gamRec.setText({
fieldId: 'sourceaccount',
text: 'Advances Paid'
});
gamRec.setText({
fieldId: 'destinationaccount',
text: 'ABN Withholding'
});
var id = gamRec.save();