Paycheck Journal
The Paycheck Journal record is intended to enable global payroll solutions. You can use it along with the Payroll Item record to create custom payroll solutions and to support integrations with external payroll systems.
For help working with this record in the UI, see Paycheck Journal Feature.
The internal ID for this record is paycheckjournal.
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:
Usage Notes
The Paycheck Journal feature must be enabled to work with the Paycheck Journal record.
Code Samples
The following sample creates a paycheck journal transaction.
// create Paycheck Journal with two earnings and one deduction sublist
function createPaycheckJournal(){
var pj = record.create ({
type: record.Type.PAYCHECK_JOURNAL,
isDynamic: true
});
pj.setValue({
fieldId: 'trandate',
value: '6/10/2012'
});
pj.setValue({
fieldId: 'employee',
value: 4 // internal ID of the employee
});
pj.setValue({
fieldId: 'account',
value: 28 // internal ID of the account
});
pj.selectNewLine({
sublistId: 'earning'
});
pj.setCurrentSublistValue({
sublistId: 'earning',
fieldId: 'payrollitem',
value: '102'
});
pj.setCurrentSublistValue({
sublistId: 'earning',
fieldId: 'amount',
value: 20.35
});
pj.commitLine({
sublistId: 'earning'
});
pj.selectNewLine({
sublistId: 'earning'
});
pj.setCurrentSublistValue({
sublistId: 'earning',
fieldId: 'payrollitem',
value: '102'
});
pj.setCurrentSublistValue({
sublistId:'earning',
fieldId: 'amount',
value: 33.35
});
pj.commitLine({
sublistId: 'earning'
});
pj.selectNewLine({
sublistId: 'deduction'
});
pj.setCurrentSublistValue({
sublistId: 'deduction',
fieldId: 'payrollitem',
value: '103'
});
pj.setCurrentSublistValue({
sublistId: 'deduction',
fieldId: 'amount',
value: 444.44
});
pj.commitLine({
sublistId: 'deduction'
});
var recordId = pj.save();
}
The following sample updates a paycheck journal transaction.
// update Paycheck journal by setting new amount of line 2 earning list
// and clearing the deduction list
function updatePaycheckJournal(){
var pj = record.load({
type: record.Type.PAYCHECK_JOURNAL,
isDynamic: true,
id: 305
});
pj.setSublistValue({
sublistId: 'earning',
fieldId: 'amount',
line: 2, // 1 is the line number we intend to update
value: 444.44
});
var lineCount = pj.getLineCount({
sublistId: 'deduction'
});
for (var lineNo = 1; lineNo <= lineCount; lineNo++) {
pj.removeLine({
sublistId: 'deduction',
line: lineNo
});
}
var recId = pj.save();
}