When Line Level Unit is Defined for a Line
(V 02.00.01-00)
The Pricing and Billing for an Order will differ in different scenarios when Unit is defined for the line. The section below explains different scenarios"
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 Invrental Price as below:
Day Price = 40
Week Price = 60
Month Price = 100
Set the Unit as Day
DIW as 3 and DIM as 9
Pricing
Table 1.0
Day | Order Line Amount | Calculation |
1 | 40 | Day Price of 40 will be applied for Day 1 |
2 | 80 | 40*2 = 80 |
3 | 120 | 40*3 = 120 |
4 | 120 | Day 4 to 7 Price will remain as 120, as DIW is 3. |
5 | 120 | |
6 | 120 | |
7 | 120 | |
8 | 160 | Price on 1st Day of 2nd week : = Price of 1st week + Price for 1st Day in 2nd Week = 120+40 = 160 |
9 | 200 | Similarly for Price 2nd Day of 2nd Week : = 120+80 = 200 |
10 | 240 | Price for 3rd Day of 2nd Week is: = 120+120 = 240 |
11 | 240 | Price for the next 4 days of the 2nd week i.e., 11th day to 14th day will remain as 240, since DIW is only 3. |
12 | 240 | |
13 | 240 | |
14 | 240 | |
15 | 280 | Price on 1st Day of 3rd week = Price of 1st week + Price 2nd Week + Price of 1s day of 3rd week = 120 + 120 + 40 = 280 |
16 | 320 | Similarly for Price 2nd Day of 3rd Week = 240+80 = 320 |
17 | 360 | Price 3rd Day of 3rd Week = 240+120 = 360 |
18 | 360 | Day 18 to 28 the Price will remain as 360, since only 9 days in a month has to be charged as DIM = 9
|
19 | 360 | |
20 | 360 | |
21 | 360 | |
22 | 360 | |
23 | 360 | |
24 | 360 | |
25 | 360 | |
26 | 360 | |
27 | 360 | |
28 | 360 | |
29 | 400 | Price for 1 month + 1 Day = 360 + 40 = 400 |
From the 29th Day the Pricing will again go in a Loop and Loop back to Day 1.
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 1st JUNE:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 480
Table 2.0 Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2010 | 28-06-2010 | 360 |
INV#2 | 29-06-2010 | 01-06-2010 | 120 |
When Pricing Month By is set as Calendar Month and Billing Terms is Monthly:
Note: 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 1st JUNE:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 400
Table 2.1 Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2010 | 30-06-2010 | 360 |
INV#2 | 01-07-2010 | 01-07-2010 | 40 |
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 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 Interval Price as below:
Day Price = 40
Week Price = 60
Month Price = 100
Set the Unit as Week
DIW as 3 and DIM as 9
Pricing
Table 3.0
Day | Order Line Amount | Calculation |
1 | 20 | Price of Day 1 is: Weekly Price / DIW * Duration = 60/3*1=20 |
2 | 40 | Price of Day 2 is: Weekly Price / DIW * Duration = 60/3*2=40 |
3 | 60 | Price of Day3 is: Weekly Price / DIW * Duration = 60/3*3=60 |
4 | 60 | Price from Day 4 to Day 7 will remain as 60, since DIW should not exceed 3 |
5 | 60 | |
6 | 60 | |
7 | 60 | |
8 | 80 | Price of 1st Day of 2nd week is: 1st Week Price + [Weekly Price / DIW * Duration] = 60 + [60/3*1] =80 |
9 | 100 | Price of 2nd Day of 2nd week is: 1st Week Price + [Weekly Price / DIW * Duration] = 60 + [60/3*2] =100 |
10 | 120 | Price of 3rd Day of 2nd week is: 1st Week Price + [Weekly Price / DIW * Duration] = 60 + [60/3*3] =120 |
11 | 120 | Price from Day 11 to Day 14will remain as 120, as Price for 2 weeks cannot exceed 120 since DIW should not exceed 3 |
12 | 120 | |
13 | 120 | |
14 | 120 | |
15 | 140 | Price of 1st Day of 3rd week is: [Price of 1st week + Price 2nd week] + [Weekly Price / DIW * Duration] = [60 + 60] + [60/3*1] =140 |
16 | 160 | Price of 2nd Day of 2nd week is: [Price of 1st week + Price 2nd week] + [Weekly Price / DIW * Duration] = [60 +60] + [60/3*2] =160 |
17 | 180 | Price of 3rd Day of 2nd week is: [Price of 1st week + Price 2nd week] + [Weekly Price / DIW * Duration] =[ 60 + 60] + [60/3*3] =180 |
18 | 180 | Price from Day 18 to Day 28 will remain as 180, as DIM is only 9 and cannot exceed the same |
19 | 180 | |
20 | 180 | |
21 | 180 | |
22 | 180 | |
23 | 180 | |
24 | 180 | |
25 | 180 | |
26 | 180 | |
27 | 180 | |
28 | 180 | |
29 | 200 |
|
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 1st JUNE:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 240
Table 4.0 Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2010 | 28-06-2010 | 180 |
INV#2 | 29-06-2010 | 01-06-2010 | 60 |
When Pricing Month By is set as Calendar Month and Billing Terms is Monthly:
Note: 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 1st JUNE:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 200
Table 4.1 Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2010 | 30-06-2010 | 180 |
INV#2 | 01-07-2010 | 01-07-2010 | 20 |
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 3
In an Order, when Line Level Unit is set, 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 Interval Price as below:
Day Price = 40
Week Price = Blank
Month Price = 100
Set the Unit as Week
DIW as 3 and DIM as 9
Pricing
Table 5.0
Day | Order Line Amount | Calculation |
1 | 40 | Price for Day 1 is 40 |
2 | 80 | Price of Day 2 = Day Price * Duration = 40*2 =80 |
3 | 120 | Price of Day 3 = Day Price * Duration = 40*3 =120 |
4 | 120 | Price from Day 4 to Day 7 will remain 120, as DIW is only 3 and it cannot exceed 3 |
5 | 120 | |
6 | 120 | |
7 | 120 | |
8 | 160 | Price of 1st Day of 2nd week is: 1st Week Price + [Day Price * Duration] = 120 + [40*1] =160 |
9 | 200 | Price of 2nd Day of 2nd week is: 1st Week Price + [Day Price * Duration] = 120 + [40*2] =200 |
10 | 240 | Price of 3rd Day of 2nd week is: 1st Week Price + [Day Price * Duration] = 120 + [40*3] =240 |
11 | 240 | Price from Day 11 to Day 14 will remain 240, as DIW is only 3 and it cannot exceed 3 |
12 | 240 | |
13 | 240 | |
14 | 240 | |
15 | 280 | Price of 1st Day of 3rd week is: [Price of 1st week + Price 2nd week] + [Day Price * Duration] = [120 + 120] + [40*1] =280 |
16 | 320 | Price of 2nd Day of 3rd week is: [Price of 1st week + Price 2nd week] + [Day Price * Duration] = [120 + 120] + [40*2] =320 |
17 | 360 | Price of 3rd Day of 3rd week is: [Price of 1st week + Price 2nd week] + [Day Price * Duration] = [120 + 120] + [40*3] =360 |
18 | 360 | Price from Day 18 to Day 28 will remain as 360, since DIM is 9 and should not exceed 9 |
19 | 360 | |
20 | 360 | |
21 | 360 | |
22 | 360 | |
23 | 360 | |
24 | 360 | |
25 | 360 | |
26 | 360 | |
27 | 360 | |
28 | 360 |
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 1st JUNE:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 480
Table 6.0 Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2010 | 28-06-2010 | 360 |
INV#2 | 29-06-2010 | 01-06-2010 | 120 |
When Pricing Month By is set as Calendar Month and Billing Terms is Monthly:
Note: 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 1st JUNE:
Order Details will be as follows:
Order Duration = 31 Days and Amount = 400
Table 6.1 Invoice Details
Invoice # | From Date | To Date | Amount |
INV#1 | 01-06-2010 | 30-06-2010 | 360 |
INV#2 | 01-07-2010 | 01-07-2010 | 40 |
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
Click here to view the Details and Illustration when Unit is Blank
Click here for information on Auto Extending Duration on Posting Invoice