Row {x}: The Meter ‘{XXXXXXXX}’ is either not found…

If you receive an error that reads “Row {X}: The Meter ‘{XXXXXXXX}’ is either not found for the specified supplier’s contract ({Supplier Name Here}) or the contract is marked as ‘Do not include in forecasting’. Please check the input data for this row.” There are two possible causes:

Possible Cause 1: There are two identical active meters present.

How to fix this:

  1. Copy the meter number from the error message.
  2. Navigate to ‘Leads’
  3. Paste the meter number into ‘Advanced Search’ and click ‘Search Leads’ A.If there is a result in the (default) ‘Active’ tab there is an active meter for a lead B.If there is no result – there is no active meter under a lead
  4. Navigate to ‘Customers’
  5. Paste the meter number into the ‘Advanced Search’ field and click ‘Search Customers’ A.If there is a result in the (default) ‘Active’ tab there is an active meter for a customer B.If there is no result – there is no active meter under a customer.

    Possible Cause 2: There is one active and one inactive meter present but the system is unable to decipher which meter to assign this import to.
  6. If we are importing for an inactive meter, in the column ‘Include Inactive Items’ we can leave blank or put ‘YES’ (a blank cell will be interpreted as ‘YES’). This tells the system to import against the inactive meter of that number. If we are importing for an active meter AND there are duplicate inactive meters already in the system then ‘Include Inactive Items’ needs to be set as ‘NO’ (we do not want to import against any inactive meters, only the active meter).


    Possible Cause 3: The Supplier name is wrong
  7. When importing we need to make sure that the Supplier entered within the import is the same as the supplier stored within the system. We can do this by visiting ‘Pipeline’ and entering the meter number into the ‘Other’ field and clicking ‘Search Pipeline’. If we click the ‘All’ tab to see all contracts we can now make sure that the supplier matches the contract that we’re importing for.

    Possible Cause 4: The contract is marked as ‘Do not Include in Forecasting’.
  8. We need to check if the contract should be included. We can do this by visiting ‘Pipeline’ entering the meter number into the ‘Other’ field and clicking ‘Search Pipeline’. On the results page click “Go” on the contract you’re importing for, and “Edit Commissions”. A popup will appear. Locate the checkbox labelled ‘Include in Forecasting’. If unchecked then this meter/contract can’t be imported.