MUHAMMAD MUBUSHER ASLAM
05/24/2021, 2:42 PMtry {
var currentRecord = context.currentRecord;
var purchaseOrderId = currentRecord.getSublistValue({ sublistId: 'expense', fieldId: 'orderdoc', line: 0 });
if (purchaseOrderId) {
var lineCount = currentRecord.getLineCount({ sublistId: 'expense' });
var TR_RECORD = record.transform({
fromType: record.Type.PURCHASE_ORDER,
fromId: purchaseOrderId,
toType: record.Type.ITEM_RECEIPT
});
for (var i = 0; i < lineCount; i++) {
//how do i replace and delete lines which is not exist in currentRecord?
var orderDoc = currentRecord.getSublistValue({ sublistId: 'expense', fieldId: 'orderdoc', line: i });
var orderLine = currentRecord.getSublistValue({ sublistId: 'expense', fieldId: 'orderline', line: i });
var account = currentRecord.getSublistValue({ sublistId: 'expense', fieldId: 'account', line: i });
var amount = currentRecord.getSublistValue({ sublistId: 'expense', fieldId: 'amount', line: i });
TR_RECORD.setSublistValue({
sublistId: 'expense',
fieldId: 'category',
line: lineCount[i],
value: expanseAccount
});
}
var idl = TR_RECORD.save({
enableSourceing: true
});
}
}
catch (err) {
dialog.alert({
title: 'Vendor Bill',
message: err.message
});
}
Sandii
05/24/2021, 2:49 PMN/currentRecord
Sandii
05/24/2021, 2:51 PMline: lineCount[i],
, lineCount is just a numberSandii
05/24/2021, 2:52 PMexpanseAccount
also does not exist here, so its possible it is the problemMUHAMMAD MUBUSHER ASLAM
05/24/2021, 4:31 PMSandii
05/24/2021, 4:35 PMN/record
has removeLine
and setSublistValue
should work, assuming you've fixed/addressed any potential problemsbattk
05/24/2021, 6:04 PMbattk
05/24/2021, 6:05 PMTyn Guardian
05/24/2021, 10:40 PMMUHAMMAD MUBUSHER ASLAM
05/25/2021, 12:27 AMMUHAMMAD MUBUSHER ASLAM
05/25/2021, 12:28 AMbattk
05/25/2021, 1:29 AMbattk
05/25/2021, 1:30 AM