Kris Jones
07/31/2020, 10:02 PMItems you have requested in the record have been deleted since you retrieved the form
when trying to create an Inventory Adjustment record? Such a vague error 😕 Here's the code (please excuse all the magic values, it has a very specific use case):
/**
* @NApiVersion 2.x
* @NScriptType Suitelet
*/
import { EntryPoints } from 'N/types';
import * as log from 'N/log';
import * as ui from 'N/ui/serverWidget';
import * as record from 'N/record';
export const onRequest: EntryPoints.Suitelet.onRequest = (scriptContext: EntryPoints.Suitelet.onRequestContext) => {
if (scriptContext.request.method === 'GET') {
// render the form
const form = ui.createForm({
title: 'Enter Catalog Request Amount'
});
form.addField({
id: 'catalog_quantity',
type: ui.FieldType.INTEGER,
label: 'Catalog Quantity'
});
form.addSubmitButton({
label: 'Submit Quantity'
});
scriptContext.response.writePage(form);
} else {
// === submission of form, use field ids given
// as request parameters to create inventory adjustment record
const catalogQuantity = scriptContext.request.parameters.catalog_quantity;
if (catalogQuantity) {
const adjustmentRecord = record.create({
type: record.Type.INVENTORY_ADJUSTMENT,
isDynamic: false
});
// default custom form
adjustmentRecord.setValue({
fieldId: 'customform',
value: 10
});
adjustmentRecord.setValue({
fieldId: 'trandate',
value: new Date()
});
adjustmentRecord.setValue({
fieldId: 'subsidiary',
value: 1
});
adjustmentRecord.setValue({
fieldId: 'account',
value: 1242
});
adjustmentRecord.insertLine({
sublistId: 'inventory',
line: 0
});
adjustmentRecord.setSublistValue({
sublistId: 'inventory',
fieldId: 'item',
value: 276221,
line: 0
});
adjustmentRecord.setSublistValue({
sublistId: 'inventory',
fieldId: 'location',
value: 2,
line: 0
});
adjustmentRecord.setSublistValue({
sublistId: 'inventory',
fieldId: 'adjustqtyby',
value: catalogQuantity,
line: 0
});
const inventoryDetailSubrecord = adjustmentRecord.getSublistSubrecord({
sublistId: 'inventory',
fieldId: 'inventorydetail',
line: 0
});
inventoryDetailSubrecord.insertLine({
sublistId: 'inventoryassignment',
line: 0
});
inventoryDetailSubrecord.setSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'issueinventorynumber',
value: 803,
line: 0
});
inventoryDetailSubrecord.setSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'quantity',
value: catalogQuantity,
line: 0
});
adjustmentRecord.save();
}
}
}
battk
07/31/2020, 10:19 PMbattk
07/31/2020, 10:19 PMKris Jones
07/31/2020, 10:21 PMbattk
07/31/2020, 10:23 PMbattk
07/31/2020, 10:24 PMbattk
07/31/2020, 10:25 PMKris Jones
07/31/2020, 10:38 PMKris Jones
07/31/2020, 10:48 PMbinnumber
. Thank you for your help!