web
You’re offline. This is a read only version of the page.
close
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...
Suggested Answer

Prepayments in BC

(2) ShareShare
ReportReport
Posted on by 30
Hi all, I am trying to set prepayments in BC. The issue I have is that the Prepayment Purchase Invoice is picking up the VAT Prod Posting group from the G/L account I've set on The Gen. Post Group. How do I set, and what needs to be done so that Vat Prod Posting Group on the Prepayment Invoice is the same as the one I chose on the Purchase Order lines?
 
PART 2
I have done some tests now , so it is clear.
Just to clarify, my country is localized in Finland, so unlike Australia, I don't get the option to change the VAT Prod Posting Group on the line.
So, retested and came with the following conclusions:
When your PO is for Items , when posting a Pre-payment Invoice , that get 's posted to the Prepayment G/L account I've set on the General Posting Setup. The VAT combination for this Pre-payment Purchase Invoice will be pulled from the VAT Business Posting Group( Vendor) and the VAT Product Posting group on the G/L Account ( the prepayment account ).
So, that doesn't  allow much flexibility on the General post setup on  a simple configuration.

As an example, for a combination of Domestic (Gen Business Posting Groups) purchase of Materials (Gen Prod. posting group) I buy products/material with various VAT procentage. The Prepayment account set for this combination is only one.
On the PO , regardless of the VAT Product posting group I specify or comes inherited from the G/L or Item on the lines, my Prepayment PI will pick the VAT Product posting group form the G/L I specified on my Prepayment Account on General Posting setup.
Therefore if your Prepayment G/L Account is set to Standard (20%) as an examples, regardless of what you set on the line, it will post to Standard (20%) always.
So you might need to have extra various Gen Product groups just for this reason.
I have the same question (0)
  • Ramesh Kumar Profile Picture
    7,529 Super User 2025 Season 2 on at
    Hi,
     
    You need to setup  On the Purchases & Payables Setup page, on the Number Series FastTab, fill in the following fields:
    • Posted Prepmt. Inv. Nos.
    • Posted Prepmt. Cr. Memo Nos.
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
     
     
     
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,639 Super User 2025 Season 2 on at
  • Suggested answer
    Suresh Kulla Profile Picture
    50,247 Super User 2025 Season 2 on at
    The VAT Prod. The posting group is determined by the G/L Account or Item entered on the purchase line. If you use a G/L Account, it will retrieve the value based on the G/L Account card. To match, you need to set the posting group on the Item on both the Purchase and Prepayment Lines. You can also create prepayments from Purchase Order; not sure how you are creating them.
  • Suggested answer
    Yi Yong Profile Picture
    2,590 Super User 2025 Season 2 on at
    Hello,
     
    The VAT Prod. Posting Group of Prepayment Purchase Invoice is taken from the purchase order line's Purch. Prepayment Account GL Account's VAT Prod. Posting Group (combination of Gen. Bus. Posting Group + Gen. Prod. Posting Group).
     
    Below is an example,
    #1 - The combination is EXPORT + RAW MAT. (see that the PO line VAT Prod. Posting Group is using STANDARD).
     
    #2 - Based on this combination, the Purch. Prepayment Account is 2410.
     
    #3 - From G/L Account card, the VAT Prod. Posting Group is ZERO.
     
    So the prepayment invoice posting will be using ZERO instead of STANDARD which is the purchase order line VAT Prod. Posting Group.
     

    So how can you change the VAT. Prod. Posting Group of the prepayment account?

    Well, you need to create a new combination of Gen. Bus. Posting Group + Gen. Prod Posting Group and a new VAT G/L Account.
    #1 - A new combination of EXPORT + RAW MAT_PRE_STD pointing to a new Prepayment G/L Account on the Purch. Prepayments Account.
     
    #2 - This new Prepayment GL Account should have the desired VAT Prod. Posting Group.
     
     
     #3 - Change the purchase order line's to the new combination.
     
     
    In summary, if you need to have different prepayment VAT Prod Posting Group then you will need to create multiple combination each combination should have a unique Prepayment GL account with the respective VAT Prod Posting Group.
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,814 Super User 2025 Season 2 on at
  • Vahid Ghafarpour Profile Picture
    12,200 Super User 2025 Season 2 on at
    If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

    To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

    Thanks for being an active part of the Dynamics 365 Community! 😊

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,092

#2
YUN ZHU Profile Picture

YUN ZHU 663 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 515

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans