CodePartners Bloghttp://www.codepartners.com/Blog.aspxAdvanced Pricing Options in Sage 300 ERPhttp://www.codepartners.com/Blog/TabId/110/PostId/149/advanced-pricing-options-in-sage-300-erp.aspxHow to use special pricing features in Sage 300 ERPGeneralThu, 08 Aug 2013 08:29:16 GMTby Hrayr Galoyan<br />
<br />
Sage 300 ERP has flexible functionality when it comes to defining item prices and discounts. One limitation is that you can only define volume discounts on a per-item basis. But, what if you want to define a volume discount for a group of related items? There is no way to do it in Sage 300 ERP.<br />
<br />
Some time back, one of our customers needed exactly that, so we developed a custom solution for them. It comes in two components: Special Price Configuration, and a custom Order Entry screen, which takes into account the special pricing. In the Special Price Configuration, you can define which customers it applies to, for what date range, and what items are in the group. Then, you define the special prices for the items, depending upon the quantity purchased. They can define the special price in terms of absolute amount, or a discount on one of the existing pricelists in Sage 300 ERP.<br />
<br />
The application is clever enough to compare the special price against the default price calculated by Sage 300 ERP. It only applies the special price if it is lower than the default price. Here are some screenshots of price definition.<br />
<p> </p>
<p><img alt="" src="/Portals/0/Images/blog%20images/july1.png" style="width: 650px; height: 510px; float: left;" /></p>
<p> </p>
<p><img alt="" src="/Portals/0/Images/blog%20images/july2.png" style="width: 650px; height: 510px;" /></p>How Customer Pricing Works in Sage 300 ERPhttp://www.codepartners.com/Blog/TabId/110/PostId/132/how-customer-pricing-works-in-sage-300-erp.aspxdemonstrating how pricing is determined for each order in Sage 300 ERPGeneralWed, 17 Jul 2013 10:13:21 GMTBy Hrayr Galoyan<br />
<br />
Several parameters affect what selling price Sage 300 ERP assigns by default in a new sales order. The price and extended price depend upon:<br />
<br />
1. The customer selected<br />
2. Customer’s currency<br />
3. The ship-to location selected<br />
4. Discounts defined in the pricelist<br />
5. Ordering unit of measure and pricing unit of measure<br />
6. Whether or not there is a contract pricing defined<br />
<br />
So what is the logic Sage 300 ERP uses to determine the price? Here are the steps.<br />
<br />
<strong>Determine the Pricelist Code<br />
<br />
</strong>First, Sage 300 ERP needs to decide which pricelist code to use in an order. If a ship-to location is specified in an order, then it uses the pricelist defined in the ship-to location.<br />
<img alt="" src="/Portals/0/Images/blog%20images/7-17image1.png" /><br />
<br />
If you do not specify a ship-to location, then it uses the pricelist defined for the customer.<br />
<img alt="" src="/Portals/0/Images/blog%20images/7-17image2.png" /> <br />
<br />
If you do not specify a customer pricelist either, then there is no default pricelist for the order, and each detail line uses whatever pricelist is assigned to the item in that detail line.<br />
<img alt="" src="/Portals/0/Images/blog%20images/7-17image3.png" /><br />
<br />
If you do not assign a pricelist to an item, then the respective field in order details is empty by default, and you must specify a pricelist code before the item can be added to the order.<br />
<br />
Of course, any of these pricelists are just the defaults and you can override them at any time on the order header and/or details, as long as the order hasn’t been shipped yet.<br />
<img alt="" src="/Portals/0/Images/blog%20images/7-17image4.png" /><br />
<img alt="" src="/Portals/0/Images/blog%20images/7-17image5.png" /><br />
<br />
<br />
<strong>Determining the Price<br />
<br />
</strong>Now that Sage 300 knows which pricelist to use, it needs to determine the price itself. The price may come from one of two places:<br />
<br />
1. Contract Pricing<br />
2. Item Pricing<br />
<br />
Contract Pricing takes precedence over Item Pricing and allows creating special pricing for certain customers, for example, if you agreed to give them additional discount.<br />
<br />
<strong>Contract Pricing<br />
<br />
</strong>Contract Pricing is flexible; it can be setup for one item at a time, or for a whole category of items. However, you always need to specify a customer, so you cannot define contract pricing for all, or a range of customers. Here is an example.<br />
<img alt="" src="/Portals/0/Images/blog%20images/7-17image6.png" /><br />
<br />
<br />
In this example, any item in category C1 that is sold to customer 1200 will receive 5% discount. Start and Expiration dates are empty, which means this contract is active indefinitely. Here is another example:<br />
<br />
<img alt="" src="/Portals/0/Images/blog%20images/7-17image7.png" /><br />
<br />
Whenever item A1-103/0 is sold to customer 1200 using pricelist USD, $70.00 is used as the price. However, it also has the “Use Lowest Price” option selected, which means if the price defined in the standard item pricing is lower than the price in special pricing, the lowest price will be used. This ensures that the client gets the best possible deal.<br />
<br />
<strong>Item Pricing<br />
<br />
</strong>Item pricing in Sage 300 is flexible. Here are some of the important features:<br />
<br />
1. A price can be setup for a single unit of measure, i.e., $10 each.<br />
2. A price can be setup for multiple units of measure, i.e. $10 each, but only $110 for a dozen.<br />
3. A price can be calculated based on a cost, i.e. average cost of the item, plus a certain percentage.<br />
4. Sale price and sale period can be defined separately from the base price.<br />
<br />
There are also multiple ways to define discounts:<br />
<br />
1. Discount can be based either on customer type or on volume.<br />
2. Discount can be defined as a percentage or amount.<br />
<br />
Sage 300 allows overriding the unit price in sales transactions, but you can optionally configure it to show a warning or error if the price does not meet the specified criteria, for example, if sales margin is insufficient.<br />
<br />
<strong>Other Considerations<br />
<br />
Multicurrency Pricelists<br />
<br />
</strong>In multi-currency ledgers, it is possible to define the same pricelist in multiple currencies.<br />
<br />
<img alt="" src="/Portals/0/Images/blog%20images/7-17image8.png" /><br />
<br />
Notice that pricelist CTPR01 exists in CAD as well as USD currencies. This allows you to define proper pricing for each market.<br />
<br />
<strong>Pricing and Ordering UoM<br />
<br />
</strong>Pricing and ordering Units of Measure can be different, for example, the price may be defined for a “Dozen”, while the order is in “Each” units. Sage 300 converts the various units of measure automatically and no additional effort is required from the user.<br />
<br />