Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Confirm the following Price List configuration

  1. In Order Entry > Setup > Configuration, select all the options below:
    Review the notes on Price and Discounts taken from the Sage Intacct Help - Configure Order Entry below, where required:

    1. Price schedules = Yes
      A price schedule defines a percentage discount on top of a specific price list, such as a 10% discount on top of your retail price list. Select this option if you want to be able to create one or more named price schedules, which you can then assign to customers for the purpose of tracking discounts.

    2. Customer Price Lists = Yes
      Enables you to assign price lists to particular customers. If you assign a price list to a customer, this price list overrides the one associated with the transaction definition for the Order Entry transaction.

    3. Fixed Customer Discounts = Yes
      Enables you to assign a blanket discount percentage (for example, 10% off everything) on a customer-by-customer basis. When you select this option, a new Discount % field is added to Customer records. When you sell an item to a particular customer, the system proposes the latest price, which includes the discount.

    4. Line Item discount on suggested price = Yes
      Select to add a DISC% field to line items on Order Entry transactions for the purpose of adding on-the-fly discounts. For example, selecting this option would allow a user to add a percentage discount of his or her choice to a particular line item.

  2. After saving the Configuration, please confirm you can then maintain pricing against the customer:

    1. Go to Order Entry > Setup tab > Customers, then select the Additional Information tab, and Invoicing details section of the page, shown below:


  3. In Order Entry > Setup > Transaction Definition (see online help here), for the form used by the website to enter orders in Sage Intacct, see the example below shown called “Sales Order-Inventory“, confirm the Initial Price list and Special Price list is defined, as required. Then ensure the CMS > CloudLINK > Sage Intacct Settings > Order Entry Transaction Definition and Initial Price List and Order Entry Special Price List match.
    Image Modifiedconfigured in the

Fixed Price Lists

If any Price List in Sage Intacct has Fixed equal to Y, see example image below, this indicates whether or not the price is the fixed or final price. In a cascading (or layered) price list structure, the first time the system encounters Fixed = Y for an item, it will present that price as the Suggested price on the transaction regardless of any other price defined for that item in all other price lists.
Image Modified

For example, say your company has a regular price list and a seasonal price list that each contain a different price for the same item. On the transaction definition, the regular price list is specified as the Initial price list and the seasonal price list is specified as the Special price list. The system evaluates the Initial price list first and then evaluates the Special price list to determine the item's Suggested price. If the item has Fixed = N in both price lists, the system presents the Special price list price as the Suggested price. If the item has Fixed = Y in the Initial price list, the system stops further evaluation and presents the fixed price as the Suggested price on the transaction.

Base Price List

If a Customer is not assigned a specific Price List or Price Schedule in Order Entry > Setup tab > Customers, then select the Additional Information tab, and Invoicing details section of the page shown below, then the Initial Price List configured in the CMS > CloudLINK > Sage Intacct Settings will apply.
Image Modified

The Initial Base Price is also required to be set in the CMS > CloudLINK > Field Mappings, see below:
Image Modified

Customer Price Lists

If a Customer is assigned a specific price list in Order Entry > Setup tab > Customers, then select the Additional Information tab, and Invoicing details section of the page shown below, then the customer after login to the website will shown product pricing from this assigned Price List.
Image Modified

Price Schedules

Fixed Customer Discounts by Customer or Billing Contact or Shipping Contact.

NOTE: When configuring pricing by Billing Contact or Shipping Contact the contact that is assigned pricing must be assigned in the corresponding Bill-to Contact or Ship-to Contact field of the Customer in order for the website to use the pricing

Price Levels (Product Specific)

Price Levels can be assigned to a product from the Price/Cost Info tab of an item (Distribution > Inventory > Stock Items)

  • Two price levels can be assigned: Default Price and RRP

Image Removed

Default Price

The Default Price can be set as the Standard Price in CatalogueLINK

  • In CatalogueLINK Upload, navigate to Setup > Catalogue Fields and configure it to:

Image Removed

  • This can be seen on the website

Image Removed

RRP

The RRP can be set as the Standard Price in CatalogueLINK

  • In CatalogueLINK Upload, navigate to Setup > Catalogue Fields and configure it to:

Image Removed

  • This can be seen on the website

Image Removed

Sales Prices by Price Type (Customer Specific)

Customer (inc. Volume Breaks and Effective Dates)

Sales Price by Customer can be configured from Finance > Accounts Receivable > Sales Prices

  • In this case the the Sales Prices are being filtered by Product
  • Customer 516609 has been assigned a price of $15 for AIRFIL01 ($10 if 5 or more are purchased)

