Problem: Bill splits on the sub-meters duplicate after re-importing the same bill info.

Solution: When you re-import bills from a CSV file using the ACE flag of "A" means the imported bill will overwrite any existing bill in the database that shares the same ACCOUNT, VENDOR, START DATE, and END DATE.  When it overwrites, it will NOT delete the split bills that may have been associated with to that Master bill.  It leaves those alone and the newly created/import bills will NOT be associated with the split bills that were left alone.  The reson for that is because the BILLID for the new bill is different from the overwritten bill. 

If you need to find these duplicate bills, we suggest running either report BL09 which might find them or you could run audit 46 and audit 03.  These 2 audits might also pickup the fact that there are two (2) copies of the bills.

Created by Joel Brickell and Ryan Ohlson, 03/03/2010  EnergyCAP Enterprise,6.0 SP2 and later.