Straight line revenue for a multi year contract with different discounts for each year
Summary:
We have a scenario where we have one item charged differing discounts over the period of the contract.
Year Qty Rate Amount List Price Discount
Yr1 7 9075 63525 10000 925
Yr2 7 9175 64225 10000 825
Yr3 7 9275 64925 10000 725
Total Contract Value 192675
When we create this as three lines in the FBDI, the system is creating three promise details (1 for each year) with one performance obligation. It is recognizing the revenue for each promise detail as per the below table. We want this to be
Year Days YR1 YR2 YR3
1 24 4176.929 4222.956 4268.983
2 30.455 5300.349 5358.755 5417.161
3 30.455 5300.349 5358.755 5417.161
4 30.455 5300.349 5358.755 5417.161
5 30.455 5300.349 5358.755 5417.161
6 30.455 5300.349 5358.755 5417.161
7 30.455 5300.349 5358.755 5417.161
8 30.455 5300.349 5358.755 5417.161
9 30.455 5300.349 5358.755 5417.161
10 30.455 5300.349 5358.755 5417.161
11 30.455 5300.349 5358.755 5417.161
12 30.455 5300.349 5358.755 5417.161
13 6 1044.232 1055.739 1067.246
Total 365.005 63525 64225 64925
The business is expecting the revenue will be carved out from year 3 and applied to year 1 there by evening out the revenue recognition per period. The system is not carving out the revenue from year 3 and applying it to year 1. Can you please let me know how this can be handled?