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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Suggest Lines action o...
Small and medium business | Business Central, N...
Answered

Suggest Lines action on VAT Return page on BC SaaS version 27

(10) ShareShare
ReportReport
Posted on by Nick Webb 907
When I attempt to click the Suggest Lines action on the VAT Return page in BC version 27 I get the error: VAT statement template VATNWT name VATNWN has a wrong setup. There must be nine rows, each with a value between 1 and 9 for the Box No. field.
Our standard VAT Statement that has worked for previous BC releases contains 28 lines and has lots of Row Totalling, so to simplify matters, I created a fresh basic one that contains just 9 rows, one for each box. See values below, but I still get the error above.
Name Row No. Description Box No. Type Account Totalling Gen. Posting Type VAT Bus. Posting Group VAT Prod. Posting Group Amount Type Row Totalling Calculate with Print Print with New Page
VATNWN 1 Total VAT on Sales 1 Account Totalling 5610 Sale DOMESTIC STANDARD Amount   Sign TRUE Opposite Sign FALSE
VATNWN 2 VAT on purchases from EU 2 Account Totalling 5620 Purchase EU STANDARD Amount   Sign TRUE Sign FALSE
VATNWN 3 Total VAT 1 + 2 3 Account Totalling 2003 Sale DOMESTIC REDUCED Amount   Sign TRUE Opposite Sign FALSE
VATNWN 4 VAT Reclaimed 4 Account Totalling 5630 Purchase DOMESTIC REDUCED Amount   Sign TRUE Sign FALSE
VATNWN 5 VAT Due 5 Account Totalling 5410 Purchase DOMESTIC OUTSIDE Amount   Sign TRUE Sign FALSE
VATNWN 6 Total Sales ex VAT 6 Account Totalling 6110..6190 Sale   STANDARD Amount   Sign TRUE Opposite Sign FALSE
VATNWN 7 Total Purchases 7 Account Totalling 8210..8270 Purchase   REDUCED     Sign TRUE Sign FALSE
VATNWN 8 Value of supplies to EU 8 Account Totalling 2330 Sale   OUTSIDE     Sign TRUE Opposite Sign FALSE
VATNWN 9 Value of Purchases from EU 9 Account Totalling 5430 Purchase   ZERO     Sign TRUE Sign FALSE


The error appears to happen in the event below in the "GovTalk Subscribers" codeunit:

    [Obsolete('Event will be removed in a future release', '27.0')]
    [EventSubscriber(ObjectType::Report, Report::"VAT Report Request Page", 'OnBeforeVATStatementLineFindSet2', '', false, false)]
    local procedure OnBeforeVATStatementLineFindSet2(VATStatementLine: Record "VAT Statement Line"; VATReportHeader: Record "VAT Report Header"; var IsHandled: Boolean)
    var
        GovTalk: Codeunit GovTalk;
    begin
        if GovTalk.IsEnabled() then
            exit;
        IsHandled := true;
        if VATStatementLine.Count() <> 9 then
            Error(WrongVATSatementSetupErr, VATReportHeader."Statement Template Name", VATReportHeader."Statement Name");
    end;

I see no reason why VATStatementLine.Count would not be 9 but it clearly isn't? Any help would be greatly appreciated?
Categories:
Dynamics 365 Business Central
I have the same question (8)
  • Suggested answer
    TarikJerkovich Profile Picture
    TarikJerkovich 293 on at

    Hi Nick,

     

    I tested this on SaaS BC 26.5, and the Suggest Lines action is working fine on both pages — it seems to behave correctly when linked to the VAT Statement Template.

     

    Here’s what I used:

    • VAT Reports Configuration: Codeunit 745 – VAT Report Suggest Lines

    • VAT Statement Template: Only using purchase documents for the VAT return

    • VAT Return Page: Selected the correct VAT Statement Template and VAT Statement Name

    With this setup, everything worked as expected — lines were suggested without any validation or missing line issues.

    It might be worth checking your VAT Statement Template lines, especially the Row Totaling and Box No. fields, to make sure they’re set up correctly and mapped to valid values.

     
    VAT Statment template - i only use purchase documents for return VAT 
     
    Vat returns:
     
    automaticlly fill the amounts:
     
     
    I hope so its helpful or give you some tips/hitns.
    I will try on 27 BC 
  • Nick Webb Profile Picture
    Nick Webb 907 on at
    Thanks for your response. Our VAT Statement was also working in version 26 but it stopped working after we upgraded to version 27.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,049 Super User 2026 Season 1 on at
    Currently, BC Yammer Group is inaccessible. It is recommended to submit a Service Request (SR) to Microsoft for their assistance in the investigation.
     
    Thanks
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 12,760 Super User 2026 Season 1 on at
    Hello,
     
    The UK VAT Return in BC v27 now requires exactly 9 VAT Statement lines (Box 1–9). Any missing or extra lines cause the “wrong setup” error.
    Create a simple 9-line VAT Statement (Type = VAT Entry Totalling, Box 1–9) and use that for the VAT Return.
     
    Regards,
    Oussama Sabbouh
  • HM-22101606-0 Profile Picture
    HM-22101606-0 46 on at
    hello,, i now have this for 2 of our customers.  Version 26.5 worked fine. Version 27 i get the above error when doing suggested lines.  As suggested above, i removed any blank lines even if they were being used as a description line & i still get the error message.  I have logged a ticket with m=Microsoft support,  just checking to see if anyone has resolved this so far as the deadline for MTD submission is tomorrow.  Thank you 
  • DB-06111345-0 Profile Picture
    DB-06111345-0 8 on at
    We are also experiencing the same issue since Version 27.  I have created a basic 9 line VAT statement as advised above and still get the same error.
  • Nick Webb Profile Picture
    Nick Webb 907 on at
    I'd be interested to hear the outcome of HM-22101606's Microsoft support ticket?
  • Verified answer
    HM-22101606-0 Profile Picture
    HM-22101606-0 46 on at
    I was advised it was a known issue & Microsoft was working on a fix.  In the meantime i was advised to uninstall the extension called GovTalk that was auto installed as part of V27.  By doing this it resolved my issue ( i ended up having 3 clients with this issue so far) 
  • SM-12050842-0 Profile Picture
    SM-12050842-0 10 on at
    Hi @HM-22101606-0, Were you able to submit the VAT Return after removing the extension?
  • Stuart Hardman Profile Picture
    Stuart Hardman 53 on at
    I uninstalled the GovTalk extension and successfully submitted the VAT return in v27. Some communication from MS would be nice though....

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,804 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,103 Super User 2026 Season 1

#3
Kamal Khakhkhar Profile Picture

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans