We are using ARM and commonly have sales orders with quantity = 4 and quarterly billing schedules (4 invoices billed an even amount every quarter - Jan 1, April 1, July 1, October 1).
Every so often, we have a scenario where one of the invoices is incorrect (wrong memo, a duplicate was mistakenly created, etc) so we create a credit memo w/ qty = 1 and apply it to the invoice. However, this creates an issue for us where revenue is under-recognized by 1 unit.
- Since this process results in 5 invoices being created, all 5 invoices are put into Deferred Revenue.
- The original SO created has quantity = 4 and (fulfilled quantity = 5) invoices and creates a Revenue Arrangement worth 4.
- Our item is set to "Create Revenue Plans On" = Revenue Arrangement Creation and has a Rule with "Amount Source" = Event-percent based on Amount.
- The credit memo creates an additional revenue arrangement with quantity = -1.
- Thus, we have Revenue Arrangements with quantity = 4 and quantity = -1 netting to 3 while we're supposed to be recognizing quantity = 4.
To correct this, the current process we are using is updating the sales order with quantity = 5. However, I think there must be a better way to do this.
Could someone advise on the best practice for this? The end state we'd like to get to is recognizing the 4 units of revenue evenly every month.