Help
Use the table if a worksheet cannot be created or an update does not produce the expected result. Keep the worksheet open while investigating errors; unapplied changes are lost on closing.
Worksheet
Messages with variable values show … instead of numbers, counts or dates.
| Message | Explanation | What to do |
|---|---|---|
| No items were found in the selected invoices | No worksheet lines were created. Only positive-quantity item lines are included; invoices with a linked purchase credit memo are skipped. History can also exclude lines. | Check invoice filters, item quantities, credit memos and Create Lines. |
| Worksheet contains lines for items that have no Price List Lines. To continue, please select default Price List Header in Price Change Worksheet setup. | An item has no relevant active price list line and the default price list cannot be found. | Choose Default Price List Header in setup and create the worksheet again. |
| … on … … must be greater then 0 but is … | A comparison purchase or related item ledger entry has a non-positive quantity. | Select another purchase with positive quantity. Ask your administrator to inspect related entries if the invoice appears correct. |
| Dateformula must calculate to a previous date. (Current DateFormula calculated on today: … | The previous-purchase period does not calculate backwards. | Use a negative formula such as -1D. |
| A previous price change for one or more ledger entries was found. Do you want to create the price change line again? | A confirmation about a comparison already processed. | Answer yes only if you intend to review it again. No excludes the affected repeated lines. |
| … sales price lines will be updated. Do you want to continue? | Confirmation for Update all, not an error. | Check the count and filters. Answer no if the scope is wrong. |
| Cannot set Unit Price in the Price List Line table as 0 | The proposed price on a price list line is zero. | Enter a positive New Unit Price and review the line again. |
| Cannot set Unit Price in the Sales Price table as 0 | The proposed price in legacy sales pricing is zero. | Enter a positive price before retrying. |
| … have been updated | This counts processed lines, not necessarily every line in the worksheet. | Inspect remaining lines and Error Text before closing. |
| Are you sure you want to close the worksheet? All modifications will be lost. | A warning about temporary data. Already applied price changes are not undone. | Cancel closing if you need to continue the review. |
Symptoms without a message
| Symptom | Explanation | What to do |
|---|---|---|
| No previous purchase found | The automatic search is restricted by item, variant, period and possibly location. The default markup or profit is then used. The manual list only reaches twelve months back from today. | Check settings and dates. Use another reference if available and review the recalculated price. |
| An item appears under “Items with cost increase” despite a cost decrease | The filter includes every non-zero cost difference. | Read the sign of the cost difference and the proposal; the label alone does not indicate an increase. |
| Item-card price unchanged | Only a matching general price line updates the item card when enabled. | Check the price line, currency, unit, VAT group and Update Item Unit Price. |
| No new sales-price line after processing | A setting can skip writing sales-price lines. | Check Skip Creating Sales Price Line for items and verify what has already changed before repeating. |
| Price changes when rounding is disabled | Changing rounding recalculates the cost-based proposal and can overwrite a manual price. | Review or enter the price again after changing rounding. |
| No history or notification appears | History must be enabled. Email requires an enabled subscriber with an email address and working email setup. | Check settings, User Setup and the email account. Verify the sales price itself before repeating an update. |