web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Sales and Purchase Item Discounts - Bulk Entry

(0) ShareShare
ReportReport
Posted on by

Hi All, 

I need help finding the most effective solution to the following scenario for creating sales and purchase discounts.

Let's say we receive a list price from a vendor and they provide us also a net price to provide to our clients (20% of list) . We quote to client the net price and we purchase from the vendor at the client discount (%) x commission (%). What is the best way to handle this in Business Central?

Currently, I have it set up as the following: 

Sales Price = Vendor List Price

Sales Discount = item discount group (for all items from a specific vendor) at 20%

Purchase Price = Vendor List Price

Purchase Discount = 20% x 10%

The reason it would be set up this way is that the client discount % could change but the list price never changes. I am just wondering if the way I have it currently set up is best for dealing with bulk updates/entry later on OR whether there is another way to handle this in Dynamics. I did notice that Purchase Discounts did not have the same option of grouping as the sales pricing. I should also add that it is not possible to apply the same discount to ALL items from this vendor as it is product-type based. Is there a way so that I can add this type of discount to a bulk number of items?

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    414 on at

    Hi,

    I am not sure if I get your question completely but to bulk update prices, profits and costs we can use the Adjust Item Prices/costs report available out of the box.

    6253.Capture1.PNG

  • Suggested answer
    Community Member Profile Picture
    on at

    Kasandra,

    Adding to what Bilal wrote... Not sure which BC Version you are on but if you are on the latest version and have activated the New Sales Prices feature, you could use this to both update and edit. Here is a brief overview:

    Edit active prices in Prices Overview and implement price changes using Price Worksheet

    Important - Some of the functionality described in this release plan has not been released.

    EDIT ACTIVE PRICES IN PRICES OVERVIEW AND IMPLEMENT PRICE CHANGES USING PRICE WORKSHEET
    Enabled for Public preview General availability
    Users by admins, makers, or analysts pastedimage1622128783037v2.png Apr 7, 2021 May 2021

    Business value

    Almost every business has its own approach to pricing its products or services. Some use price lists that apply to specific groups of customers, and some just rely on sales prices. Therefore, Business Central provides flexibility in defining and updating prices and price lists using prices overviews and worksheets.

    Feature details

    When you enable the New Pricing Experience feature update on the Feature Management page, the Feature Data Update guide opens. To specify that you primarily work with sales prices, turn on the Use default prices toggle. If you use sales price lists, turn off the toggle.

    pastedimage1622128783037v3.png

    If Use default price lists is turned on during feature data update, existing prices will be converted to default price lists for each area (sales, purchase, and jobs). This lets you edit prices in the same way as before. The default price lists will be automatically specified on the Sales & Receivables Setup, Purchases & Payables Setup, and Jobs Setup pages.

     Note - If prices are set only on item or resource cards, the default price lists will not include those prices during feature data update. However, you can open any of the default price lists and use the Suggest Lines action to add the prices from the item or resource cards. Also, if you already enabled New Pricing Experience, you can create default price lists manually or use one of your existing price lists as default. To make an existing price list the default, turn on the Allow Updating Defaults toggle, and in one of the setup pages—for example, Sales & Receivables Setup—choose this price list as the Default Sales Price List.

    pastedimage1622128783038v4.png

    If Use default price lists is turned off, existing prices will be converted to new price lists according to what they apply to, what starting and ending dates they have, currencies, units of measure, and the minimum quantity.

    When you turn on the Allow Editing Active Price toggle on the Sales & Receivables Setup and Purchase & Payables Setup pages, you can edit prices on active price lists in the context of the selected item, resource, customer, or vendor. When the toggle is turned off, to update prices in a price list you must change the status of the price list to Draft, make your change, and then activate the price list.

    pastedimage1622128783038v5.png

    The Prices Overview page provides an overview of prices across all price lists. You can set filters that will narrow down the list of prices to modify or add to. When you're done modifying prices, you can choose Verify Lines to verify prices against other price list lines to avoid duplicates and ambiguity during price calculation.

     Note - When you edit a line in an active price list, the status of the line becomes Draft, and the line will not be considered during price calculation until you use the Verify lines action. After you verify the price, the line's status becomes Active and it will be considered in price calculations.

    pastedimage1622128783038v6.png

    To add new prices, use the Add New Lines action on the Prices Overview page. This opens the Prices Worksheet page, where you can add one or more price lines, either by suggesting them based on criteria, copying them from other price lists, or manually entering them.

    pastedimage1622128783038v7.png

    After you enter new prices on the Prices Worksheet page, you can compare them to existing prices before you implement the changes. Choosing the Implement Price Change action verifies prices against other price lists to avoid duplicates and ambiguity during price calculation.

    Hope this helps.

    Thanks,

    Steve

  • Community Member Profile Picture
    on at

    Hi Steven,

    This is helpful and I realized that we do not yet have this feature enabled, although it does look like it's available to us. Now, with this being said, I see that there is in fact an option to include the discount on the purchasing side. However, I cannot seem to find out where to create price discounts (on the purchasing side).

    I have created an item discount group - DISCOUNT A

    I want to know how I can set up a discount so that it will be applied to a bulk number of items both on the pricing side (customer) and cost side (vendor) for anything in item discount group "DISCOUNT A". The percentage will be different for each. I have looked through many of the documents Dynamics training guides, etc. but it seems to be client-focussed, as well, I may be missing something but I could not see the bulk changes - which is where what you mentioned above likely applies.

    Any advice on this would be appreciated.

  • Suggested answer
    Community Member Profile Picture
    on at

    Kasandra,

    OK, staying with base BC pre-new feature, on the Item Discount Groups you setup your Discount A. Now you have to establish the Items and Customers.

    pastedimage1622238614629v1.png  

    Click Prices & Discounts. This will setup the Customer Pricing side.

    pastedimage1622238644819v2.png

    As for the Vendor side, Item Discount Group will not work here as you setup Vendor Pricing off the Vendor Card. Click Navigate/Line Discounts. Here you enter the Item, Min Qty, Discount %. Yes you can load these with a Configuration Package, if a large list.

    pastedimage1622238809893v3.png

    Thanks,

    Steve

  • Community Member Profile Picture
    on at

    Hi Steve,

    I have been playing around in Dynamics on and off here for a bit. What you provided was very helpful and I have updated our system to include the new way of implementing sales prices and lists. However, I did notice that the discount shows up as "line discount". This does not work for our purposes. We want to have it so that we have a "list price" and "net price". The "net price" should be the price that shows up on the sales line and on all of our reports. The list price is not to be available to anyone. Is this a capability in Dynamics?

    Net price = list price x multiplier

    I understand we can update all prices - but we need to be able to have it so that every year or so that the multiplier changes, we can quickly update the multiplier only which will in turn update all of the net pricing. Otherwise, it will create a lot of work and looking up.

    Any ideas?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans