Automatically Incrementing Bill Batch Numbers and Other Bill Entry Fields

The setup process below enables automatic incrementing of batch numbers for bill entry purposes. A similar approach can be used for Batch Values in the Batch Setup window (Bill/Open Batch), such as StatementDate and DueDate. The advantage to auto-incrementing is that Data Entry operators do not have to manually select and input this information during bill entry. A restriction of the auto-incrementing option using the procedure below is that the batch number cannot contain any alpha characters--it must be comprised solely of numbers.

Batch Number Auto-Incrementing Setup

1. From the Tools menu, select the Work Flow Wizard… option.
2. Click on the Next button to start the Work Flow Wizard.
3. On the second page of the Wizard, click in the box to select to Enter bills in batches. We also recommend that you select the Confirm Edit/Delete of bills in closed batches option.
4. Click on the Next button twice to get to the Work Flow Wizard – Header window.
5. Click in the box to Enable bill headers.
6. One of the Bill Header choices in the list is for Batch Number. Select Use Field to have the Batch Number appear on the Bill Entry screen. You may also want to select Require so that the Batch Number must be present on the Bill Entry screen in order for the bill to be saved.
7. In the Generate Default column, enter the following:
    =lastbatchnumber + 1 
   This equation will instruct EnergyCAP to generate the Batch Number by auto-incrementing the latest Batch Number in the system by one.
8. Select any of the remaining Bill Headers if it is necessary for them to appear on the Bill Entry screen.
9. Click the Next button until any additional the Work Flow Wizard changes have been made.
10. Click the Finish button to save the changes.
11. Have all users exit the EnergyCAP software and then log back into EnergyCAP in order for the Work Flow changes to take effect.
12. Operation the Software with Auto-Incrementing Enabled
13. The first time that someone enters a bill into EnergyCAP, they will need to create a new Batch. When  the first Batch is created, EnergyCAP will generate an error, indicating that the software is not able to automatically generate the Batch Number, because no Batch Numbers exist.
14. Click the OK button to proceed with creating the Batch.
15. Enter a Batch Number in the field provided. This can be a predetermined number, such as 1 or 1000, or it can be your favorite number. ! Remember: The Batch number must not contain alpha characters.! 
16. Click the OK button to finish creating the Batch. Once the initial Batch has been created with a Batch Number, subsequent Batches will have their Batch Number calculated, based on the Generate Default equation entered into the Work Flow Wizard.
17. Enter any bills that need to be entered into the Batch, then Close the Batch.
18. Create a new Batch. The Batch number will be populated with the value calculated using the Generate Default equation established in the Work Flow Wizard.
19. Enter any Batch Values, or enter a Note. Then, click on the OK button to finish creating the Batch.
20. Close the Batch when all of the bills have been entered.

NOTES: If you need to change the sequential Batch Numbering in the future, you may enter a new Batch Number when Creating a Batch, rather than using the default value shown. This new Batch Number must be greater than the default value shown to avoid any Batch Number conflicts within EnergyCAP, as each Batch Number must be unique. For example, if the default Batch Number value shown is 123, and it is necessary to change the sequential Batch Number, simply replace the 123 value with a larger number. Note that EnergyCAP will not create any Batches with Batch Numbers between 123 and the new number.

The Auto-Increment capability of the Workflow Wizard has not yet been fully documented. Users familiar with script language may derive additional ideas from the examples below:

EXAMPLE 1:

=(cstr(year(date())&"-"&month(date())&"-"&day(date())&"_"&CSTR(AutoInc+1)))

Output: YEAR-MONTH-DAY_AUTOINCREMENTNUMBER 

EXAMPLE 2: (Batch Setup Window)

StatementDate Batch Value: =date - 4

DueDate Batch Value: =date + 14