Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I am trying to automate the calculation for the Withhold taxes in the Accounts payable module. In order to make it a streamlined process, I must calculate the VAT 16% from all the vendor invoices, so the Base amount is used to calculate the Withholding taxes in the Payment journal. Consider the following:
As I said, I must set up the VAT calculation for all invoices, but then the expense will not be recorded in the Project, instead, It would go to a VAT Payable account. We do not want this. So I came out with the possible workarounds:
The questions: Is there an automatic process to settle the balance in the VAT account and charge the full amount to the Projects?
Is there another way to configure the Tax codes so I get the Base amount to calculate the Withholding taxes (and the full invoice is charged to the Projects)?
For which country/region have you setup your tax?
Isn't the standard withholding tax functionality available in your country/region?
Rather than trying to do a workaround with VAT, I would recommend using the standard withholding tax functionality.
Yes, you were right all along. This was easily solved by using the field: Exclude % in the Values form within the Withholding tax codes
Just like you suggest, the system would calculate the base with a given percentage. I only had to extract the VAT from the total invoice, instead of the base, and that's it. It took a simple calculation and the system was able to reduce the liability on the vendor according to the Withholding tax code Value.
Business Applications communities