Collectively change the cost price/transfer price

You can change the cost price and settlement price collectively. This can be done through the general calculation methods or alternatively, through Average Purchase Price (APP) and the Last Purchase Price (LPP). LPP can also be used for collectively changing the sales price.

If you are collectively changing the prices using the APP and the LPP, you can only specify a percentage change, not a change with an amount.

The GIP and LIP are calculated on the basis of the receipt of goods, and are not based on the purchase orders. These prices therefore reflect the actual purchase, instead of the purchase orders.

The calculations use the purchase prices from all goods receipt lines for the article in question starting on the date in the From date of receipt field and through the date in the Through date of receipt field (if you have entered them).

• If there are no goods receipt lines for the specified time period, then the FSP remains unchanged. If there are goods receipt lines with a price of 0.00 then these lines are not included in the calculation.
• In the case of receipt lines in foreign currencies, the price per unit in the basic currency is always used. When the goods receipt is entered, the price per unit in the foreign currency is immediately converted to the basic currency. This conversion is based on the exchange rate that is valid on the date of the goods receipt. Which exchange rate is used when the receipt is entered depends on the Use current rates setting. If this check box is selected, the current rate (currency properties, Current rates tab) valid on that date is used. If the check box for this setting has not been selected, then the 'normal' exchange rate is used (currency properties, General tab).

To change the cost price/settlement price collectively based on the Average Purchase Price (APP):

You can change the cost and settlement prices collectively based on the average purchase price (APP). The APP is calculated based on goods receipts and not on the basis of the purchase orders. Thus this price concerns the actual purchase and not the purchase orders.

The calculation of the new cost/settlement price based on the APP = average of the purchase prices from all goods receipts lines (possibly within a certain period of time, if you filled this in).

To change the costs/settlement prices collectively in accordance with the APP calculation method:

1. Go to: 
   • Order Management / Management / Edit prices collectively
   • Projects / Management / Edit prices collectively.
2. Click on the action: Cost price or Settlement price.
3. Click on: Next. 
4. For Calculation method, select the Based on GIP method.
5. If required, enter a Percentage by which you want to increase or decrease the prices. The highest percentage is 999.00% and the lowest percentage is -100.00%.
6. If required, use the From date of receipt andThrough date of receipt fields to select the period over which Profit should calculate the average purchase price of goods receipts. The dates that you select here are used for calculating the APP and not for selecting articles.
7. In Rounding, specify how you want to round the edited prices.
8. Click on: Next.
9. Filter the results so that only the prices in your filter are changed.
10. Check the calculation of the new prices for accuracy.
11. Click on: Finish. 

Change the cost price/settlement price collectively based on the Last Purchase Price (LPP):

To change the settlement price and the cost price collectively, you can choose the calculation method: Based on LIP.

The LPP is the purchase price from the most recent goods receipt line for the article.

The calculation of the new fixed settlement price = purchase price from the most recent goods receipt line for the article in question (to be determined based on the date + sequence number in these lines).

To change the costs/settlement prices collectively in accordance with the LPP calculation method:

1. Go to: 
   • Order Management / Management / Edit prices collectively
   • Projects / Management / Edit prices collectively
2. Click on the action: Cost price or Settlement price.
3. Click on: Next. 
4. For Calculation method, select the Based on LIP method.
5. Enter a Percentage by which you want to increase or decrease the prices. The highest percentage is 999.00% and the lowest percentage is -100.00%.
6. If applicable, change the Start date.
7. Click on: Next.
8. Filter the results so that only the prices in your filter are changed.
9. Check the calculation of the new prices for accuracy.
10. Click on: Finish.