ANS-1682 · REVENUE RECOGNITION
How Do Negative Lines on Sales Orders Affect NetSuite ARM?
Ensure proper reclassification of negative lines in NetSuite Advanced Revenue Management by configuring the Unbilled Receivable Adjustment Journal Grouping preference.
Short answer
Using negative lines on sales orders with Advanced Revenue Management can cause reclassification failures for unbilled receivables, leading to deferred revenue discrepancies. To resolve this, update the 'Unbilled Receivable Adjustment Journal Grouping' accounting preference from 'Element' to 'Arrangement'. This ensures the reclassification process correctly calculates unbilled receivables at the arrangement level.
Scenario
Organizations sometimes utilize negative lines on Sales Orders to manage overall contract value, especially when the Sales Order represents the customer's contract balance. However, NetSuite documentation advises against using negative lines with Advanced Revenue Management due to potential complications. This practice can lead to issues with revenue reclassification processes.
Solution
When negative lines are included on Revenue Arrangements (typically created from Sales Orders and Invoices), the Revenue Recognition Journal Entry Process will correctly generate the reversal of the revenue journal entry. However, the Reclassification process for these negative lines will fail if there is an Unbilled Receivable impact. This failure occurs because the reclassification process ignores negative lines, leading to discrepancies in the deferred revenue balance.To address these reclassification failures and deferred revenue discrepancies, the 'Unbilled Receivable Adjustment Journal Grouping' accounting preference must be updated. The required change is to update this preference from 'Element' to 'Arrangement'. This configuration ensures that the reclassification process correctly calculates Unbilled Receivables at the Arrangement level, rather than the Element level, thereby preventing discrepancies.Important Considerations:Changing the 'Unbilled Receivable Adjustment Journal Grouping' preference from a smaller grouping (e.g., Element) to a larger grouping (e.g., Arrangement) is possible. However, it cannot be reverted from a larger grouping to a smaller one.This setting exclusively impacts the Unbilled Receivables process during Revenue Reclassification.
Expert NetSuite Support
Need help with this NetSuite issue?
Revenue Recognition consulting and configuration support
