Day/Week/Month Pricing
Reference No: 27356
Enabling the Day/Week/Month Pricing Functionality
To enable this functionality execute the following commands in the R2 database:
update configuration set CHARGEBASED_DAYWEEKMONTHPRICE='1';
commit;
Caution: If the Day/Week/Month Pricing feature is enabled in R2 then, the support for Day/Week/Month Pricing for Orders created before enabling this feature is not currently provided. Please contact R2 Support team for any further queries on the same.
Details of Day/Week/Month Pricing Functionality
Once the Day/Week/Month Pricing functionality is enabled in R2, the pricing and billing of Items will be calculated based the Unit set for the Order line level and the settings defined in Configuration module > Pricing/Billing tab > Pricing by Month option set as 28 Days or Calendar, and Days in Week and Days in Month defined.
Pricing and Billing when Line Level Unit is Blank (not defined)
In an Order, when line level Unit is blank and Item price is defined, the functionality will be as below:
System will ignore the DIW and DIM definitions present for the Item.
DIW will be 7 days starting from the Order Start Date the next 7 days will be considered as a week.
For example, if the Order is created on June 7, 2014; then one week will be from the Start Date will be June 13, 2014.
System will not consider the Fractional charge durations.
The scenario below explains how Order line amount is calculated for each day.
Scenario 1:
Define Pricing for Item [ITEM#1] as below:
Day Price = 10.00
Week Price = 40.00
Month Price = 100.00
Add the Item [ITEM#1] to the Order [ORDER#1].
Set the Unit as blank.
Pricing
Day | Order Line Amount | Calculation |
1 | 10.00 | Day Price of 10.00 is applied on day 1. |
2 | 20.00 | 10.00 x 2 = 20.00 |
3 | 30.00 | 10.00 x 3 = 30.00 |
4 | 40.00 | 10.00 x 4 = 40.00 |
5 | 40.00 | Day 5 to 7 the Price will remain as 40, since Weekly Price should not exceed 40.00 |
6 | 40.00 | |
7 | 40.00 | |
8 | 50.00 | 40.00 + 10.00 = 50.00 (Price for 1st week + Price for 1st day in 2nd week) |
9 | 60.00 | 40.00 + 20.00 = 60.00 (Price for 1st week + Price for 2nd day in 2nd week) |
10 | 70.00 | 40.00 + 30.00 = 70.00 (Price for 1st week + Price for 3rd day in 2nd week) |
11 | 80.00 | 40.00 + 40.00 = 80.00 (Price for 1st week + Price for 4th day in 2nd week) |
12 | 80.00 | Day 12 to 14 the Price will remain as 80, since Price for 2 weeks should not exceed 80. That is, (Week price x Number of weeks), = 40.00 x 2 = 80.00 |
13 | 80.00 | |
14 | 80.00 | |
15 | 90.00 | 40.00 + 40.00 + 10.00 = 90.00 (Price for 1st week + Price for 2nd week + Price for 1st day of 3rd week). |
16 | 100.00 | 80.00 + 20.00 = 100.00 (Price for 1st week + Price for 2nd week + Price for 2nd day of 3rd week). |
17 | 100.00 | Day 17 to 28 the Price will remain as 100.00, since the Monthly Price should not exceed 100.00. |
18 | 100.00 | |
19 | 100.00 | |
20 | 100.00 | |
21 | 100.00 | |
22 | 100.00 | |
23 | 100.00 | |
24 | 100.00 | |
25 | 100.00 | |
26 | 100.00 | |
27 | 100.00 | |
28 | 100.00 | |
29 | 100.00 | 100.00 + 10.00 = 110.00 (Price for 1 month + Price for 1 Day). From the 29th Day the Pricing will be calculated same as from the start of the month. |
Additional Points:
If we define the Unit price as 10.00, DIW = 4 and DIM =10.00:
The amount will be same but Invoice Date will be 1 to 10 continuously. For the 1st month and the 2nd month invoice will not be generated.
In Weekly billing cycle, it will generate for 4 weeks + remaining days it will ignore DIM because of that the amount will be more.
Billing
Billing for an Order will be different when Pricing Month By is set to 28 Days or Calendar Month; the section below explains the different cases:
When Pricing Month By is 28 Days and Billing Terms is Monthly:
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 130.00
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 28-06-2014 | 100.00 |
INV#2 | 29-06-2014 | 01-06-2014 | 30.00 [10.00+ 20.00] |
For an Order having duration of 1month starting from June 15, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 130.00
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 15-06-2014 | 12-07-2014 | 100.00 |
INV#2 | 13-07-2014 | 15-07-2014 | 30.00 [10.00+ 20.00] |
For an Order having duration of 2 months starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 61 Days and Amount = 240.00
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 28-06-2014 | 100.00 |
INV#2 | 29-06-2014 | 26-07-2014 | 100.00 |
INV#3 | 27-07-2014 | 31-07-2014 | 40.00 |
When Pricing Month By is set to Calendar Month and Billing Terms is Monthly:
When Pricing Month By is set to Calendar Month, then system will always consider the Monthly Price for Pricing and Billing.
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 110
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 30-06-2014 | 100.00 |
INV#2 | 01-07-2014 | 01-07-2014 | 10.00 |
For an Order having duration of 1month starting from June 15, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 110
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 15-06-2014 | 14-07-2014 | 100.00 |
INV#2 | 15-07-2014 | 15-07-2014 | 10.00 |
For an Order having duration of 2months starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 61 Days and Amount = 200
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 30-06-2014 | 100.00 |
INV#2 | 01-07-2014 | 31-07-2014 | 100.00 |
When Billing Terms is changed, system will retain the Invoices which are already generated with the old billing terms and the changed Billing Terms will be applied for the other days for which Invoice is not generated.
Pricing and Billing when Line Level Unit is Defined
In an Order, when Line Level Unit and Item price is defined, the functionality will be as below:
System will always consider the DIW and DIM definitions for calculation of Price.
If DIW and / or DIM is blank then system will consider the default values.
Default Values are:
DIW = 7
DIM = 28
The Price of the Unit defined for the line will always be considered.
If Price is blank for a particular Unit then the Price for that Unit will be calculated based on DIW and DIM definitions.
If Unit is Week and Week Price is blank then system will arrive at the Weekly Price using the formula:
Day Price x DIW = Weekly Price |
If Unit is Month and Month Price is blank, then the system will arrive at the Monthly Price using the formula:
Day Price x DIM = Monthly Price |
When only Monthly Price is defined and Unit is either Day or Week, then Day Price and Month Price is arrived using the formula given below:
Month Price / DIM = Day Price |
Day Price * DIW = Week Price |
Here system will first arrive at the Day Price and then arrive at the Week Price.
When a particular line in the Order should not be charged then the following should be followed:
Day Price, Week Price and Month Price should be 0.00.
Or
Day Price should be 0.00, Week Price and Month Price should be blank when Unit is either Week or Month.
Scenario 1:
In an Order, when Line Level Unit is set Day and Item price is defined, the functionality will be as below:
System will consider the DIW and DIM which is applicable for the line.
The illustration below explains how Order line amount is calculated for each Day.
Illustration 1:
Define Pricing for Item [ITEM#1] as below:
Day Price = 40.00
Week Price = 60.00
Month Price = 100.00
Add the Item [ITEM#1] to the Order [ORDER#1].
Set the Unit as Day.
4. Set DIW as 3 and DIM as 9.
Pricing
Day | Order Line Amount | Calculation |
1 | 40.00 | Day Price of 40.00 will be applied for day 1. |
2 | 80.00 | 40.00 x 2 = 80.00. |
3 | 120.00 | 40.00 x 3 = 120.00. |
4 | 120.00 | Day 4 to day 7, Price will remain as 120.00, as DIW is 3. |
5 | 120.00 | |
6 | 120.00 | |
7 | 120.00 | |
8 | 160.00 | 120.00 + 40.00 = 160.00 (Price for 1st week + Price for 1st day in 2nd week). |
9 | 200.00 | 120.00 + 80.00 = 200.00 (Price for 1st week + Price for 2nd day in 2nd week) |
10 | 240.00 | 120.00 + 120.00 = 240.00 (Price for 1st week + Price for 1st day in 3rd week). |
11 | 240.00 | Price for the next 4 days of the 2nd week, that is, 11th day to 14th day will remain as 240.00, since DIW is only 3. |
12 | 240.00 | |
13 | 240.00 | |
14 | 240.00 | |
15 | 280.00 | 120.00 + 120.00 + 40.00 = 280.00 (Price for 1st week + Price for 2nd week + Price for 1st day of 3rd week). |
16 | 320.00 | 240.00 + 80.00 = 320.00 (Price for 1st week + Price for 2nd week + Price for 2nd day of 3rd week). |
17 | 360.00 | 240.00 + 120.00 = 360.00 (Price for 1st week + Price for 2nd week + Price for 1st day of 4th week). |
18 | 360.00 | Day 18 to 28 the Price will remain as 360.00, since only 9 days in a month has to be charged as DIM = 9. |
19 | 360.00 | |
20 | 360.00 | |
21 | 360.00 | |
22 | 360.00 | |
23 | 360.00 | |
24 | 360.00 | |
25 | 360.00 | |
26 | 360.00 | |
27 | 360.00 | |
28 | 360.00 | |
29 | 400.00 | 360.00 + 40.00 = 400.00 (Price for 1st month + Price for 1st Day in 2nd month). From the 29th Day the Pricing will be calculated same as from the start of the month. |
Billing
Billing for an Order will be different when Pricing Month By is set to 28 Days or Calendar Month, the section below explains the different cases:
When Pricing Month By is 28 Days and Billing Terms is Monthly:
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 480.00
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 28-06-2014 | 360.00 |
INV#2 | 29-06-2014 | 01-06-2014 | 120.00 |
When Pricing Month By is set to Calendar Month and Billing Terms is Monthly:
When Pricing Month By is set to Calendar Month, then system will always consider the Monthly Price for Pricing and Billing.
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 140
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 30-06-2014 | 100.00 |
INV#2 | 01-07-2014 | 01-07-2014 | 40.00 |
Note: When Billing Terms is changed, system will retain the Invoices which are already generated with the old billing terms and the changed Billing Terms will be applied for the other days for which Invoice is not generated.
Scenario 2:
In an Order, when Line Level Unit is set as Week and Item price is defined, the functionality will be as below:
System will consider the DIW and DIM which is applicable for the line.
Order line price will be considered based on Weekly Price.
The illustration below explains how Order line amount is calculated for each Day.
Illustration 2:
Define Pricing for Item [ITEM#1] as below:
Day Price = 40.00
Week Price = 60.00
Month Price = 100.00
Add the Item [ITEM#1] to the Order [ORDER#1].
Set the Unit as Week, DIW as 3 and DIM as 9.
Pricing
Day | Order Line Amount | Calculation |
1 | 20.00 | Price of Day 1 is: 60.00/3 x 1 = 20.00 (Weekly Price / DIW x Duration). |
2 | 40.00 | Price of Day 2 is: 60.00 / 3 x 2 = 40.00 (Weekly Price / DIW x Duration). |
3 | 60.00 | Price of Day3 is: 60.00 / 3 x 3 = 60.00 (Weekly Price / DIW x Duration). |
4 | 60.00 | Price from day 4 to day 7 will remain as 60.00, since Weekly Price cannot exceed 60.00. |
5 | 60.00 | |
6 | 60.00 | |
7 | 60.00 | |
8 | 80.00 | Price of 1st Day of 2nd week is: 60.00 + [60.00 / 3 x 1] = 80.00 (1st Week Price + [Weekly Price / DIW x Duration]). |
9 | 100.00 | Price of 2nd Day of 2nd week is: 60.00 + [60.00 / 3 x 2] = 100.00 [1st Week Price + (Weekly Price / DIW x Duration)]. |
10 | 120.00 | Price of 3rd Day of 2nd week is: 60.00 + (60.00 / 3 x 3] = 120.00 [1st Week Price + (Weekly Price / DIW x Duration)]. |
11 | 120.00 | Price from day 11 to day 14 will remain as 120.00, as the Price for 2 weeks cannot exceed 120.00 since the Weekly Price is only 60.00. |
12 | 120.00 | |
13 | 120.00 | |
14 | 120.00 | |
15 | 140.00 | Price of 1st Day of 3rd week is: (60.00 + 60.00) + (60.00 / 3 X 1] = 140.00 [(Price of 1st week + Price 2nd week) + (Weekly Price / DIW x Duration)]. |
16 | 160.00 | Price of 2nd Day of 2nd week is: [(60.00 +60.00) + (60.00 / 3 x 2)] =160.00 [(Price of 1st week + Price 2nd week) + (Weekly Price / DIW x Duration)]. |
17 | 180.00 | Price of 3rd Day of 2nd week is: [(60.00 + 60.00) + (60.00 / 3 x 3)] = 180.00 [(Price of 1st week + Price 2nd week) + (Weekly Price / DIW x Duration)]. |
18 | 180.00 | Price from day 18 to day 28 will remain as 180.00, as DIM is only 9 and cannot exceed the same. |
19 | 180.00 | |
20 | 180.00 | |
21 | 180.00 | |
22 | 180.00 | |
23 | 180.00 | |
24 | 180.00 | |
25 | 180.00 | |
26 | 180.00 | |
27 | 180.00 | |
28 | 180.00 |
Billing
Billing for an Order will be different when Pricing Month By is set to 28 Days or Calendar Month, the section below explains the different cases:
When Pricing Month By is 28 Days and Billing Terms is Monthly:
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 240
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 28-06-2014 | 180.00 |
INV#2 | 29-06-2014 | 01-06-2014 | 60.00 |
When Pricing Month By is set to Calendar Month and Billing Terms is Monthly:
When Pricing Month By is set to Calendar Month, then system will always consider the Monthly Price for Pricing and Billing.
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 120
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 30-06-2014 | 100.00 |
INV#2 | 01-07-2014 | 01-07-2014 | 20.00 |
When Billing Terms is changed, system will retain the Invoices which are already generated with the old billing terms and the changed Billing Terms will be applied for the other days for which Invoice is not generated.
Scenario 3:
In an Order, when Line Level Unit is set as Week, Week Price is blank but Day and Month Price is defined then the functionality will be as below:
Day Price will be considered for calculation of Weekly Price.
System will consider the DIW and DIM which is applicable for the line.
The illustration below explains how Order line amount is calculated for each Day.
Illustration 3:
Define Pricing for Item [ITEM#1] as below:
Day Price = 40.00
Week Price = blank
Month Price = 100.00
Add the Item [ITEM#1] to the Order [ORDER#1].
Set the Unit as Week, DIW as 3 and DIM as 9.
Pricing
Day | Order Line Amount | Calculation |
1 | 40.00 | Price for Day 1 is 40.00. |
2 | 80.00 | Price of Day 2 is: 40.00 X 2 = 80.00 (Day Price x Duration). |
3 | 120.00 | Price of Day 3 = 40 x 3 = 120.00 (Day Price x Duration). |
4 | 120.00 | Price from day 4 to day 7 will remain as 120.00, as DIW is only 3 and it cannot exceed 3. |
5 | 120.00 | |
6 | 120.00 | |
7 | 120.00 | |
8 | 160.00 | Price for 1st Day of 2nd week is: 120.00 + (40 x 1) = 160.00 [1st Week Price + (Day Price x Duration)]. |
9 | 200.00 | Price of 2nd Day of 2nd week is: 120.00 + (40 x 2) = 200.00 [1st Week Price + (Day Price x Duration)]. |
10 | 240.00 | Price of 3rd Day of 2nd week is: 120.00 + (40 x 3) = 240.00 [1st Week Price + (Day Price x Duration)]. |
11 | 240.00 | Price from day 11 to day 14 will remain 240.00, as DIW is only 3 and it cannot exceed 3. |
12 | 240.00 | |
13 | 240.00 | |
14 | 240.00 | |
15 | 280.00 | Price of 1st Day of 3rd week is: [(120.00 + 120.00) + (40.00 x 1)] = 280.00 [(Price of 1st week + Price 2nd week) + (Day Price x Duration)]. |
16 | 320.00 | Price of 2nd Day of 3rd week is: [(120.00 + 120.00) + (40 x 2)] = 320.00 [(Price of 1st week + Price 2nd week) + (Day Price x Duration)]. |
17 | 360.00 | Price of 3rd Day of 3rd week is: [(120.00 + 120.00) + (40.00 x 3)] = 360.00 [(Price of 1st week + Price 2nd week) + (Day Price x Duration)]. |
18 | 360.00 | Price from day 18 to day 28 will remain as 360.00, since DIM is 9 and should not exceed 9. |
19 | 360.00 | |
20 | 360.00 | |
21 | 360.00 | |
22 | 360.00 | |
23 | 360.00 | |
24 | 360.00 | |
25 | 360.00 | |
26 | 360.00 | |
27 | 360.00 | |
28 | 360.00 |
Billing
Billing for an Order will be different when Pricing Month By is set to 28 Days or Calendar Month, the section below explains the different cases:
When Pricing Month By is 28 Days and Billing Terms is Monthly:
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 480
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 28-06-2014 | 360.00 |
INV#2 | 29-06-2014 | 01-06-2014 | 120.00 |
When Pricing Month By is set to Calendar Month and Billing Terms is Monthly:
When Pricing Month By is set to Calendar Month, then system will always consider the Monthly Price for Pricing and Billing.
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 140
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 30-06-2014 | 100.00 |
INV#2 | 01-07-2014 | 01-07-2014 | 40.00 |
When Billing Terms is changed, system will retain the Invoices which are already generated with the old billing terms and the changed Billing Terms will be applied for the other days for which Invoice is not generated.
Scenario 4:
In an Order, when Line Level Unit is set as Day, Pricing is defined and DIW is blank then the functionality will be as below:
System will consider the DIM which is applicable for the line as DIW is blank
As Unit is Day, Day Price will be considered for calculations of the Price for the other days and only the first 9 days of the month will be considered.
The Illustration below explains how Order line amount is calculated for each Day.
Illustration 4:
Define Pricing for Item [ITEM#1] as below:
Day Price = 40.00
Week Price = 60.00
Month Price = 100.00
Add Item [ITEM#1] to Order [ORDER#1].
Set the Unit as Day, DIW as blank and DIM as 9.
Pricing
Day | Order Line Amount | Calculation |
1 | 40.00 | Price of Day 1 is: 40.00 x 1 = 40.00 (Day Price x Duration). |
2 | 80.00 | Price of Day 2 is 40.00 x 2 = 80.00 (Day Price x Duration). |
3 | 120.00 | Price of Day 3 is 40.00 x 3 = 120.00 (Day Price x Duration). |
4 | 160.00 | Price of Day 4 is 40.00 x 4 = 160.00 (Day Price x Duration). |
5 | 200.00 | Price of Day 5 is 40.00 x 5 = 200.00 (Day Price x Duration). |
6 | 240.00 | Price of Day 6 is 40.00 x 6 = 240.00 (Day Price x Duration). |
7 | 280.00 | Price of Day 7 is 40.00 x 7 = 280.00 (Day Price x Duration). |
8 | 320.00 | Price of Day 8 is 40.00 x 8 = 320.00 (Day Price x Duration). |
9 | 360.00 | Price of Day 9 is 40.00 x 9 = 360.00 (Day Price x Duration). |
10 | 360.00 | From day 9 onwards Price will remain as 360.00, as the DIM is 9 and 9 days is already charged. |
Billing
Billing for an Order will be different when Pricing Month By is set to 28 Days or Calendar Month, the section below explains the different cases:
When Pricing Month By is 28 Days and Billing Terms is Monthly:
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 480
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 28-06-2014 | 360.00 |
INV#2 | 29-06-2014 | 01-06-2014 | 120.00 |
When Pricing Month By is set to Calendar Month and Billing Terms is Monthly:
When Pricing Month By is set to Calendar Month, then system will always consider the Monthly Price for Pricing and Billing.
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 140
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 30-06-2014 | 100.00 |
INV#2 | 01-07-2014 | 01-07-2014 | 40.00 |
When Billing Terms is changed, system will retain the Invoices which are already generated with the old billing terms and the changed Billing Terms will be applied for the other days for which Invoice is not generated.
Scenario 5:
In an Order, when Line Level Unit is set as Day, Pricing is defined and DIW is defined but DIM is blank, then the functionality will be as below:
System will consider the DIW which is applicable for the line as DIM is blank and only 3 days in a Week will be charged.
As Unit is Day, Day Price will be considered for calculations of the Price for the other days.
As DIM is not defined, system will calculate Price for 3 days in a week for the entire Month.
The illustration below explains how Order line amount is calculated for each Day.
Illustration 5:
Define Pricing for Item [ITEM#1] as below:
Day Price = 40.00
Week Price = 60.00
Month Price = 100.00
Add the Item [ITEM#1] to the Order [ORDER#1].
Set the Unit as Day, DIW as 3 and DIM as blank.
Pricing
Day | Order Line Amount | Calculation |
1 | 40.00 | Price for Day 1 is 40.00. |
2 | 80.00 | Price of Day 2 = 40.00 x 2 = 80.00 (Day Price x Duration). |
3 | 120.00 | Price of Day 3 = 40 x 3 = 120.00 (Day Price x Duration). |
4 | 120.00 | Price from day 4 to day 7 will remain as 120.00, as DIW is only 3 and it cannot exceed 3. |
5 | 120.00 | |
6 | 120.00 | |
7 | 120.00 | |
8 | 160.00 | Price for 1st Day of 2nd week is: 120.00 + (40 x 1) = 160.00 [1st Week Price + (Day Price x Duration)]. |
9 | 200.00 | Price of 2nd Day of 2nd week is: 120.00 + (40 x 2) = 200.00 [1st Week Price + (Day Price x Duration)]. |
10 | 240.00 | Price of 3rd Day of 2nd week is: 120.00 + (40 x 3) = 240.00 [1st Week Price + (Day Price x Duration)]. |
11 | 240.00 | Price from day 11 to day 14 will remain 240.00, as DIW is only 3 and it cannot exceed 3. |
12 | 240.00 | |
13 | 240.00 | |
14 | 240.00 | |
15 | 280.00 | Price of 1st Day of 3rd week is: [(120.00 + 120.00) + (40.00 x 1)] = 280.00 [(Price of 1st week + Price 2nd week) + (Day Price x Duration)]. |
16 | 320.00 | Price of 2nd Day of 3rd week is: [(120.00 + 120.00) + (40 x 2)] = 320.00 [(Price of 1st week + Price 2nd week) + (Day Price x Duration)]. |
17 | 360.00 | Price of 3rd Day of 3rd week is: [(120.00 + 120.00) + (40.00 x 3)] = 360.00 [(Price of 1st week + Price 2nd week) + (Day Price x Duration)]. |
18 | 360.00 | Price from day 18 to day 21 will remain as 360.00, since DIW is only 3 and it cannot exceed 3. |
19 | 360.00 | |
20 | 360.00 | |
21 | 360.00 | |
22 | 400.00 | Price of 1st Day of 4th week is: [(120.00 + 120.00 + 120.00) + (40.00 x 1)] = 400.00 [(Price of 1st week + Price 2nd week + Price of 3rd week) + (Day Price x Duration)]. |
23 | 440.00 | Price of 2nd Day of 4th week is: [(120.00 + 120.00 + 120.00] + (40.00 x 2)] = 440.00 [(Price of 1st week + Price 2nd week + Price of 3rd Week) + (Day Price x Duration)]. |
24 | 480.00 | Price of 3rd Day of 4th week is: [(120.00 + 120.00 + 120.00) + (40.00 x 3)] = 480.00 [(Price of 1st week + Price 2nd week + Price of 3rd Week) + (Day Price x Duration)]. |
25 | 480.00 | Price from day 25 to day 28 will remain as 480.00, since DIW is only 3 and it cannot exceed 3. |
26 | 480.00 | |
27 | 480.00 | |
28 | 480.00 |
Billing
Billing for an Order will be different when Pricing Month By is set to 28 Days or Calendar Month, the section below explains the different cases:
When Pricing Month By is 28 Days and Billing Terms is Monthly:
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 600
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 28-06-2014 | 480.00 |
INV#2 | 29-06-2014 | 01-06-2014 | 120.00 |
When Pricing Month By is set to Calendar Month and Billing Terms is Monthly:
When Pricing Month By is set to Calendar Month, then system will always consider the Monthly Price for Pricing and Billing.
For an Order having duration of 1month starting from June 01, 2014:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 140
Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2014 | 30-06-2014 | 100.00 |
INV#2 | 01-07-2014 | 01-07-2014 | 40.00 |
When Billing Terms is changed, system will retain the Invoices which are already generated with the old billing terms and the changed Billing Terms will be applied for the other days for which Invoice is not generated.