Automate values on inventory adjustment Record in NetSuite
Category : NetSuite suitescript SuiteScript 2.0 Uncategorized
A Customer want to automate few values on the inventory adjustment record here I am writing few updates on how easily you can achieve the customization via User event or Client script. Here we choose Adjustment Account, fielded: Account (Select the appropriate account for inventory adjustments. Usually, this will be an expense account. For details on accounts, go to Setup > Accounting > Chart of Accounts.) and
Adjustment Location Field id: Adjlocation( To select the location to associate with this adjustment transaction:
1.Select New to enter a new location.
2.Go to Setup > Company > Locations for information on existing locations.)
The values for the fields of Account and Adjlocation of Inventory Adjustment records are dependent on the Subsidiary record. Thus, to set the values via a Client script, it is needed to set the Subsidiary value first via a User Event script before setting the value of Account and Adjlocation via postSourcing. this can be Achieved via Client and User Event scripts:
User Event Script:
define([ ‘N/error’ ], function(error) {
function beforeLoad(scriptContext) {
var MyRecord = scriptContext.newRecord;
MyRecord.setValue({
fieldId : ‘subsidiary’,
value : 123,
ignoreFieldChange : true,
fireSlavingSync : true
});
log.debug({
title : ‘Debug’,
details : ‘Account ‘
});
MyRecord.setValue({
fieldId : ‘account’,
value : 999,
ignoreFieldChange : true,
fireSlavingSync : true
});
}
return {
beforeLoad : beforeLoad
};
});
Reference : netsuite.com, netsuite help and netsuite guide.
Feel free to reach out Netsuite Solution provider TheSmilingCoders for proper netsuite implementation, netsuite consultation , netsuite customization, netsuite Support, netsuite Training , NetSuite Celigo Integration , Celigo Consultant, Celigo Integration Consultant.
contact us : [email protected]
Linkedin : https://www.linkedin.com/company/netsuite-academy/