Hi Guys, have you ever tried transforming purchase...
# suitescriptt
Tyn Guardian
12/13/2023, 12:06 PMHi Guys, have you ever tried transforming purchase order to vendor bill? I have this code
Copy code
const vendorBill = record.transform({
fromType: record.Type.PURCHASE_ORDER,
fromId: parseInt(purchaseOrderId),
toType: record.Type.VENDOR_BILL,
isDynamic: true,
defaultValues: {
'trandate': '2023-12-31',
'entity': parseInt(customerId),
'postingperiod': 323,
'subsidiary': parseInt(subsidiary),
'duedate': dateToday,
'currency': currency,
'exchangerate': exchangerate,
'location': location
}
});Tyn Guardian
12/13/2023, 12:06 PMfull error message.js
n
NElliott
12/13/2023, 12:25 PMYou cannot default all those values.
Go to NS help and look at N/record and the part lower down on the main page "N/record Default Values"
👀 1
NElliott
12/13/2023, 12:26 PMapp/help/helpcenter.nl?fid=section_4267255811.html#bridgehead_4423371543
t
Tyn Guardian
12/13/2023, 12:29 PMThanks, I can see it now. Based on my understanding, if I want to transform PO to VendorBill default value I need is only entity right?
Tyn Guardian
12/13/2023, 12:44 PMAfter updating the code into this
Copy code
const vendorBill = record.transform({
fromType: record.Type.PURCHASE_ORDER,
fromId: 21953, // parseInt(purchaseOrderId),
toType: record.Type.VENDOR_BILL,
isDynamic: true,
defaultValues: {
'entity': parseInt(customerId),
}
});
const vendorBillId = vendorBill.save({
enableSourcing: true,
ignoreMandatoryFields: true
});n
NElliott
12/13/2023, 2:14 PMYou probably have to do other things on the transaction before saving it such as select lines to include
s
Stuart Anderton
12/13/2023, 7:54 PMHas that PO got any unbilled lines?
t
Tyn Guardian
12/13/2023, 10:20 PMYes correct @Stuart Anderton
Tyn Guardian
12/13/2023, 10:21 PMso I added something like this before the save
Copy code
vendorBill.selectNewLine({sublistId:"item"});
vendorBill.setCurrentLineItemValue({
sublistId:"item",
fieldId: "item",
value: 260,
ignoreFieldChange: true
});
vendorBill.commitLineItem({sublistId: "item"});Tyn Guardian
12/13/2023, 10:21 PMStill no luck 😐
m
michoel
12/13/2023, 11:15 PMTry transforming a PO to bill in the UI, check the URL parameters and use those as the default values
t
Tyn Guardian
12/13/2023, 11:18 PMThanks @michoel, but I am not familiar on how to transform PO to vendor bill. Can you share more on how to do this. keanu thanks
m
michoel
12/13/2023, 11:28 PMIf you open the PO in the UI there should be a button labeled Bill
t
Tyn Guardian
12/13/2023, 11:34 PMah I see.. Ok Ill try to check the URL parameter then
Tyn Guardian
12/14/2023, 1:15 AMthis is what I get on the URL PARAMS
https://xxx.app.netsuite.com/app/accounting/transactions/vendbill.nl?*transform=purchord&whence=&id=21957&e=T&memdoc=0*
and I transpose it to script like this
Copy code
const vendorBill = record.transform({
fromType: record.Type.PURCHASE_ORDER,
fromId: parseInt(21957),
toType: record.Type.VENDOR_BILL,
isDynamic: true,
defaultValues: {
'memdoc': parseInt(0)
}
});
var vendorBillId = vendorBill.save();Tyn Guardian
12/14/2023, 1:40 AMWait I got it!
Tyn Guardian
12/14/2023, 1:54 AM Copy code
const vendorBill = record.transform({
fromType: record.Type.PURCHASE_ORDER,
fromId: parseInt(purchaseOrderId),
toType: record.Type.VENDOR_BILL,
isDynamic: true,
memdoc: 0,
});
var vendorBillId = vendorBill.save();a
Abhyuday Luthra
01/05/2024, 8:02 PMHi @Tyn Guardian, I'm trying to do a similar thing and saw your thread. Does record.transform let you partially bill the purchase order? Or does it bill all of the items in the purchase order?
s
Stuart Anderton
01/05/2024, 11:09 PMIt creates a bill with all billable items, but you can go through and remove any you don’t want before saving.
👍 1
t
Tyn Guardian
01/07/2024, 10:16 PMHi @Abhyuday Luthra Yes agree on what Stuart says. You can add and remove items you dont want to save before saving 🙂
thankyou 1
80 Views