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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Error message while posting Payment reconciliation journal

(6) ShareShare
ReportReport
Posted on by 1,080

I have this error message while posting payment reconciliation journal.

Have anyone had any idea?

  • Suggested answer
    Teagen Boll Profile Picture
    3,920 Super User 2026 Season 2 on at

    You may have entries in that table set as Normal Type for VAT in the background. If you're in Canada or the US I would just go to your VAT Posting Setup page and make sure the VAT Calculation Type = Sales Tax:

    You may need to delete that payment reconciliation journal and then recreate it in order to clear the Vat Type on the lines.

     

    If you're not in the US or Canada you need to populate a Sales and Purchase VAT Account in that VAT Posting Setup table.

     

    Best,

     

    Teagen Boll, CPA
  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    3,390 Super User 2026 Season 2 on at

    The error indicates that Business Central is trying to post a transaction where both the VAT Business Posting Group and VAT Product Posting Group are blank, and it cannot find a corresponding VAT Posting Setup.

    I would not create a blank VAT Posting Setup combination simply to get around the error. First, I would identify which transaction in the Payment Reconciliation Journal is causing the issue. Once you find the line, check the Account Type and Account No. that Business Central has assigned to it.

    If the transaction has been assigned to a G/L Account, open that G/L Account and check the VAT posting settings, particularly the VAT Product Posting Group. I would also check the Text-to-Account Mapping because the account may have been selected through the transaction text during the automatic application.

    The error is therefore likely related to the posting setup of the account selected for one of the transactions. I would need to see that particular journal line and the related G/L Account setup before confirming exactly what needs to be changed.

     

    Glad to help - follow up if anything is unclear.   

    ►  If this solved it, marking it verified helps others too.       

    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer

    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis

     
     
     
  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,479 User Group Leader on at

    Hi @STP ,

    The VAT Posting Setup in Business Central is crucial for accurately handling VAT on sales and purchases. It involves setting up VAT business and product posting groups, which combine to define the tax rate, calculation method, and G/L accounts for each combination. The setup determines which VAT accounts your transactions hit in the chart of accounts, pulling values from the VAT business posting group (who you are selling to or buying from) and the VAT product posting group (what you are selling or buying). This setup is essential for ensuring that VAT is calculated correctly and posted to the appropriate accounts.

    Set up value-added tax - Business Central | Microsoft Learn

    Regards,

    Saurav Dhyani

    https://www.youtube.com/@sauravdhyani

  • Suggested answer
    OussamaSabbouh Profile Picture
    19,571 Super User 2026 Season 2 on at

    Hello STP,

    The error means Business Central is trying to post VAT for one of the Payment Reconciliation Journal lines, but the line has VAT Bus. Posting Group = blank and VAT Prod. Posting Group = blank, so no corresponding VAT Posting Setup exists. Since Payment Reconciliation can map bank transaction text directly to G/L accounts, check the affected expense G/L account(s) and the journal line—especially Gen. Posting Type, VAT Bus. Posting Group, and VAT Prod. Posting Group. If the expense should carry VAT, assign the correct posting groups and make sure that combination exists under VAT Posting Setup; if the transaction should not calculate VAT, review why a Gen. Posting Type (Purchase/Sale) is being assigned and correct the account/mapping rather than creating a blank-to-blank VAT Posting Setup just to bypass the error.

    Regards,
    Oussama Sabbouh

  • Suggested answer
    Mansi Soni Profile Picture
    10,427 Super User 2026 Season 2 on at

    Hello @STP ,

    The error indicates that Business Central is trying to post the payment with blank VAT Business Posting Group and VAT Product Posting Group, but there is no corresponding VAT Posting Setup for the blank/blank combination. Check the G/L account being used on the Payment Reconciliation Journal line and verify its VAT Bus. Posting Group, VAT Prod. Posting Group, Gen. Posting Type, and the related VAT Posting Setup. If this is a direct G/L payment, either assign the appropriate VAT posting groups to the G/L account or ensure the required blank/blank VAT Posting Setup exists, depending on your tax requirements. The Payment Reconciliation Journal itself does not determine the VAT setup; the posting configuration of the account being used does.

    I hope this answer helps. If you find it helpful, please consider marking it as the verified answer.

    Regards,
    Mansi Soni

  • Suggested answer
    Mayank Jangid Profile Picture
    79 on at

    Hi @STP ,
    According to the available error screenshot you need to check the VAT Posting setup. There should be recording with the combination of “VAT Business Posting Group” and “VAT Prod. Posting Group” Since in this scenario both values are blank then you should details on the Vendor Card for VAT Business Posting Group and for "VAT Prod. Posting Group" check Corresponding GL Account.

  • Suggested answer
    AndrewThomas81 Profile Picture
    2,814 Super User 2026 Season 2 on at

    I would check if “Copy VAT Setup to Jnl. Line” is ticked.  This is usually an MS default.

     

    Kind Regards

     

    Andrew Thomas FCCA MCP

    YouTube - Use Business Central

    LinkedIn

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans