Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Prepayment to Vendors including VAT

(0) ShareShare
ReportReport
Posted on by 45

I have implemented prepayments to vendors. 

  1. We have domestic vendors levying 13% VAT and 0% VAT for small turnover. I also have Imports which attract 0% VAT.
  2. The VAT product posting groups have been set-up and the prepayment G/L account VAT product group is also set at 0% VAT.

I can also toggle the item VAT between 0% and 13%.  However in order to be able to produce a prepayment invoice for the entire amount I have to change the vendor card setting to "prices include VAT". 

Is this the correct way to handle prepayments including VAT?

  • Suggested answer
    StephenC58 Profile Picture
    45 on at
    RE: Prepayment to Vendors including VAT

    Thanks.  It works :)

  • Verified answer
    Dirk Profile Picture
    on at
    RE: Prepayment to Vendors including VAT

    I think you need one more General Product Posting Group to manage Domestic/Items/13%

  • StephenC58 Profile Picture
    45 on at
    RE: Prepayment to Vendors including VAT

    Dirk,

    Thanks. It gets me part way to a solution.

    I already created three G/L prepayment accounts.

    I also have 2 Gen Bus Posting Groups (Domestic and Imports) and 1 relevant Gen Product Posting Group (Items).

    Mapping Import/Items/0% to the Import Prepayment G/L OK

    Mapping Domestic/Items/0% to the Domestic 0% Prepayment G/L OK.

    It seems that without creating another Gen Bus Posting Group I have nowhere to map the Domestic 13% Prepayment.

    Am I missing something?

  • Suggested answer
    Dirk Profile Picture
    on at
    RE: Prepayment to Vendors including VAT

    Usually the design for prepayments is that the VAT % for the prepayment invoice always comes from the Prepayment G/L Account .

    That means that you need to have different Prepayment G/L Accounts for the different VAT criteria / VAT rates (in your case probably NATIONAL/13,  NATIONAL/0, IMPORT/0).

    The General Business Posting Group and the General Product Posting Group from the document line determine the line / the combination in the General Posting Setup from which the system know which of the three different Prepayment G/L Accounts arte to be taken for the prepayment invoice and it's prepayment VAT calculation.

    I think Prices Incl. VAT should not be used for this.

    Hope this helps

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 691

#2
YUN ZHU Profile Picture

YUN ZHU 646 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 495

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans