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
How Customer Pricing Works in Sage 300 ERP
SHARE THIS
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.
Tagged With:
customer pricing
,
item pricing
,
pricing
,
Sage Accpac
,
contract pricing
,
price list
,
Sage 300 ERP
/ 9308 Views
Search
Categories
General (166)
Development (158)
Success Stories (40)
Products (29)
Uncategorized (18)
BTerrell Group (5)
Project Management (22)
Web Development (57)
Web application (33)
Integration (19)
Mobile Development (7)
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.