Hello,
I am having the following problem when generating an Inventory Adjustment from Script for an item of type Numbered Lot Inventory Item:
“You have entered an invalid field value 114 for the following field: binnumber.”
When I do this from the user interface, it works fine.
Here is part of the code in question:
var invAdjust = record.create({
type: record.Type.INVENTORY_ADJUSTMENT,
isDynamic: true
});
invAdjust.setValue({ fieldId: 'subsidiary', value: 1 });
invAdjust.setValue({
fieldId: 'account',
value: 773
});
invAdjust.setValue({ fieldId: 'department', value: 5 });
var itemId = 65490;
var quantity = 2;
var locationId = 2;
var status = 1; // Good
invAdjust.selectNewLine({
sublistId: 'inventory'
});
invAdjust.setCurrentSublistValue({
sublistId: 'inventory',
fieldId: 'item',
value: itemId
});
invAdjust.setCurrentSublistValue({
sublistId: 'inventory',
fieldId: 'adjustqtyby',
value: -quantity
});
invAdjust.setCurrentSublistValue({
sublistId: 'inventory',
fieldId: 'location',
value: locationId
});
var invDetail = invAdjust.getCurrentSublistSubrecord({
sublistId: 'inventory',
fieldId: 'inventorydetail'
});
invDetail.selectNewLine({
sublistId: 'inventoryassignment'
});
invDetail.setCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'inventorynumber',
value: 2610820
});
invDetail.setCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'quantity',
value: -quantity
});
invDetail.setCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'binnumber',
value: 114
});
if (status) {
invDetail.setCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'inventorystatus',
value: status
});
}
invDetail.commitLine({
sublistId: 'inventoryassignment'
});
invAdjust.commitLine({
sublistId: 'inventory'
});
var idinvAdjust = invAdjust.save({
ignoreMandatoryFields: true
});