var item = record.load({
typ...
# suitescripta
Ahmed
01/27/2020, 7:55 AMvar item = record.load({
type: record.Type.INVENTORY_ITEM,
id: 2712
});
log.debug('Item details ', item);
var inv=item.getSubrecord({ fieldId: 'inventorydetail' });
var split=JSON.stringify(inv).split(",");
for(var s=0;s<split.length;s++)
{
log.debug('inventory ', split[s]);
}
Error
{"type":"error.SuiteScriptError","name":"FIELD_1_IS_NOT_A_SUBRECORD_FIELD","message":"Field inventory is not a subrecord field.","stack":["anonymous(N/serverRecordService)","takeAction(/SuiteScripts/Webhive/ma_inventory_transfer.js:54)"],"cause":{"type":"internal error","code":"FIELD_1_IS_NOT_A_SUBRECORD_FIELD","details":"Field inventory is not a subrecord field.","userEvent":"beforesubmit","stackTrace":["anonymous(N/serverRecordService)","takeAction(/SuiteScripts/Webhive/ma_inventory_transfer.js:54)"],"notifyOff":false},"id":"","notifyOff":false,"userFacing":false}
*************************************************
I want to get the quantity available for the specific inventoryitem for a specific location. How can i do that using suit script ! I tried but encountered the error mentioned above,
b
battk
01/27/2020, 8:05 AMdo you know the difference between a sublist and a subrecord?
a
Ahmed
01/27/2020, 9:05 AMI will have a look at it
Ahmed
01/27/2020, 9:16 AMHow do i know difference between sublist and subrecord ? Record Browser ?
b
battk
01/27/2020, 9:21 AMusually its a simple concept. Sublists are rows of data, subrecords are records that are part of another record
a
Ahmed
01/27/2020, 9:26 AMI am trying to fetch quantity available for the specific location.. What should i do in this case ?
var item = record.load({
type: record.Type.INVENTORY_ITEM,
id: 2712
});
log.debug('Item details ', item);
var inv=item.getSublist({ sublistId: 'inventoryassignment' });
Tried this but didn't work
b
battk
01/27/2020, 9:27 AMhave you ever worked with sublists before
a
Ahmed
01/27/2020, 9:27 AMyes item sublist on sales order
b
battk
01/27/2020, 9:27 AMthe sublist is not very different
battk
01/27/2020, 9:28 AMyou get its id, and then its fields and use the getSublistValue method
battk
01/27/2020, 9:28 AMgetSublist is for getting metadata about the sublist
battk
01/27/2020, 9:29 AMand there is no inventoryassignment sublist on an inventory item
a
Ahmed
01/27/2020, 9:29 AMwhere can i find the id of this sublist in record browser
b
battk
01/27/2020, 9:30 AMitem is for generic item searches
battk
01/27/2020, 9:30 AMyou want inventory part
battk
01/27/2020, 9:34 AMthat said, doing an item search is generally how i would get inventory quantity related information
a
Ahmed
01/27/2020, 9:35 AMok understood so i should run a saved search and then get details instead of directly getting value after loading a record that i am doing right now
b
battk
01/27/2020, 9:37 AMeither way works, if you will be getting information for many items, do a search, if you are getting information for 1 item, do whatever you like best
battk
01/27/2020, 9:38 AMfor me, that generally means search since its easier to do it 1 way rather than 1 for each case
battk
01/27/2020, 9:39 AMif i was modifying the item record, i may consider doing the record load
👍 1
a
Ahmed
01/27/2020, 9:40 AMUnderstood .. Thanks for help