Notifications
Announcements
No record found.
Hello! I need to calculate the Value Added Tax (VAT) for the ForecastSales row using ForecastSales.SalesPrice and some PayrollTaxCodeId. Can this be done using the standard functionality? Thanks in advance for your answers!
Hi Shirlite,
Why would you include VAT in the sales forecast?
VAT is usually recorded in the balance sheet and does not impact your profit.
Why is it that you want to have it in your sales forecast?
Can you also elaborate on what forecast you refer to?
Is this related to sales orders, projects, etc. ?
Best regards,
Ludwig
Hi Ludwig!
These are customer requirements. "The goal is to ensure that the lines (requirements for goods and materials) in the demand forecast are properly executed and monitored."
This is purely related to the demand forecast.
But VAT does not impact your sales revenue and profitability.
For what country/region do you implement the VAT?
As I understand it, this is only necessary for convenience. This is a new field that I will add to the ForecastSales table and to the ForecastSales form on the TabPageItemSpecification Tab Page. This field must be calculated for the country Kazakhstan
I see.
Can you try the following:
Transfer your sales forecast to the budgeting module by making use of the standard periodic process for that.
Once the amount is there you can e.g. add the VAT by making use of a budget plan that adds a VAT % on top of your sales forecast.
That should work out of the box without system modification.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 467 Super User 2025 Season 2
Martin Dráb 420 Most Valuable Professional
BillurSamdancioglu 241 Most Valuable Professional
