Accolent ERP allows orders (or quotes) that have been saved to be reviewed and prices revised for the whole order using the Calculate Order Profit function. Once an order’s total is revised, for example to meet a bid target, Accolent ERP gives two options for pushing the adjusted total back to the line items. The adjustment can be pushed to the line items based either (i) on applying a price factor to each line or (ii) by maintaining the revised order margin for each line.
Create Order
- Orders created in Accolent ERP take the pricing set up on the customer, but prices may be overwritten line by line by the user as desired.
- Order 39698 has a total extended price of $7,700.00 before sales tax of $693.00.
Configuration Setting
- Configuration ID 198 determines the default setting of the Price Factor or Order Margin on the Calculate Order Profit screen.
- Set Config ID 198 to N this will default the order line price to calculate based on Price Factor.
- This is just the default setting but can be changed on the Calculate Order Profit screen.
Calculate Order Profit
- Once an order is created the pricing of the whole order may be modified using the Calculate Order Profit screen to achieve a desired overall order price, discount, markup, profit, or profit margin.
- For example, on order 39698, the original order has extended price of $7,700.00, use the Calculate Order Profit screen to adjust the order profit to 22.00%.
- Adjusted order extended price is $7,499.80.
Calculate Order Profit Options
- The adjusted order extended price can be pushed back to the line items using either (i) the price factor or (ii) the order margin.
Price Factor
- With the Calculate Order Profit screen set to Price Factor, the total extended price of $7,499.80, will adjust the line items prices by a factor of 0.97400 (7499.80/7700.00).
- The revised line item prices are reduced to B54486S – $1,168.80 and BC50005 – $5162.20.
- The profit margins of each line are different, and the overall margin of the whole order is 22.00%.
Order Margin
- With the Calculate Order Profit screen set to Order Margin, the total extended price of $7,499.80, will adjust the line items prices so that each line has a 22.00% margin.
- The revised line item prices are reduced to B54486S – $1,127.92 and BC50005 – $5,063.97.
- The profit margins of each line are the same and match the overall margin of the whole order of 22.00% (to 2 decimals).
