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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Customer "Special...
Small and medium business | Business Central, N...
Answered

Customer "Special Price" Currency Code

(0) ShareShare
ReportReport
Posted on by GarethRGL 79

Evening,

This is a bit of a weird one - I have tried to search to see if anyone has had this issue before, but I can't see anything...

So,

Within our BC setup all our items have a price, but there's also a trade price, wholesale price etc etc, so customers can be added to pricing groups or have their own set of prices assigned to their customer card.

The thing is, some of our "stockist" customers are not VAT registered and are perhaps small shops, I know this is irrelevant because we still charge them VAT, however when we print a price list for them they don't want to have to calculate the VAT, so to make it easier for them we thought we could print a list including VAT.

So I used one customer as an example, we have custom fields on item cards so we can filter what products are "assigned" to what customers, basically so they don't get 16,000 items on a price list, just the items they buy. So I pull up the customer card, go to special prices, enter the product etc, and the price, there is no option here to say whether the price is inc or exc VAT. However, when you choose the edit the page in excel, there is a column that says "price includes VAT" then the typical true or false answer.

They are all set to false, so I thought oh great, I changed them to true, hit publish, and here come the error messages.

Details: A row update in data set Sales_Prices_Excel was not published. Error message: 'No Currency within the filter ''. CorrelationId: 19b8ea43-54ee-4caa-aaf0-8bf216577603.'

I don't understand, we are in the UK so only use GBP, however GBP is not an option in BC and I know you're not "supposed" to add an option for it as it's the base currency.

So why is it asking for a currency all of a sudden, and how can I get round it?
Any help would be greatly appreciated !!

Thanks,
Gareth

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    Hi Gareth 

    I am receiving that error message anytime I want to use Edit in Excel for Sales Price. Our base currency is USD. I think it is a bug that does not consider blank currency (which means base currency) as a currency.

    I always use configuration package to update sales price. 

  • GarethRGL Profile Picture
    GarethRGL 79 on at

    Hi MahGah,

    From your post I learned that you are experiencing the same sort of issue, just in a different page/card.

    I try to avoid configuration packages to be honest, in all honesty our training comes from videos and webinars as our MS partner doesn't offer any training whatsoever.

    However, I tried to use the Sales Price List you referred to, it was disabled, I enabled it in feature management (in our sandbox), and there you go, the option to show certain price lists inc VAT.

    I'll just use this from now on - doesn't explain the issue, which does seem to be some sort of bug, but did give me a solution.

    Thanks for your time,

    Gareth

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    Hi Gareth

    Thanks for sharing your solution. I will try it in our environment to see if I can stop using Configuration Package.

    If you need a step by step guideline for "specials price" configuration package please let me know and I am more than happy to put one together.

    Thanks

  • GarethRGL Profile Picture
    GarethRGL 79 on at

    Yeah the feature (from what I see) is supposed to be rolled out in an update in Q2 of 2022, but you can enable it yourself early (which is what I did). It seems to be a lot more advanced. I'm not sure if it's the one you were referring to, if basically creates a new price list on it's own card, number series (by default) is S00000...

    That's what we're going to use moving forward as it seems a lot easier than using excel if it's going to through error messages out.

    As for the guide, if you have time to through something together it would be greatly appreciated, if you don't it's not a problem :)

    Thanks,

    Gareth

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    Thanks Gareth for extra info. 

    This is a guideline for Special Price. Please let me know if you have any questions. 

    1) Search for Configuration Package

    pastedimage1629327340025v1.png

    2) Click "New" to create a new package. This way you can use it anytime you need it.

    pastedimage1629327392974v2.png

    3) Define Code and name (something like Special Price) then in Table ID select 7002 and arrow down. Say no to the question. 

    pastedimage1629327508801v3.png

    4) in Table you can use Fields to add/remove fields from package . Also, Filter to filter based on special Field (for instance, if you want all special price for Item A or Customer B).

    pastedimage1629327624054v4.png

    5) Excel then Export to Excel 

    pastedimage1629327733940v5.png

    6) Now open the Excel file and change price or add to it. Do NOT remove any line since it will not be effective

    pastedimage1629327821426v6.png

    7) make SURE you did NOT select "Delete Table Records Before Processing" by mistake. if you select this function it will delete the entire table and replace it with new file.

    pastedimage1629327870525v7.png

    8) Excel then Import from Excel then select the Excel file you prepared. 

    pastedimage1629327966885v8.png

    9) Then select Import 

    pastedimage1629328092395v9.png

    10) if you have a long list like us grab a cup of coffee. By the way I try to not do this during the day since sometimes impacts BC's performance 

    11)  When it is done importing you will see No of package import changes 

    pastedimage1629328306544v10.png

    12) Then Function and Apply Data and select yes

    pastedimage1629328361332v11.png

    pastedimage1629328384954v12.png

    13)  The n if your package is large you will see the following message. Click I understand then ok

    pastedimage1629328433488v13.png

    14) You will see the progress. Make sure to not close your brewers. 

    pastedimage1629328484505v14.png

    15) When it is done you receive a message like below. Make sure nothing marked as Error. If all done successfully your are done. Please note since I did not change anything it says 0 record inserted or modified. in your case it should shows some numbers. 

    pastedimage1629329065001v15.png

  • GarethRGL Profile Picture
    GarethRGL 79 on at

    Unreal MahGah - thank you very much for that.

    I'm going to test that a bit in our sandbox to see if I can get it right, then it'll be extremely handy in our production environment moving forward.

    Gareth

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,036 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,179 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 828

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans