web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

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

How to configure posting groups & GL for Full VAT on Sales Invoice

(0) ShareShare
ReportReport
Posted on by 15

Hi all, 

We are configuring our Chart of Accounts and Posting Groups for every eventuality that may occur, and are struggling to get a working setup for a VAT Only Sales Invoice or Sales Order. 

We have tried to do it at line level with our VAT Control Account, and it will only work with our FULL VAT stamp in the VAT Product Posting Group, and a Gen Prod Post attached. We can then change the VAT Product Posting Group to FULL VAT on the sales line. This allows us to successfully post.

The problem with this setup is that we are unable to run a VAT Statement if our VAT Control Account Product has a VAT Product Posting Group, or a General Product Posting Group. it delivers this error: 

"VAT Prod. Posting Group must be equal to '' in G/L Account: No.=GLBS-83100. Current value is 'STANDARD'."

In the opposite situation, having no VAT Product Posting Group or General Product Posting Group set on the VAT Control Account allows us to run the VAT Statement but will not allow us to post a VAT Only transaction, generates this error when posting: 

"Gen. Prod. Posting Group must have a value in Sales Line: Document Type=Invoice, Document No.=1000003NVS, Line No.=10000. It cannot be zero or empty."

Have any of you encountered this? How have you overcome it?

Thanks,

Dominic

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Dominic,

    To setup VAT you have to complete all the setups. This includes VAT Prod. Posting Group. Here is an overview...

    If you want to set up VAT calculations yourself, or just want to learn about each step, this topic contains descriptions of each step.

    To use the VAT Setup assisted setup guide to set up VAT (recommended). We recommend that you use the VAT Setup assisted setup guide to set up VAT in Business Central.

    To start the assisted setup guide, follow these steps:

    Choose the Lightbulb that opens the Tell Me feature. icon, enter Assisted Setup.

    Choose Set up VAT and complete the steps.

    When you have completed the assisted setup, visit the Vat Posting Setup page and check if you have to fill in additional fields according to the local requirements in your version pf Business Central.

    To set up VAT registration numbers for your country or region. To help ensure that people enter valid VAT registration numbers, you can define formats for the VAT registration numbers that are used in the countries or regions in which you do business. Business Central will display an error message when someone makes a mistake or uses a format that is incorrect for the country or region.

    To setup VAT registration numbers, follow these steps:

    Choose the Lightbulb that opens the Tell Me feature. icon, enter Countries/Regions.

    Choose the country or region, and then choose the VAT Reg. No. Formats action.

    In the Formats field, define the format by entering one or more of the following characters:

    # Requires a single-digit number.

    @ Requires a letter. This is not case-sensitive.

    ? Allows any character.

    You can use other characters as long as they are always present in the country or region format. For example, if you need to include a period or a hyphen between sets of numbers, you can define the format as ##.####.### or @@-###-###.

    To set up VAT business posting groups. VAT business posting groups should represent the markets in which you do business with customers and vendors, and define how to calculate and post VAT in each market. Examples of VAT business posting groups are Domestic and European Union (EU).

    Use codes that are easy to remember and describe the business posting group, such as EU, Non-EU, or Domestic. The code must be unique. You can set up as many codes as you need, but you cannot have the same code more than once in a table.

    To set up a VAT business posting group, follow these steps:

    Choose the Lightbulb that opens the Tell Me feature. icon, enter VAT Business Posting Group, and then choose the related link.

    Fill in the fields as necessary. You set up default VAT business posting groups by linking them to general business posting groups. Business Central automatically assigns the VAT business posting group when you assign the business posting group to a customer, vendor, or general ledger account.

    To set up VAT product posting groups. VAT product posting groups represent the items and resources you buy or sell, and determine how to calculate and post VAT according to the type of item or resource that is being bought or sold. It is a good idea to use codes that are easy to remember and describe the rate, such as NO-VAT or Zero, VAT10 or Reduced for 10% VAT, and VAT25 or Standard for 25%.

    To set up a VAT business posting group, follow these steps:

    Choose the Lightbulb that opens the Tell Me feature. icon, enter VAT Product Posting Groups, and then choose the related link.

    Fill in the fields as necessary.

    To combine VAT posting groups in VAT posting setups. Business Central calculates VAT amounts on sales and purchases based on VAT posting setups, which are combinations of VAT business and product posting groups. For each combination, you can specify the VAT percent, VAT calculation type, and general ledger accounts for posting VAT for sales, purchases, and reverse charges. You can also specify whether to recalculate VAT when a payment discount is applied or received.

    Set up as many combinations as you need. If you want to group VAT posting setup combinations with similar attributes, you can define a VAT Identifier for each group, and assign the identifier to the group members.

    To combine VAT posting setups, follow these steps:

    Choose the Lightbulb that opens the Tell Me feature. icon, enter VAT Posting Setup, and then choose the related link.

    Fill in the fields as necessary.

    To assign VAT posting groups by default to multiple entities. If you want to apply the same VAT posting groups to multiple entities, you can set up Business Central to do so by default. There are a couple of ways to do this:

    You can assign VAT business posting groups to general business posting groups, or customer or vendor templates

    You can assign VAT product posting groups on general product posting groups

    The VAT business or product posting group is assigned when you choose a business or product posting group for a customer, vendor, item, or resource.

    Assigning VAT Posting Groups to Accounts, Customers, Vendors, Items, and Resources

    The following sections describe how to assign VAT posting groups to individual entities.

    To assign VAT posting groups to individual general ledger accounts

    Choose the Lightbulb that opens the Tell Me feature. icon, enter Chart of Accounts, and then choose the related link.

    Open the G/L Account card for the account.

    On the Posting FastTab, in the Gen. Posting Type field, choose either Sale or Purchase.

    Choose the VAT posting groups to use for the sales or purchase account.

    To assign VAT business posting groups to customers and vendors

    Choose the Lightbulb that opens the Tell Me feature. icon, enter Customer or Vendor, and then choose the related link.

    On the Customer or Vendor card, expand the Invoicing FastTab.

    Choose the VAT business posting group.

    To assign VAT product posting groups to individual items and resources

    Choose the Lightbulb that opens the Tell Me feature. icon, enter Item or Resource, and then choose the related link.

    Do one of the following:

    On the Item card, expand the Price & Posting FastTab, and then choose Show more to display the VAT Product Posting Group field.

    On the Resource card, expand the Invoicing FastTab.

    Choose the VAT product posting group.

    Setting Up Clauses to Explain VAT Exemption or Non-Standard VAT Rates

    You set up a VAT clause to describe information about the type of VAT that is being applied. The information may be required by government regulation. After you set up a VAT clause, and associate it with a VAT posting setup, the VAT clause is displayed on printed sales documents that use the VAT posting setup group.

    If needed, you can also specify how to translate VAT clauses to other languages. Then, when you create and print a sales document that contains a VAT identifier, the document will include the translated VAT clause. The language code specified on the customer card determines the language.

    When non-standard VAT rates are used in different types of documents, such as invoices or credit memos, companies are usually required to include an exemption text (VAT clause) stating why a reduced VAT or zero VAT rate has been calculated. You can define different VAT clauses to be included on business documents per the type of document, such as invoice or credit memo. You do this on the VAT Clauses by Doc. Type page.

    You can modify or delete a VAT clause, and your modifications will be reflected in a generated report. However, Business Central does not keep a history of the change. On the report, the VAT clause descriptions are printed and displayed for all lines in the report alongside the VAT amount and the VAT base amount. If a VAT clause has not been defined for any lines on the sales document, then the whole section is omitted when the report is printed.

    To set up VAT clauses

    Choose the Lightbulb that opens the Tell Me feature. icon, enter VAT Clauses, and then choose the related link.

    On the VAT Clauses page, create a new line.

    In the Code field, enter an identifier for the clause. You use this code to assign the clause to VAT posting groups.

    In the Description field, enter the VAT exemption text that you want to display on documents that can include VAT. In the Description 2 field, enter additional text, if needed. The text will be displayed on new document lines.

    Choose the Description by Document Type action.

    On the VAT Clauses by Doc. Type page, fill in the fields to set up which VAT exemption text to display for which document type.

    Optional: To assign the VAT clause to a VAT posting setup right away, choose Setup, and then choose the clause. If you want to wait, you can assign the clause later on the VAT Posting Setup page.

    Optional: To specify how to translate the VAT clause, choose the Translations action.

    To assign a VAT clause to a VAT posting setup

    Choose the Lightbulb that opens the Tell Me feature. icon, enter VAT Posting Setup, and then choose the related link.

    In the VAT Clause column, choose the clause to use for each VAT posting setup it applies to.

    To specify translations for VAT clauses

    Choose the Lightbulb that opens the Tell Me feature. icon, enter VAT Clauses, and then choose the related link.

    Choose the Translations action.

    In the Language Code field, choose the language you are translating to.

    In the Description and Description 2 fields, enter the translations of the descriptions. This text displays in the translated VAT report documents.

    To create a VAT posting setup to handle Import VAT

    You use the Import VAT feature when you need to post a document where the entire amount is VAT. You will use this if you receive an invoice from the tax authorities for VAT for imported goods.

    To set up codes for import VAT, follow these steps:

    Choose the Lightbulb that opens the Tell Me feature. icon, enter VAT Product Posting Groups, and then choose the related link.

    On the VAT Product Posting Groups page, set up a new VAT product posting group for import VAT.

    Choose the Lightbulb that opens the Tell Me feature. icon, enter VAT Posting Setup, and then choose the related link.

    On the VAT Posting Setup page, create a new line, or use an existing VAT business posting groups in combination with the new VAT product posting group for import VAT.

    In the VAT Calculation Type field, choose Full VAT.

    In the Purchase VAT Account field, enter the general ledger account to use for posting import VAT. All other accounts are optional.

    Using Reverse Charge VAT for Trade between EU Countries or Regions

    Some companies must use reverse charge VAT when trading with other companies. For example this rule applies to purchases from EU countries/regions and sales to EU countries/regions.

    This rule applies when trading with companies that are registered as VAT liable in another EU country/region. If you do business directly with consumers in other EU countries/regions, then you should contact your tax authority for applicable VAT rules.

    You can verify that a company is registered as VAT liable in another EU country by using the EU VAT Registration Number Validation service. The service is available for free in Business Central. For more information, see the section titled Verify VAT registration numbers in this topic.

    Sales to EU Countries or Regions

    VAT is not calculated on sales to VAT-liable companies in other EU countries/regions. You must report the value of these sales to EU countries/regions separately on your VAT statement.

    To correctly calculate VAT on sales to EU countries/regions, you should:

    Set up a line for sales with the same information for purchases. If you have already set up lines on the VAT Posting Setup page for purchases from EU countries/regions, then you can also use these lines for sales.

    Assign the VAT business posting groups in the VAT Bus. Posting Group field on the Invoicing FastTab of the customer card of each EU customer. You should also enter the customer's VAT registration number in the VAT Registration No. field on the Foreign Trade FastTab.

    When you post a sale to a customer in another EU country/region, the VAT amount is calculated, and a VAT entry is created by using the information about the reverse charge VAT and the VAT base, which is the amount that is used to calculate the VAT amount. No entries are posted to the VAT accounts in the general ledger.

    Understanding VAT Rounding for Documents

    Amounts in documents that are not yet posted are rounded and displayed to correspond with the final rounding of amounts that are actually posted. VAT is calculated for a complete document, which means that VAT is calculated based on the sum of all lines with the same VAT identifier in the document.

    Thanks,

    Steve

  • Dominic Portella Profile Picture
    15 on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Hi Steve,

    Thank you for this guide, there is some great information in there. I found the sections about Reverse Charge VAT and VAT Clauses very useful. With regards to my initial query, have you experienced the conflict that I described wherein running a VAT Statement requires no Posting Groups on the VAT Control Account GL, but being able to create a 100% VAT transaction requires the opposite?

    Thanks,

    Dominic

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Dominic,

    Sorry to say I have not encountered the issue you have. Maybe other Forum members have. Hopefully someone will reply.

    Thanks,

    Steve

  • Dominic Portella Profile Picture
    15 on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Steve,

    Could you describe your process for creating a 100% VAT Sales Invoice? With this I should hopefully be able to spot any flaws in our current process that generates the conflict.

    Thanks,

    Dominic

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Dominic,

    If I had a 100% VAT Invoice then my VAT % would be set to 100% against the VAT Business/VAT Product Posting Group combination (see below image). You see my Domestic and FULL are marked 100% so the Item I have marked FULL NORM will produce a 100% VAT calculation.

    pastedimage1630334718621v1.png

    Thanks,

    Steve

  • Dominic Portella Profile Picture
    15 on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Hi Steve,

    Totally agree with this setup. I think I should have been more clear in my questioning. When creating a Sales Invoice and actually processing a 100% VAT transaction, on the Sales Lines would you add the VAT Control Account GL? Effectively 'selling' the GL instead of an Item or Charge. Or, would you add Default Sales GL?

    Thanks,

    Dominic

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Dominic,

    If I was creating a Sales Invoice for a 100% VAT, my Item VAT Prod. Posting Group and my G/L Account, would denote FULL and I will make sure the VAT Product Posting Group appears on the Line so I can alter if necessary.

    Thanks,

    Steve

  • GarethRGL Profile Picture
    79 on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Hi Steve,

    Quick question re VAT - I have posted another question about this, but I'm at a loss, and you seem to understand the VAT more than anybody.

    We're in the UK, so we charge 20% VAT on products/services.

    We are actually in Northern Ireland, so we don't pay VAT on products coming from Ireland itself.

    We have a range of products we buy, that come from Ireland with 0% VAT on them, but we are required to sell them out with 20% VAT on them.

    I can't seem to understand how to set this up.

    Here is how it's configured so far.

    The Item:

    VAT Prod Posting Group - Standard

    VAT Bus Posting Group - Domestic

    The Vendor:

    VAT Bus Posting Group - EU

    The Customer:

    VAT Bus Posting Group - Domestic

    When I create an invoice to the customer at £10, it is adding 20%, so £12.

    However, when I create a purchase invoice to the EU vendor, it's still showing £12 with £2 VAT.

    Is there something I'm missing or is there something not configured correctly ?

    Thanks, appreciate any help on this,

    Gareth

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: How to configure posting groups & GL for Full VAT on Sales Invoice

    Gareth,

    Your EU Vendor is VAT BPG = EU so the Item VAT PPG = ZERO since you are waived to pay VAT. That is what you expect, correct. You will need to update the VAT PPG on the Purchase Line to Zero.

    pastedimage1631830771287v1.png

    Thanks,

    Steve

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,308

#2
Sumit Singh Profile Picture

Sumit Singh 2,798

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,793

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans