Hi all! Is there any way to update a Vendor record...
# suitescript
k
Hi all! Is there any way to update a Vendor record's primary subsidiary by editing either the Vendor Subsidiary Relationship record or the Vendor record via SuiteScript?
k
Right, I know that field is read only. I was referring to the Is Primary sublist field on Vendor records and the Primary (Y/N) field on Vendor Subsidiary Relationship records.
Are those read only as well?
p
I’m not near a computer at the moment, but would you expect them to do different things? I don’t think I would
k
I had assumed the Primary Subsidiary field on Vendor records was merely sourced from the Vendor Subsidiary Relationship record
is the only solution then to delete the vendor and re-create it with the correct subsidiary?
Found the answer
It becomes read only after the first transaction is created.
So, what do you do if you have transactions on a Vendor and it was created with the wrong sub?
I could really use a best practice solution for this one to pitch it to the higher ups.
Ok here is the best I've come up with is: Create a new vendor with the correct subsidiary. Move all transactions from that vendor to the new one. Inactivate the incorrect one.
👍 1
w
Maybe it would work to create a new vendor on the correct subsidiary and then Merge the old one into the new one?