Venus (BCX - Business Connection) BG510 Meter Reading File Download (.TXT), for the following BG505 Meter Reading File (.TXT) Upload
and
Venus (BCX - Business Connection) BG512 Meter Reading File Download (.TXT).

This question pertains to the second kind of Venus Bill export, and doesn't need you to upload a readings/meter file. As a consequence, the pnpscada database has to be set up in a specific way for it to work, since the export needs a lot of extra data.

Typically, this export file can give partial data, in the sense that partially read meters, or even meters that has not been read in the billing period at all, can have export lines. The special reported codes, of which there can be one or many (up to 5) per line item, usually pertains to the status of a line item, whether the reading was done fully or partially or not at all, and possible reasons surrounding that, e.g. vacant.

When doing Run Bill, there is a checkbox to set in order to allow bills for incompletely read in meters to be run:

What is also necessary, is to tick the checkbox on the Run Bill screen to

you should do this typically for many past bills, since an error could have carried over for many months. Select all the applicable months in the multiple line selection list provided when you check this box.

The Lot Number (Edit->Meter Account, click 'show extra account numbers', the one on the left below the 'hide extra account numbers' link) should be the 25 digit Venus code. (It can be 27 digits, if 25 digits, we'd add two zeroes in front).

This should typically be unique over all Meter Accounts. There might be more for the case of Check Meters, but then as long as 'Check Meter' is in the name of the Meter Account, and the standnumber requirement is met, they are ignored. The standnumber must be a MOL number, and MOL numbers of more than 5 character length is ignored.

The REGION must also be specified for every Meter Account, and be at least 3 characters long.
Tariff name should be preceded by 4 characters describing the tariff and a space, e.g. E105

Tariff name 4 characters should be an uppercase alphabetic followed by 3 digits (or X if the digits are in the tariff line item name)
There must be at least 1 enabled meter per Meter Account.

For a Time of Use (TOU) account, the Tariff name should have X-es in the tariff name, because the actual exported line would replace the X according to how the tariff line item name was specified.

So the tariff line item must start with as many characters as there are X-es in the Tariff name (typically 2), where those two letters would replace the X-es. Those two letters must be the same for High Season and Low Season for the same rate period, but they must be different for different rate periods, e.g. peak/standard/off-peak.

The codes like 751 and 756 are not called error codes, but remark codes.

750 means ok

751 is if it is ok and it contains a correction (see above, running a bill that checks for corrections)

749 means the data is not read at all

748 is if there is an outstanding (not CLEARED) fault in the faultlog against that meter with a FINDING containing the words 'Credit Control' and/or '748'

760 is if there is an outstanding (not CLEARED) fault in the faultlog against that meter with a FINDING containing the words 'Vacant' and/or '760'

747 is if there is an outstanding (not CLEARED) fault in the faultlog against that meter with another FINDING.

755 means it is an incomplete reading
756 means it is an estimation reading. When it is an estimate, 'estimate' would also be in the bill line item description. Estimation is typically set up on the tariff definition, e.g. for Maximum Demand (MD). For instance, you can set it up that if the meter did not call in, the customer gets billed MD for the average of the last 3 months that it DID read in.

There can be up to 5 simultaneous remarks on one line in the BG512 file. The unused fields are filled with zeroes (000)