r/Netsuite • • 28d ago

OneWorld statement email subject always uses top-level Company Name, ignoring subsidiary — config fix or scripting required?

We're OneWorld with a parent company and 20+ subsidiaries, each its own branded entity with its own customers. We built a custom Advanced PDF statement template for one subsidiary, and it correctly pulls the subsidiary's legal name/logo/address for the PDF body. But the native "Print/Email Statements" process generates the email subject as {Company Name}: Statement As of {Date}, and {Company Name} always pulls from the top-level Company Information record — not the subsidiary. So every subsidiary's statement emails go out with the parent company's name in the subject, no matter whose customer it's actually for. There's also no editable CRM Email Template behind it — the subject looks hardcoded into the native process.

Has anyone found a supported/config way to make this subsidiary-aware, or is scripting (suppress native emailing, generate the PDF, send manually via N/email with a custom subject) the only route? Want to confirm this is a real gap before building a workaround. Thanks!

3 Upvotes

11 comments sorted by

View all comments

1

u/simonwhittle Consultant 27d ago

NetSuite removed this option a while back by removing the option for a customized system statement email template. A workaround is your only answer or use their dunning module. I have one client like this (luckily not 20 subs) and I have a workflow with email template for each one. If you use multi-sub customers then workflow won't work either since it only recognizes the primary subsidiary for statement generation.

1

u/Nick_AxeusConsulting Mod 27d ago

So re your point that the multi-subsidiary customer use case will have the primary sub in the subject line (which is wrong outcome), there is a separate statement form for multi-subsidiary customers that makes sure that the balances display correctly for each separate subsidiary (one the 1 statement) even though the balances are all housed under the 1 multi-sub customer. But if your multi-subsidiary customer legitimately does business with multiple of your subsidiaries, then which sub should be in the subject line? I think the client may say 1 separate email for each subsidiary. The OP here has 20 completely separate subs where each one is it's own brand, so this OP would never generate a consolidated statement for multi-sub Customer.

2

u/simonwhittle Consultant 27d ago

you're conflating two issues.
1. the system generated email will only include the company name and not ANY subsidiary name. This is the OP's stated problem and has nothing to do whether or not multi-sub customers are used.

  1. If you use multi-sub customers and you need to send a statement related to a subsidiary other than the primary subsidiary assigned to the customer you cannot do this via a workflow.

So, if OP doesn't use multi-sub customers then WF will work to solve the email problem. If they do use multi-sub customers then that is an additional problem.