Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

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.

MessageExplanationWhat to do
No items were found in the selected invoicesNo 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 0The 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 0The proposed price in legacy sales pricing is zero.Enter a positive price before retrying.
… have been updatedThis 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

SymptomExplanationWhat to do
No previous purchase foundThe 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 decreaseThe 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 unchangedOnly 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 processingA 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 disabledChanging 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 appearsHistory 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.