Defining Bill Date in Periodic Billing Orders
Reference: 22796
(V 02.00.04-00)
Details
In Order window, a new column Bill Date is added (as shown in Fig 1.0), using which the user can set the Date that has to be considered while generating invoice for the Misc. Charge Item(s) and Sell Item(s) which is added to a periodic billing order.
Figure 1.1

Functionality
The user can set the Bill Date only for the Misc. Charge lines and Sell Item lines which are added to a Periodic Billing Order.
If the Bill Date is not defined for a Misc. Charge line, then system will include the Misc. Charge item in the next invoice generated for the Order.
If the Bill Date is not defined for a Sell Item line, then system will include the Sell item in the next invoice generated for the Order.
If the Bill Date defined for a Misc. Charge Item and/or Sell Item is between the period which is posted and no further invoices will be generated for the order, then on generating new invoice for the Misc. Charge item and/or Sell Item, system will generate the invoice with the Bill Date defined.
If the Bill Date defined for a Misc. Charge Item and/or Sell Item does not fall between the period which is posted no further invoices will be generated for the order, then on generating new invoice for the Misc. Charge item and/or Sell Item, system will generate the with the last invoiced date + 1 day.
Illustration 1
Consider the item lines on the order as below, with the assumption that no further invoices will be generated for the order (for example ; due to off rent).
Item | Bill Date | Charge Duration | Status |
Item#1 |
| 1/11- 28/11 | Posted |
Misc#1 | 30/11 |
|
|
On generating a new invoice for the order, system will generate the invoice with Bill date of 29/11 for the Misc. Item even though the Bill Date is 30/11.
If the Bill Date defined for a Misc. Charge Item and/or Sell Item falls under the period for which invoices will be generated for the order, on generating the invoice, system will include the Misc. Charge item and Sell Item in the same invoice which is generated.
Illustration 2
Consider the item lines on the order as below, with the assumption that further invoices will be generated for the order.
Item | Bill Date | Charge Duration | Status |
Item#1 |
| 1/11- 28/11 | Open |
Misc#1 | 20/11 |
|
|
On regenerating the invoice for the period 1/11- 28/11, system will add the Misc. Item to the same invoice generated as the Bill date defined (20/11) is between duration for which invoice is generated.
If the Bill Date defined for Misc. Charge Item and/or Sell Item is not present under the period for which invoices will be generated, then on generating the invoice, system will include the Misc. Charge item and Sell Item in the same invoice which is generated.
Illustration 3
Consider the item lines on the order as below, with the assumption that further invoices will be generated for the order.
Item | Bill Date | Charge Duration | Status |
Item#1 |
| 1/11- 28/11 | Open |
Misc#1 | 30/11 |
|
|
On generating the invoice, system will add the Misc. Charge item to the same invoice even though the Bill Date (30/11)defined does not fall between the period for which invoice is generated.
If the Bill Date defined for Misc. Charge Item and/or Sell Item is between the posted invoice period and additional invoices will be generated for the order, then on generating the invoice for charge duration pending to be invoiced, system will create an additional invoice for the Misc. Charge item and Sell Item with the bill date defined.
Illustration 4
Consider the item lines on the order as below :
Item | Bill Date | Charge Duration | Status |
Item#1 |
| 1/11- 28/11 | Posted |
Item#1 |
| 29/11 &endash; 26/12 |
|
Misc#1 | 20/11 |
|
|
On generating invoice for the charge duration (29/11 &endash; 26/12), system will create an additional invoice with the date 20/11 for the Misc. Charge item
For an order having multiple Misc. Charge items and/or Sell Items with Bill date for some of the lines between posted charge duration and for some of the Misc. Charge item and/or Sell Item lines having Bill Date not between the charge duration, and no further invoices will be generated for the order, system will generate the invoices as mentioned below :
For the Misc. Charge Items and/or Sell Items having Bill date between the posted charge duration, separate invoice will be generated for each Misc. Item and Sell Item with the respective Bill date defined.
For the Misc. Charge Items and/or Sell Items for which Bill date is not between the posted charge duration, system generate an invoice with the date (last invoiced date + 1 day) and will add all the Misc. Items and/or Sell Items (having date not between the posted charge duration) to the generated invoice.
Illustration 5
Item | Bill Date | Charge Duration | Status |
Item#1 |
| 1/11- 28/11 | Posted |
Misc#1 | 20/11/10 |
|
|
Misc #2 | 23/11/10 |
|
|
Misc #3 | 25/11/10 |
|
|
Misc #4 | 05/12/10 |
|
|
Misc #5 | 06/12/10 |
|
|
Misc #6 | 07/12/10 |
|
|
On generating the invoice, system will create separate invoice for the Misc. Charge Items (Misc#1, Misc#2, Misc#3) with the bill date respective Bill date defined , as the Bill date defined does fall between the posted charge duration.
For the Misc. Charge Items (Misc#4, Misc#5, Misc#6), system will create a new invoice with last invoiced date + 1 day and will add the Misc. Items into the generated invoice, as the Bill date defined is not between the posted charge duration.
Illustration 6
For an order having multiple Misc. Charge items and/or Sell Items with Bill date for some of the lines between current charge duration and for some of the Misc. Charge item and/or Sell Item lines having Bill Date not between the current charge duration, and further invoices will be generated for the order, system will generate the invoices as mentioned below :
Item | Bill date | Charge Duration | Status |
Item#1 |
| 1/12/2010- 28/12/2010 | Open |
Misc#1 | 10/12/2010 |
|
|
Misc #2 | 20/01/2011 |
|
|
Misc #3 | 19/02/2011 |
|
|
On generating the invoice, system will add the Misc. Charge Item Misc#1 in the invoice generated for the order for the first invoiced duration (1/12/2010- 28/12/2010).
System will not add the Misc. Charge Items (Misc #2, Misc #3) to the first invoiced duration as the bill date defined with a future invoice date (after the charge duration) with the consideration that future invoices will be generated for the item charge duration.
On generating the second invoice, the Misc. Charge item Misc#2 will be added with the invoice date 29/12/2010.
On generating the third invoice, system will add the Misc. Charge Item Misc #3 to the third invoice generated the invoice date 26/01/2011.
Note: The illustrations given in the document is based on Misc. Charge Item behavior. The same is applicable for Sell Items also.