Dear Team,
We are doing AMC and will post the invoice yearly / Quartrly /Monthly.
In that case the revenue and cost posting to the posting date months.
can anyone help me to post the revenue and cost distribution based on the AMC period with out add-on.
Scenario:
Example for Revenue Dis:
Base Value Tax Total AMC Period Invoice Vale 1000 50 1050 From Date 1/15/2020 To Date 1/15/2021 Total No of Days 366 Per day Rev Invoice Base value/Total No of Days 2.7322404 no of Months 13 Monthly Sno Month Start Date End Date Days Value 1 Jan-20 1/15/2020 1/31/2020 17 46.44808743 2 Feb-20 2/2/2020 2/29/2020 28 76.50273224 3 Mar-20 3/1/2020 3/31/2020 31 84.69945355 4 Apr-20 4/1/2020 4/30/2020 30 81.96721311 5 May-20 5/1/2020 5/31/2020 31 84.69945355 6 Jun-20 6/1/2020 6/30/2020 30 81.96721311 7 Jul-20 7/1/2020 7/31/2020 31 84.69945355 8 Aug-20 8/1/2020 8/31/2020 31 84.69945355 9 Sep-20 9/1/2020 9/30/2020 30 81.96721311 10 Oct-20 10/1/2020 10/31/2020 31 84.69945355 11 Nov-20 11/1/2020 11/30/2020 30 81.96721311 12 Dec-20 12/1/2020 12/31/2020 31 84.69945355 13 Jan-21 1/1/2021 1/15/2021 15 40.98360656Thanks
Naga