In this article

Import Meter Readings

You can import the meter reading data using the standard Microsoft Dynamics 365 for Finance and Operations import feature. For information on importing data, see the Microsoft Dynamics 365 for Finance and Operations documentation.

Import File Format

This imported data adds or updates data for the Mass Meter Reading Entry page.

The import file must have the following data: 

Column Name Data Type Required Description
LEASENUMBER String Required Lease number.
LEVEL1NUMBER String No Level 1 number name to which the meter is attached, if applicable.
LEVEL2NUMBER String No Level 2 number name to which the meter is attached, if applicable.
LEVEL3NUMBER String No Level 3 number name to which the meter is attached, if applicable.
CHARGENUMBER String Required Charge number of the meter charge.
METERNUMBER String Required Number of the meter attached to the charge.
LINENUMBER Integer No Line number.
READINGDATE Date No

Used to determine which row in the BSSIPRMMETERREADING table to insert by comparing with the start and end dates.

Note icon. Note: If multiple dates in the import document refer to the same date range, the system uses only the most recent one.

CONSUMPTION Real No

When the reading type is Consumption, this value is required for the line.

CURRENTREADING Real No

When the reading type is Reading, this value is required for the line.

METERREADINGTYPE Enum Required

Options: 

  • Consumption
  • Reading

This value must match the meter reading type of the meter.