Hello,
I would like your advice for establishing a parent-child relationship between vendors in NetSuite. My objective is to consolidate bills from subsidiary vendors under a single parent vendor for payment processing.
For instance, let's say we have a parent vendor named ABC, with two subsidiary vendors: Child A and Child B. Imagine Child A generates an invoice for $500 and Child B for $1000. I need to consolidate these, resulting in a single $1500 invoice payable to the parent vendor, ABC.
Could you please provide insights or steps on how to configure this relationship in NetSuite? This would involve grouping bills from the child vendors so that payments are directed appropriately to the parent vendor.
Basically, My idea is to :
- creating a “parent” custom field list on the vendor record
- Developing a SuiteScript or workflow. This script or workflow should aggregate the bills from the child vendors and reassign the vendor associated with these transactions to the parent vendor.
Thank you for your insight!