Recording Prices and Discounted for Sales

by Jan 28, 2019Items

Home 9 User Experience 9 Items 9 Recording Prices and Discounted for Sales

As a business, your main source of income is from your sales. Sales are one of the most important aspects for your company, so when you need to record and keep track of all the surrounding aspects. Business Central is there to help you keep things tidy and optimized. It’s always good to be clear on your sales price and how much you’re selling your product for but it also helps to increase sales when the customer knows that price, and they are informed of a discount towards that product.

One way to make this easier for you and your employees is to make a recording of the prices and sales in your account, to reflect customers. Business Central will help optimize this by applying discounts to an item that still gives you a preferred profit range.

Setting up a Sales Price

A sales price is the documented price for a product that will be sold to a customer. This is the initial price of the sale and if you want to keep it this way without a discount, all you have to do is leave the discount fields empty and don’t select the product on the line discount setup. To begin setting up the sales price:

  1. Click on the “Search for Page” icon and type in “Customers” so the related page will pop up.
  2. Once on that page, you can select the correct customer card and click on the “Prices” button.
  3. Each field has a description of what it means, so fill out the required fields. Filling out the combinations will provide a unique sales price to its customer.
  4. Tip: Located on the “Sales Prices” page, each “Sales Type” field will be filled with the option “Customer“, and the “Sales Code” line will be filled out with the number of the customer.

Setting up a Line Discount for Items

Having a sales price set up for items is basic for selling, but creating discounts for those items is another business requirement. To begin setting up discounts:

  1. Click on the “Search for Page” icon at the top of the screen and type in “Customers” to get to the correct page.
  2. Select the right customer card and click on “Line Discounts” to continue.
  3. Here, you can fill in the related fields on each line that is required. Each field will provide a description after hovering over them.

Setting up an Invoice Discount

An invoice discount is a discount applied to an invoice (as opposed to Line Discounts that are applied to one line only). They are represented by customer cards. Typing in the invoice discount code to the appropriate customer cards will provide that group of customers a discount on the invoice. To begin this, start with these steps:

  1. Select the “Search by Page” icon at the top of the page and type in “Customers.”
  2. This will bring you to the page where you can select the customer card for someone that will be allowed the invoice discount.
  3. Next, the “Invoice Discount Code” field will have codes for different discounts, select the one for the correct invoice discount so the terms from that discount will apply to the invoice. The default value is the number of the customer.

After creating an invoice discount, you can also set up new terms when it comes to the sales invoice discount. To do this, begin here:

  1. Select the “Customer Card” page, where you can click on the “Invoice Discounts” button.
  2. On the following page, click on the “Currency Code” field, so you can enter the correct code associated with that currency. Leaving the field blank will automatically set up the terms for local currency (as is setup in general ledger setup).
  3. On the “Minimum Amount” area, you can insert the minimum amount for an item, so it can be eligible for a discount.
  4. Last but not least, on the “Discount Percentage” field, you can choose the discount to pop up as a percentage of an invoiced amount.

The “Best Calculation” process for Prices

Along with all of this, Business Central includes a handy tool that allows you to calculate the best price and discounts for your items. The highest line discount and the lowest price are automatically calculated together when the line is inserted. Key factors that it takes from are (but there are many other factors taken into account):

  • Does a customer belong to a discounted group or do they provide a price/discount agreement?
  • Does the product in question have a group associated discount groups or discount agreements?
  • Does the date on which the item will be purchased fall between the dates of the selected sale or discount?

Recent Articles from the category

How to Record Prices and Discounts for Purchases

You can't get anywhere as a business if you don't produce sales through selling your items. But it's also just as important to keep as much inventory coming in as what's going out, so it's good to keep a clean record of your purchases, prices for those purchases, and...

read more

Item Transfers and Stock Adjustment

Inventory management is a long and sometimes painful process, that's why with Business Central's inventory management tools there is always an easy way to mark, map, and transfer your physical and digital products around. Although there are a lot of tools involved,...

read more

Creating and Managing Items With Business Central

When it comes to owning a business, a key part of owning it includes selling a product, or keeping up with the stock of selling and receiving goods. Each item in your business can be managed to assign to an item card to make it easier to track and manage. An item card...

read more

Sign Up for News


Highest certification
Microsoft Data Management and
also in D365 Business Central

Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate

See other certifications here