Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

calculate the Value Added Tax (VAT)

Posted on by 25

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!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: calculate the Value Added Tax (VAT)

    Hi Shirlite,

    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.

    Best regards,

    Ludwig

  • Shirlite Profile Picture
    Shirlite 25 on at
    RE: calculate the Value Added Tax (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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: calculate the Value Added Tax (VAT)

    Hi Shirlite,

    But VAT does not impact your sales revenue and profitability.

    For what country/region do you implement the VAT?

    Best regards,

    Ludwig

  • Shirlite Profile Picture
    Shirlite 25 on at
    RE: calculate the Value Added Tax (VAT)

    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.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: calculate the Value Added Tax (VAT)

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans