Knowledgebase: EC Enterprise
EC Enterprise: Bill Split Error - Error creating split bill for multi-meter accounts (Imported bills only!)
Posted by - NA -, Last modified by Joel Brickell on 10 July 2015 01:36 PM

The issue is when you don't have a billaccountmeter record for each meter on the account being split you get a split error.

Example:

Account 1

Electric (Split 100%)

Water (Split 100%)

Sewer (Split 100%)

 

If the water and sewer bill information comes quarterly and the electric is monthly you will have bills without meter data for sewer and water. If you manually enter the bills this is fine as the default 0 will create bodyline and BAM records.

If you import your data you will get no bodyline data and no billaccountmeter data and will receive an error like below:

Target Account 000000981000000602-E-SW-W Target Meter W-000000981000000602 No source bill items to add to destination bill -- check source bill and SplitBill setup.

We have created a work-around for this until it is resolved. The linked script goes through the bill split error log and creates value only bodylines for all of the meters not on the bill.

SQL Script Fix

 

Once the script has successfully ran you bills should look similar to the example below:

 

 

 

 

(170 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: