Contract Billing (Bill Contracts) (CNDE011A) (CNDE011B) (CNDE011C) (CNDE011D) (CNDE011E) (CNDE011F) (CNDE011G)

Program Description

This program can be found on the Contracts Data Entry menu (CN-1-11). Contracts are billed through this program. The only exception to this is when contracts are billed through the Commitment Entry program (CN-1-13), which is part of the Contract Commitments system. Users have the ability to bill a specific contract or a range of contracts based on the due dates and contract type. This includes base billing, meter billing, or both. This procedure updates the customer’s accounts receivable balance (ARECD data file), sales tax files, sales analysis (which updates the sales history and the general ledger), accrual file, and the contract.

 

 

Rev 15 Changes

Contract Setup screen sample below:

 

 

Contract Changes screen sample below:

 

Rev 14 Changes

 

Rev 13 Changes

 

Several changes were made to this program, which are described below:

 

 

Rev 12 Documentation

 

Contracts are billed through the program Bill Contracts, found on the Contract Data Entry menu, 1-11,  The only exception to this is when contracts are billed through the Commitment Entry program which is a part of the Contract Commitments program.

 

Internal changes were made in Revision 12 to incorporate the Item and Serial File size changes.  The new sales history index, Shhist5.ix, is updated in Contract Billing.

 

When a contract invoice is created an invoice is written to the bill to customer’s Accounts Receivable account.  The file that is updated is the Arecd File.  This file can be viewed in Account Detail Inquiry and the A/R Aging reports.  Within the Arecd File, is the storage of a reference field.  Prior to Revision 12 all contract invoices had the type of contract and contract number written into the reference field.  The possible references are Maint # or Lease # or Rental #.  On invoices generated through Billing and Order Entry, the reference field is the purchase order number that is entered in the Invoice or Order header.  A change has been made in Revision 12 so that if there is a purchase order number stored in the Contract header, this number will write into the reference field in the Arecd File, instead of the contract type and number.  If the purchase order field is blank in the Contract header, the contract type and number writes in to the reference field.  The purchase order number, stored in the Contract header, can be viewed and changed in Contract Changes, field 23.  This change is also applicable when billing contracts through the Commitment module.

 

Following is an example of the results of this change.  The Account Detail Inquiry is shown.

 

                     Customer A/R Inquiry  9/13/96 Dated  9/13/96 By            

Cust.No.  7857777 SEA RAY BOAT              LA CROSSE         AR Bal.     1716.16

  Inv.No     Tac * Tdate   Amount     Paid  Balance   C/M.No    Ref       Lstpmt

   89945  1C INV   81695   800.00            800.00          MAINT.#2635      

   93323  1G INV   91396   916.16            916.16          PO2705           

                                                                              

                                                                              

Display  O'ptions  E'nd

 

Invoice 89945 is a contract invoice that had no purchase order number in the Contract header, thus the contract type and number displays in the Ref reference column.  Invoice 93323 is a contract invoice that does have a purchase order number in the Contract header.  Thus the purchase order number PO2705 displays in the Ref reference column.  Note, this change has no affect on the printing of the invoice.  If there is a purchase order number, that prints on the invoice.  When the purchase order field is blank nothing is printed in the purchase order field on the invoice.


Bill Contracts  (Cont’d)

 

 

For those of you that have purchased and activated the Contract History module, when a contract is billed a Contract History record is created.  This also occurs for those of you using the Contract Commitment module.  With Revision 12 the current contract meter reading and reading date is now written into the Contract History Billing record.  Thus any contracts billed after Revision 12 will have this additional information stored in the Billing Contract History record.  At this time the information can only be accessed through Application Manager.  This will provide you with the current meter reading at the time of the billing of the contract.

 

Deferred income and the Income Recognition Report is a part of the Contract module.  This is activated by assigning accrual General Ledger account numbers to the item and serial numbers on the contracts.  With accrual accounts entered, upon the billing of the base rate, the start and expiration date on the contract is automatically updated to the next billing period.  This occurs when billing the contract’s base.  This only occurs on maintenance contracts and with a billing period of 3 or greater.  If the accrual accounts are not assigned no updating of the start and expiration date occurs.  Contracts with a base billing period of 1 do not have the start and expiration date updated, even if the accrual accounts are assigned.  Also rental and lease contract are not updated.

 

A new global option has been added.  The option is found in the Contract Global File, record 8, field 18, Update Start and Expiration Dates When Base Bills (Y/N)?  A Y for yes updates the start and expiration date on all contracts, even if the G/L accrual accounts are not assigned to the contracts.  This includes all types of contracts, maintenance, lease and rentals.  This includes all base billing periods, including a billing period of 1.  If the base billing period on a contract is less than 12, the start and expiration dates are updated for a year.  As an example, the old start and expiration date is 09/01/96 to 08/31/97 and the billing period is 1.  The new start and expiration date is 09/01/97 to 08/31/98.  A base billing period greater or equal to 12 updates to the actual billing period. 

 

For those of you that do not enter General Ledger accounts into your contracts setting the Global option to an N for no and billing the base on the contracts will not update the start and expiration dates.  Thus if you do not use the Income Recognition Report and you do not want the start and expiration dates updated automatically when the contract is billed set this global option at an N for no.


Bill Contracts  (Cont’d)

 

 

For those of you who are currently using accrual G/L accounts setting the Global option to an N for no, makes the program perform like it always has, as described on the previous page.  The start and expiration dates are updated.  Monthlies are not updated or rentals or lease contracts.

 

For those of you who are currently using the accrual G/L accounts setting the Global option to a Y for yes, updates the contracts that have accrual accounts entered the same as always.  In addition the rentals, lease and contracts, with a billing period less than 3, also have the start and expiration date updated.

 

Be aware that when the start and expiration date is updated, the new dates are only updated one cycle of the billing period.  Thus if you have not been manually updating the start and expiration dates upon renewal, they will update but not up to the current time period.  As an example, if the current start and expiration date of a contract is 09/01/94 to 08/31/95 and the base due date is 09/01/97 and the billing period is 12 and the contract is billed, the dates are updated.  However, the new start and expiration dates are 09/01/95 to 08/31/96.  They are not updated to 09/01/97 to 08/31/98.

 

Also with a monthly billing period the start and expiration dates are not changed until the contract’s base due date that is billed is after or equal to the month and date assigned to the expiration date.  As an example, a contract with a start and expiration date of 03/15/97 to 03/14/98 and billed for the base due date of 09/15/97 does not have the start and expiration date changed until the March of 1998 base billing is billed.

 

 

 

 

Contracts

Home