- INTRODUCTION
This feature automatically creates a new sale price based upon a change on the buy price, pending on set up. You can discount or increment or decide how much margin you would like to make each stock code.
- REATING A DERIVED PRICE
Go to Stock>Ledger Maintenance>Derived Sale Prices
A screen like this appears:
- Add - Select add to create a new derived price
NOTE: Derived Pricing works by; Category (4), Product Group (3), Product Type (2) or an Individual Stock Code (1). Agility prioritises 1-4
- Now select ADD – This screen appears:
- Choose how the derived price will be based on
- Enter the price difference by % e.g. (10%) (This multiplies the buy price)
- Decide if incrementing or discounting or by Margin
- Once decided selected SAVE
This screen appears::
- The “Buy Price” is 3.87
- Current Sale Price is 4.5935
- Derived price is going to make it 4.26 – a reduction based on 10%
- Apply from CURRENT DATE
- Now select Process
- Exit will not apply the change
Select Yes the price change has not been applied but the derived price created so based on example this may need to be edited so that the sale price is not reduced
This screen appears:
- The new derived price is added to the grid
- When you are finished select Exit
- Edit - This allows you to edit the set up of the derived price
- First Select the stock you want to edit
- Then Select EDIT
This screen appears:
- Remove
- Select the stock code you wish to remove
- Select Remove
- A message box will ask to confirm the removal
- If you say NO you are returned to the main screen
- If you say YES the stock code is removed
- Changing The Buy Price
Go to: Stock>Ledger Maintenance>Stock Item Maintenance>Stock Items
Stock Items Screen opens:
- Enter your stock code
- Select the Buy Price Tab
- Select Add
- Select The Supplier
- Select The Currency
- KEEP THE CURRENT DATE
- When you have finished select OK
This screen appears:
- This screen shows the changes will be applied on the 02/09/2021
- The prices in red indicate (Orig Net & Orig Gross) what your prices are until the Apply Changes From Date
- Derived Price shows how much it is going to be from the Apply Changes From Date
- When finished Select Save
- The Stock screen now shows the two buy prices
- The previous Sale price is overwritten instantly with new sale price
If the buy price is changed in a PO this will also fire the derive price change.
When ticked, the Derive All Prices By Same Margin setting, in Tools-Tools Menu-Companies-System Parameters- Additional System Parameters, under the Stock tab - will handle all case types for derived pricing. For example, if you have a s tock code with multiple case types, having this setting enabled will update the margin on all of them, instead of just the sale case