Item Pricing:
Item price is the default price in item master. MS dynamics Ax stores 3 prices for each item:
- Base purchase price
- Base cost price
- Base sales price
The purchase or cost prices are your cost. They can be
manually entered or updated from the last purchase price or the last production
receipt of the inventory. The sales order price is the selling price if trade agreements
do not exist. A trade agreement can override from the price listed here.
Sales price can be manually entered or it can be
calculated as the margin percentage or markup percentage from cost. Since the item displayed two different costs,
the purchase order price and the item price, the user can decide which cost
should be used for markup.
Item Pricing option:
The setup tab of item master is where pricing option are determined.
If latest purchase price is checked, then the purchase order
price on price/discount tab will be updated with most recent purchase price
each time an invoice is posted against the purchase order.
If latest cost price is checked, then the cost price on
price/discount tab will be updated with most recent price when the production is
completed and item is received into inventory. The cost price is used in inventory
and production modules.
The sales price model contains 3 options:
- None: manually enter selling price on the price/discount tab.
- Contribution ratio: calculate price based on a desired margin.
- Misc. charges pct: calculate price based on a markup percent.
Price = (cost + cost x Misc.
charges pct.)
If the sales price model is set to Contribution ratio or
misc charges pct. Then the base price is use to determine whether the purchase
or cost price from the price/discount tab should be use. This would be the
basis of markup. The contribution ratio and misc charges pct. fields are used
with respective options selected for the sales price model.
Margin vs. Markup
What is the difference between Contribution ratio and Misc.
charges pct. ?
Example: Cost price $100
|
|
||||
|
Price = cost + (cost x Misc charges pct.)
Price = 100 + ( 100 x 0.20)
Price = 100 + 20
Price = $120
|
If contribution ration is selected as sales price model, then
the contribution ratio must be enter. If misc charges pct is selected as sales
price model, then the misc charges pct field must be enter.
The price will be
calculated from the source selected as the base price either purchase or cost
price. In this example we have selected cost price as base. Microsoft dynamics
ax will find cost price listed on price/discount tab.
The contribution ratio is margin and Misc charges pct is
markup. The percentage entered in fields is whole numbers. Divide the number by
100 to arrive at decimal number that is used in calculation shown here.
If the price is
calculated from cost, then the sales order price on price/discount tab will
automatically updated when the record is saved, the date of price will also be
updated.