496
Hi,
We have 10000 items where I need to do an update. I export the item and modify the Price Incudes VAT to true and reupload it. However, I notice that the Unit Price Excl. VAT did not change. I coded a workaround and in my code I invoke the item's method CalcUnitPriceExclVAT(). The code will be triggered using a button; unfortunately, it still did not change the Unit Price Excl. VAT. Need you help guys, thank you in advance.
May be you have still not understood the concept. In a copy/test company put VAT % for all the VAT Posting combinations in VAT posting setup. And see the difference.
Hi Bilal;
For the Sales and Receivable Setup - Yes. We have an existing setup for that. For the setup in Price and Sales - I don't like to do it manually. I thought that by uploading an item (modify the Price Includes VAT = true) through configuration package it will update the Unit Price Excl VAT but it did not.
Have you done other setup that I have mentioned above related to VAT bus posting group price ?
Hi Bilal;
Thank you so much Bilal.
Initially, the toggle button for Price Includes VAT is set to OFF. So, I uploaded an item template to update the value for the field Price Includes VAT to true. However after uploading the item template, it did not refresh the amount of Unit Price Excl VAT. Is there a way, to update its value?
Hi Gecel,
If Item has Unit price incl. VAT flag true and you want it to be different from Unit Price Excl. VAT then there is a setup for that. It is called VAT Bus. Posting Group Pr. Actually it is the same VAT Bus. Posting Group table but it is assigned on items for those where items prices already included VAT. There are two places where we can do this.
Setup:
One is on Sales & Receivables setup. Open Sales & Receivables setup and add the value in VAT Business Posting Group Pr. Here you should take care that this setting will be for all of the items.
Second place where you can do this setup is on item table. May be this field is not visible on card but you can add using config package as I can see you know how to import data. So you can add value to that field. You can setup at both places and the group added on card level will get priority. If item card has no value then system will get from Sales & Receivables setup.
Working:
When you put some unit price in the item card where price incl. VAT flag is true. System will use the combination of VAT Bus. Posting Group Price (either from S&R setup or from item card) and VAT prod posting group to get the VAT % from the VAT Posting setup and then deduct VAT updates the value in Unit Price excl. VAT.
How you can test it without any setup:
For a very simple demo. Open an item with unit price incl. VAT, take its Gen prod posting group and go to VAT posting setup. See the combination where Gen Bus posting Group is empty (As you have not put VAT Bus Posting Group Price neither in S&R setup nor in item card) and Gen prod posting group with the item's gen prod posting group. Put some value in VAT %. Come back to item card and see the difference between Unit price and Unit Price Excl. VAT.
Hopefully it will help you. Please verify my answer if it fulfills your query.
Regards,
Bilal Rai
Hi Gecel,
Which Business Central version are you using ? I mean is it a localized ? I understand your issue. It is easily solveable.
#1
YUN ZHU
499
Super User 2025 Season 1
#2
Sagar Dangar, MCP
373
#3
Mansi Soni
327
Share
Report
All responses (
Answers (
