Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Change sales prices after purchasing

Use the worksheet when you want to review how new purchases affect sales prices. You see proposals before deciding which lines to update.

Scenario

At Dæmi ehf., an item V-100 previously cost ISK 1,000 per unit and now costs ISK 1,100 for a purchase posted on 27 October 2026. The current sales price is ISK 1,500. With a 10% cost increase, no rounding and comparable units of measure, the proposal is ISK 1,650.

Before you start

Review the basic settings. Have a posted purchase invoice with positive item quantities ready. Check the previous and new costs: purchase price and cost amount are not necessarily the same amount.

Walkthrough

  1. Search for Create Price Change Worksheet. Filter by invoice number, vendor or posting date and run it. A vendor filter selects that vendor's invoices, not every item assigned to the vendor regardless of purchases.
  2. In Price Change Worksheet, check Last Cost Amount and New Cost Amount. If the comparison is unsuitable, change the previous purchase.
  3. Review New Unit Price. You can enter another price or change Markup % or Profit % to recalculate the proposal. If no previous purchase is found, the proposal uses the default markup or profit. Currency conversions for profit calculations use today's exchange rate; review foreign-currency prices carefully.
  4. Check prices with and without VAT, the customer or price group, currency, variant and unit of measure on each line. An item can appear on several lines. Red markup or profit values mean they are outside configured warning limits; that alone does not block an update.
  5. Review Starting Date and Ending Date. Do not assume the starting date will automatically become today. When a new start date is used, earlier matching price lines can be given an ending date one day before it.
  6. Choose one update action from the table below.
ActionWhat is updated
Update allAll lines within the current filter. A confirmation shows the number of lines.
Update selectedThe lines you selected. There is no separate confirmation.
Update Marked linesLines with Mark for Update selected within the current filter. There is no separate confirmation.

You can also start the worksheet from a posted purchase invoice, or for several selected invoices in the posted purchase invoice list.

Filters for the price change worksheet.

Price change worksheet for item WP23-V100; prices have not been updated.

Result

Updated lines disappear from the worksheet and a message shows their count. In the example, the new sales price is ISK 1,650. Verify it on the relevant price line, not only on the item card.

The item card's unit price changes only if the setting is enabled and the line is for all customers, matches the VAT business posting group, uses the base or blank unit of measure, and has local or blank currency. If sales-price line creation is skipped, item-card updates and history recording can still occur.

If Price Change History is enabled, choose Previous price changes for this item or All previous price changes. Notifications are sent to enabled subscribers when lines have been updated.

What can go wrong

If no items are found, a price stays unchanged or a line remains with Error Text, see Help. Check the outcome for each line; do not assume all lines succeeded.

Warning

The worksheet is temporary. Closing it loses unapplied changes. Prices you have already updated are not undone by closing it.