GP

Sana Commerce 9.1
Your connector

Item Prices

Sana being the ERP integrated e-commerce solution uses pricing logic of Microsoft Dynamics GP. This means that all prices are managed and calculated in Microsoft Dynamics GP and are used by Sana.

In Microsoft Dynamics GP you can set up item prices using Price Lists.

Currencies, price levels, units of measure, and quantity ranges combine in price lists to give you different options to set up item prices for your customers. To create price lists, you need to set up item currencies, units of measure and price levels beforehand.

Note, that item currencies are available only if you are using Multicurrency Management. In this case, the basic pricing structure for an item has currency at the top level, then price level, unit of measure, and quantity range. If you are not using Multicurrency Management, the structure is price level, then unit of measure, and quantity range.

For more information about how to set up currencies in Microsoft Dynamics GP, see 'Currencies'.

Use the Item Price List Maintenance window to create and manage item price lists. In Microsoft Dynamics GP click: Inventory > Cards > Price List.

The table below provides the description of the fields necessary for the price list setup.

Field Description
Item Number Select the necessary item.
Price Method Select the price method. Price methods are used to calculate prices in the price list. The price method you select will control which values, either percentages or amounts, can be entered to determine pricing for an item.

If you're using Multicurrency Management and want to set up prices for different currencies, you must use the Currency Amount or Percent of List Price price method for that item.

If you set up prices in one currency for an item, then you can use any price method for this item. In this case, it doesn't matter whether you are using Multicurrency Management or not.
Price Level Select the price level. Use price levels to organize customers in groups and create different pricing structures for each separate group.
Unit of Measure Select a unit of measure. Use units of measure to define different prices for different units of measure. The available units of measure are retrieved from the unit of measure schedule assigned to the item.
Currency ID Select the currency. You can set up prices for different currencies only if you are using Multicurrency Management. Use Currency Amount or Percent of List Price price method to add prices for multiple currencies to a price list.

If you do not use Multicurrency Management or if the price method is not Currency Amount or Percent of List Price, the entire price list will be automatically in your default currency.
Price Enter the price or percentage depending on the price method you are using.

If you are using the Currency Amount price method, enter the price in the appropriate line.

If you are using another price method, enter the percentage of the list price or cost to be used to calculate the selling price.
Percent
Start Quantity Accept the default one or change the quantity range. Quantity breaks are typically used to give better pricing to customers who purchase larger quantities of items. Using the start and end quantities you can set up volume (tiered) pricing.

You can create different quantity breaks for each combination of currency, price level and unit of measure.

The All option is marked automatically, signifying that the pricing information for that combination of currency, price level and unit of measure applies no matter what quantity is sold.

To learn more about volume (tiered) pricing, read the article below the table.
End Quantity

 

Volume Prices

Volume pricing is a pricing strategy that allows discounts for bulk purchases. Typically, the greater the number of products purchased the greater discount.

Volume prices are triggered in the shopping cart based on the business logic coming from Microsoft Dynamics GP, and are shown on the product details page. This way a customer can see the pricing offers directly on the product details page, before ordering the product.

Use quantity breaks (Start Quantity and End Quantity) in the price lists to configure volume (tiered) prices.

You can create as many quantity ranges as you need for each combination of currency, price level and unit of measure.

      If you're using quantity breaks for a combination of currency, price level and unit of measure, the ranges you define, such as 0-50 units, 51-100 units and so on, must cover all possible quantities from 0 to 999,999,999,999. The End Quantity for the last quantity range must be 999,999,999,999 with additional 9's if one or more decimals are used to track the item's quantity information.

To show volume prices in the Sana webshop, the Volume prices option should be enabled in Sana Admin: Setup > Products > Price.

If quantity breaks are set in the item price list in Microsoft Dynamics GP and the Volume prices option is enabled in Sana Admin, then in the webshop, on the product details page, a customer will see a link View volume discount under the item price. Clicking on this link opens the table with volume discounts coming from Microsoft Dynamics GP.

For more information about how to set up prices, refer to the official Microsoft Dynamics GP Guide: Inventory Control.

See also:
Currencies
Units of Measure