Explore Dynamics 365 Business Central on Microsoft LearnDiscover features, benefits, and examples of Dynamics 365 Business Central in action in this short training module.
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
While creating an invoice in Salels journal, we select the customer, enter the amount and the balance account information. The VAT being calculated by the system is inside the invoice amount. For example we are creating an invoice for 1000 AED with 5% VAT. The VAT should be-50 AED whereas the VAT being calculated in Bal. VAT Amount columns is -47.62 which is if price was including tax. How can we fix this as I am unable to locate the setup that governs this. Kindly help.
Mine is working fine (GST rather than VAT - but setup probably the same).
This is my setup if that helps:
If using Items, you have the option on the item as to whether price includes GST:
Then invoice looks like this:
I then tried adding an extra line with a G/L Account style entry and it treated it the same way. I looked for specific settings against the GL Account and Sales & Receivables Setup, but couldn't see any setting that specifically drives that behaviour.
But then I looked specifically at the Customer - and that does have an option about inclusive / exclusive pricing:
Hope something in all this helps :-)
Relooking at your question, I think you are doing this via Journal entry instead. I think when doing it in the journal window, you do enter the GST Inclusive amount. So to get your scenario, you would actually enter the value as 1050, and then the VAT would calculate correctly.
That makes sense to me as you are just wanting to do a single line entry - so to ensure the VAT calculates correctly, you need to enter the VAT Inclusive amount.
Firstly thanks for your response. The scenario is a bit different then what you described above. We have a sales invoice which we are directly recording against a customer and revenue account. The invoice value is 1000 AED and the VAT is supposed to be calculated upon the 1000 bringing the total to 1050 AED. But unfortunately the system is calculating the VAT inside 1000 AED which mean VAT Amount LCY is -47.62 AED and the revenue will be posted for 952.38 AED. I hope I was able to put the point across to you.
And as far as the sales invoice is concerned, the VAT works perfectly fine whether the price includes or excludes VAT.
P.S. We are using W1 version on premise.
Can you post some screen shots of how you are entering?
Business Applications communities