Image Removed

  • This can be seen on the website (single product)

Image Removed

  • And for 5 or more products

Image Removed

Base (inc. Volume Breaks and Effective Dates)

Sales Price by Base Price can be configured from Finance > Accounts Receivable > Sales Prices

  • In this case the the Sales Prices are being filtered by Product
  • AIRFIL01 has been assigned a Base Price of $20 ($16.50 if 5 or more are purchased)
  • Customer 516609's specific pricing has been changed to an expired date range as it is being used as the example buyer

Image Removed

  • This can be seen on the website (single product)

Image Removed

  • And for 5 or more products

Image Removed

Customer Price Class (inc. Volume Breaks and Effective Dates)

Sales Price by Price Class can be configured from Finance > Accounts Receivable > Sales Prices

...

the

...

pricing

...

Image Removed

  • This can be seen on the website (single product)

Image Removed

  • And for 5 or more products

Image Removed

Unit of Measure (inc. Percent and Quantity Breaks)

Units of Measure can be assigned to a product from the General Settings tab of an item (Distribution > Inventory > Stock Items)

In the following examples TEST UOM3 has been assigned the following units of measure:

  • Minute (base UOM)
  • Hour (60x minute)
  • Day (1440x minute)

Image Removed

  • The standard prices (no special pricing for these UOMs are below:

Image Removed

Base Price

Sales Price by Base Price can be configured from Finance > Accounts Receivable > Sales Prices

Image Removed

Image Removed

  • This can be seen on the website:

Image Removed

Customer Price

Sales Price by Customer Price can be configured from Finance > Accounts Receivable > Sales Prices

Image Removed

Image Removed

  • This can be seen on the website:

Image Removed

Customer Class Price

Sales Price by Customer Class Price can be configured from Finance > Accounts Receivable > Sales Prices

  • This example has been configured to apply to all Trade customers

Image Removed

Image Removed

  • This can be seen on the website:

Image Removed

Discount Codes (inc. Percent and Quantity Breaks)

Discount by Percent: will discount by a given percentage

Discount by Amount: will discount by a given amount

Info

Note: 'Discount by Amount' is applied to the item not the total order value

Break by Quantity: will apply the discount when a given number of items are added to the cart

Break by Amount: will apply the discount when the total order amount has reached the given value

Customer Price Class and Item

Discount Codes can be configured from Finance > Accounts Receivable > Discounts

  • In this case the the discount is being applied to ALARM01 and Internet Customer Price Class
  • Customer 516609 is assigned the Internet Price Class from its Delivery Settings tab
  • Item ALARM01 has been assigned an discount amount on quantity for customer 516609 ($40 off each if 10 or more are purchased)

Image Removed

  • Below  you can see when 9 are added to the cart the customer pays full price:

Image Removed

  • And when 10 are added to the cart:

Image Removed

Customer Price Class and Item Price Class

Discount Codes can be configured from Finance > Accounts Receivable > Discounts

  • In this case the the discount is being applied to the Retail Item Price Class and Internet Customer Price Class
  • ALARM01 is assigned the Retail Price Class from its Price/Cost Info tab
  • Customer 516609 is assigned the Internet Price Class from its Delivery Settings tab
  • Item ALARM01 has been assigned a discount % on amount for customer 516609 (20% off if the pre discount total is $1000 or more ex GST)

Image Removed

  • Below  you can see before the ex GST total reaches $1000 the customer pays full price:

Image Removed

  • And once the ex GST total hits $1000:

Image Removed

Customer and Item

Discount Codes can be configured from Finance > Accounts Receivable > Discounts

  • In this case the the discount is being applied to an item (ANTSEI01) and customer (516609)
  • Item ANTSEI01 has been assigned a discount % on amount for customer 516609 (75% off if the pre discount total is $1000-1999 ex GST)

Image Removed

  • Below  you can see before the ex GST total reaches $1000 the customer pays full price:

Image Removed

  • And once the ex GST total hits $1000:

Image Removed

Customer and Item Price Class

Discount Codes can be configured from Finance > Accounts Receivable > Discounts

  • In this case the the discount is being applied to the Retail Price Class and customer (516609)
  • ALARM01 is assigned the Retail Price Class from its Price/Cost Info tab
  • Item ALARM01 has been assigned a discount % on amount for customer 516609 (20% off if the pre discount total is $500-999 ex GST)

Image Removed

  • Below  you can see before the ex GST total reaches $500 the customer pays full price:

Image Removed

  • And once the ex GST total hits $500:

...