Hi everyone,
I’m currently working with a customer in NetSuite who has two different payment terms, depending on the payment method:
- 10 days net for direct debit
- 10 days net for bank transfer
I understand that the "Terms" field under the Financial subtab of the customer record only supports one term at a time. However, for our business process, it's important to differentiate the payment terms based on the selected payment method.
Has anyone found a best practice or workaround to support multiple terms per customer depending on how they pay?
I'm considering the following options:
- Creating two separate customer records (e.g., Customer A – Direct Debit / Customer B – Bank Transfer)
- Using custom fields and workflows to drive logic at the transaction level
- Overriding terms manually on invoices, but this may not scale well
Ideally, I’d like to maintain consolidated reporting (e.g., AR Aging) if using multiple customer records.
Any advice, tips, or success stories would be really appreciated!
Thanks in advance!