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 Length Required Description
LEASENUMBER String   Required Lease number.
LEVEL1NUMBER String     Level 1 number name to which the meter is attached, if applicable.
LEVEL2NUMBER String     Level 2 number name to which the meter is attached, if applicable.
LEVEL3NUMBER String     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      
READINGDATE Date    

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    

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

CURRENTREADING Real    

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.