CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


How Customer Pricing Works in Sage 300 ERP

SHARE THIS
Facebook twitter linkedin Print Print
Print Email

By Hrayr Galoyan

Several parameters affect what selling price Sage 300 ERP assigns by default in a new sales order. The price and extended price depend upon:

1.    The customer selected
2.    Customer’s currency
3.    The ship-to location selected
4.    Discounts defined in the pricelist
5.    Ordering unit of measure and pricing unit of measure
6.    Whether or not there is a contract pricing defined

So what is the logic Sage 300 ERP uses to determine the price? Here are the steps.

Determine the Pricelist Code

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.
 

If you do not specify a ship-to location, then it uses the pricelist defined for the customer.
 

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.
 

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.

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.

 
 

Determining the Price

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:

1.    Contract Pricing
2.    Item Pricing

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.

Contract Pricing

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.

 

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:

 

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.

Item Pricing

Item pricing in Sage 300 is flexible. Here are some of the important features:

1.    A price can be setup for a single unit of measure, i.e., $10 each.
2.    A price can be setup for multiple units of measure, i.e. $10 each, but only $110 for a dozen.
3.    A price can be calculated based on a cost, i.e. average cost of the item, plus a certain percentage.
4.    Sale price and sale period can be defined separately from the base price.

There are also multiple ways to define discounts:

1.    Discount can be based either on customer type or on volume.
2.    Discount can be defined as a percentage or amount.

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.

Other Considerations

Multicurrency Pricelists

In multi-currency ledgers, it is possible to define the same pricelist in multiple currencies.

 

Notice that pricelist CTPR01 exists in CAD as well as USD currencies. This allows you to define proper pricing for each market.

Pricing and Ordering UoM

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.




Comments are closed.
On July 17, 2013 in General [Post:by]
Tagged With: customer pricing, item pricing, pricing, Sage Accpac, contract pricing, price list, Sage 300 ERP / 9308 Views

Search

Categories

  • General (166) rss
  • Development (158) rss
  • Success Stories (40) rss
  • Products (29) rss
  • Uncategorized (18) rss
  • BTerrell Group (5) rss
  • Project Management (22) rss
  • Web Development (57) rss
  • Web application (33) rss
  • Integration (19) rss
  • Mobile Development (7) rss

Archives

  • 2015
    • January (5)
    • February (7)
    • March (6)
    • April (5)
    • May (2)
  • 2014
    • January (13)
    • February (12)
    • March (13)
    • April (12)
    • May (11)
    • June (12)
    • July (11)
    • August (13)
    • September (10)
    • October (8)
    • November (6)
    • December (4)
  • 2013
    • April (73)
    • May (22)
    • June (20)
    • July (20)
    • August (22)
    • September (19)
    • October (13)
    • November (12)
    • December (7)

Tags

.NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
Email this article from Codepartners.com
Separate multiple addresses with commas(,)
To: *   Copy me
Subject:
From: *
Message:
ABOUT US / CONTACT US / NEWS & EVENTS
CodePartners / 16200 Addison Rd. STE 270 / Addison, Texas 75001 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.