I am attempting to update a vendor bill in a close...
# suitescriptj
Jacob Jackson
10/20/2020, 7:42 PMI am attempting to update a vendor bill in a closed period, to update the billing address for our check run. I am trying to use a client script, I am used to using nlapiSetFieldValue, but I'm not sure that this is correct. Is anybody able to give me a little guidance on this? It's not something I usually handle
b
battk
10/20/2020, 7:44 PMbe very careful about trying this in client script
battk
10/20/2020, 7:45 PMaddresses are basically the only subrecord ive found that sometimes works
battk
10/20/2020, 7:46 PMUsing SuiteScript with Address Subrecords documents how to use subrecords
j
Jacob Jackson
10/20/2020, 7:50 PMwell, for some reason when manually editing the address, it won't update. It only occurs on transactions where the period is closed (even though this is a non-gl change, and the correct permission is granted)
Jacob Jackson
10/20/2020, 7:50 PMthe correct address is selected, and the record is saved, it says its successful, butt hen the record never updates, and nothing shows in system notes
b
battk
10/20/2020, 7:52 PMyou should probably check if its the actual fields on the address that are the problem
battk
10/20/2020, 7:53 PMor if its only the address text
j
Jacob Jackson
10/20/2020, 7:53 PMthe address on the vendor record updated properly
Jacob Jackson
10/20/2020, 7:53 PMbut when selecting the address on the vendor bill under the billing tab, it still displays old values, and will not update when toggled
Jacob Jackson
10/20/2020, 7:55 PMI was thinkinga bout using something similar to this.... var recobj = nlapiLoadRecod("vendorbill",3610248);
recobj.setFieldValue('billingaddress',23282);
nlapiSubmitRecord(recobj,true);
b
battk
10/20/2020, 7:56 PMtransactions are supposed to retain the values of the address at the time the transaction was made
battk
10/20/2020, 7:57 PMprimarily so that updating an address doesnt destroy your historical data
j
Jacob Jackson
10/20/2020, 7:59 PMyes, but I am going to the transaction record and toggling the address, to get it to update. and it does update, until I hit 'save', then it saves the record, but reverts back to the old address.
b
battk
10/20/2020, 8:00 PMyou may want to just use a custom address on a transaction
j
Jacob Jackson
10/20/2020, 8:01 PMstill does not work. reverts to previous address
b
battk
10/20/2020, 8:42 PMi believe the code you share is supposed to select the bill address select field, which is
billaddresslistbattk
10/20/2020, 8:43 PMthat said, if it doesnt work in the ui, its unlikely to work in script