Hello,
We are using Advanced Revenue Management (ARM) and would like advice on whether the following scenario is supported, and if so, how to handle it with standard functionality.
[Current setup]
- The first invoice is created from a sales order.
- Subsequent invoices (e.g., for each billing period) are created using "Make Copy" from that invoice. They are not standalone invoices.
- As a result, all copied invoices remain linked to the original sales order. Every invoice line is tied to the original sales order line, even though each invoice covers a different service period.
- On the item record, "Create Revenue Plans On" is set to "Billing", so we expect a revenue recognition plan to be created when each invoice is saved.
- Each invoice line has its own revenue recognition start/end dates representing the period covered by that invoice.
[Issue]
- Because the invoices are linked to the sales order, the revenue element (and the revenue recognition plan) appears to take its revenue recognition start/end dates from the sales order line, not from each invoice line.
- In some cases, no new revenue element or plan seems to be created for the copied invoices.
- As a result, revenue is not recognized according to the period of each invoice.
[What we want to achieve]
- Recognize revenue per invoice, using the revenue recognition start/end dates on each invoice line, while the invoices remain linked to the sales order.
[Questions]
1. Is this scenario intended or supported in NetSuite ARM: multiple invoices created by copying an invoice that is linked to a sales order, with all invoice lines tied to the same sales order line? Or is this considered outside the expected usage?
2. If it is supported, is there a standard way (preference, revenue recognition field mapping, revenue arrangement setting, etc.) to have the revenue element/plan use the dates from each invoice line instead of the sales order line?
3. If this is not the expected usage, what is the recommended approach? For example: creating standalone invoices, creating separate sales order lines per billing period, or using a different item or revenue rule setup.
4. For invoices that have already been created this way, is there a standard way to correct the revenue elements/plans other than journal entries?
5. With "Create Revenue Plans On = Billing", are there any limitations or side effects we should be aware of in this scenario, such as duplicate recognition or plans not being created for copied invoices?
Any guidance, related documentation, or similar experience would be greatly appreciated.
Thank you.