How to define Sales price of product based on Purchase Price

By | August 28, 2018

Sage Enterprise Management (Sage X3) provides us with a feature to setup Sales price based on the Purchase price of Product. This set-up is subsequently used for charging a customer based on the purchasing cost of the product.

E.g. an instance where you want to sell a product to a customer on the 50% margin from the purchasing cost of that product.

To setup this functionality, follow below steps-

  1. Navigate to Products -> Purchase Tab
  2. Enter base Purchase price for product.
  3. Note that price here is entered in Euro currency
    • e.g. 40 Euro
unit purchase price

IMG: Product screen

  1. Navigate to Products -> Sales Tab
  2. Enter Price origin as ‘Purchase price %’ as shown in screenshot below-
  3. Enter % applied as desired margin in % on purchase price
    • e.g. 50%
purchase product screen

IMG: Product screen

  1. Notice that the base price is updated to 40 % of the Purchase price.
    • Sales price = 50 + (50*40%) =56 Euro
  2. Navigate to Sales -> Orders -> Orders
  3. Enter all mandatory details such as Site, Customer, Product, Quantity
  4. Notice that gross price is automatically fetched as per the Sales price calculated based on Purchase price %.
Sales order screen

IMG: Sales Order Screen

Hope this blog helps!

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage CRMSalesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.