Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Tax is not getting pop...
Small and medium business | Business Central, N...
Answered

Tax is not getting populated in Report Layout

(0) ShareShare
ReportReport
Posted on by RE-24072358-0 187
Hello Experts,
 
I found that the GST ( TAX) amount is not populated and the /Total Incl.Taxes/  is not accurate in Sales Order Print Layout. I'm using the default Report Layout and data set. See the below screen shot for the details and share your thoughts. 
 
See the below screen shot for the Report ID.
 
////
 
See the below screen shot for Sales Order Report, The Tax amount is not populated and it's showing a bold line (under Total INR).
 
////
 
See the below screen shot for the data set. GST Components are mapped in this.
////
 
See the below screen shot for the Sales Order which is trying to print and the GST is there. 
 
////
 
 
Thanks in advance for sharing your thoughts. 
 
Best Regards,
Ranjith 
Categories:
Business Central
  • Suggested answer
    RE-24072358-0 Profile Picture
    RE-24072358-0 187 on at
    Tax is not getting populated in Report Layout
    The issue has been solved. There is a condition as below in the default code.
     

     begin

                                    if not ShowInterInf then begin

                                        if not GSTSetup.Get() then

                                            exit;

     

                                        if not TCSSetup.Get() then

                                            exit;

     

    Hence there should be a value in the Tax Type field in TCS Setup page. There is no value selected in this page for my company, that caused for this issue. 

     

    Best Regards,

    Ranjith 

  • RE-24072358-0 Profile Picture
    RE-24072358-0 187 on at
    Tax is not getting populated in Report Layout
    Hi YUN ZHU,
     
    I have export to Excel (Data Only) and there is no value in GST columns. See the below screen shot.  Will do register support case with MS. 
     
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Tax is not getting populated in Report Layout
    I'm not sure if this is a problem with the layout or this report.
    You can select Send to in the Request Page, and then export to Excel (data only) to see if the values are correct. If the value is correct, please add it to the layout again, if the value is not correct, then it is a problem with this localized report.
     
    Hope this helps.
    Thanks
    ZHU
  • Suggested answer
    Govinda Kumar Profile Picture
    Govinda Kumar 2,203 Super User 2024 Season 1 on at
    Tax is not getting populated in Report Layout
    Please review the properties of both the label textbox and amount textbox to make sure the correct dataitem is used for GST amount... or just show the source expression..

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans