Skip to main content
Pending validationOdoo 20.0Community and Enterprise

The physical count or the asset labels do not go ahead

Symptom​

The Invalid Operation window opens when you start a physical inventory campaign, import the count sheet or print labels. Both screens, Physical inventory of assets and Asset labels, are in Accounting › Record › Partners and assets › What is there to do with the assets? › Supporting lists. Nothing changed: the campaign stays as it was and no count was entered.

Message​

Copied from the screen, with the Accountant profile. The parts in italics change from case to case.

  • When you click Start the campaign:

    “There are no assets in use at the chosen locations: choose other locations (or none for the whole company) before starting the campaign.”

  • When importing a sheet that is not the campaign's:

    “The sheet does not have the count sheet columns (found: Nome, Valor). The columns, in this order, are: Label, Asset, Expected location, Counted (Yes), Found location, Note; the 4th marks each asset found. Nothing was imported: use "Count sheet (XLSX)" or "Count sheet (CSV)" on the campaign to export the sheet, fill it in and import it again.”

  • When importing a sheet with no rows:

    “The sheet is empty: add the header row and at least one asset, then import it again.”

  • When you click Print labels (PDF):

    “There are no assets to label with these filters. Select assets, choose a location or widen the period, then print again.”

Verified causes​

  • No asset in use at those locations. The campaign only counts assets in use. A location with none gives no list to count.
  • The sheet was made by hand or its columns changed. The import only accepts the sheet exported from the campaign, with the columns in the same order.
  • The sheet has no rows.
  • The label filters do not find any assets. The location, acquisition period and state chosen do not match any asset.

The Count sheet (XLSX), Count sheet (CSV), Register Counts and Import counts buttons only appear with the campaign In progress. On a campaign in Draft, there is only Start the campaign: if you are looking for the sheet and cannot see it, start the campaign first.

What to check​

  1. In Fixed assets, whether there are assets in use at the chosen location.
  2. Whether the campaign is In progress.
  3. Whether the sheet you are importing was exported from this campaign and whether the first row has the column headings.

How to fix it​

Who does it: the Accountant.

  1. On the campaign, choose other locations in Locations or leave the field empty, to count the whole company. Click Start the campaign.
  2. For the sheet, click Count sheet (XLSX) or Count sheet (CSV), write Yes in the Counted (Yes) column for each asset found, without changing the columns, and click Import counts.
  3. For the labels, widen the period, remove the location or select the assets, and print again.

If an asset has already been read in the same campaign, the screen says “Already counted” and does not count it twice. This is not an error: move on to the next one, as in How to do the physical inventory of assets.

Expected result​

The campaign moves to In progress and Expected Count shows the number of assets to count. The imported sheet updates the Counts list. The labels download as a PDF.

When to contact support​

  • The sheet was exported from the campaign, without changing the columns, and the same sentence appears.
  • There are assets in use at the location and the campaign still refuses.

Information to send​

Follow How to ask support for help and what information to send, with the full sentence and the sheet you tried to import.