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 :
Microsoft Dynamics NAV (Archived)

Totatling different in sales invoice report

(0) ShareShare
ReportReport
Posted on by

Hi guys,

I have 1 sales invoice that shows the totaling in a wierd way. It doesnt show the VAT amount like it normally does.

Its the same report.

How come?

222.PNG

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    tpupko Profile Picture
    2,048 on at

    Hi Cristopher,

    1. Check that you have VAT in Sale Invoice

    2. Section VAT in invoice depends on setup in General Ledger Setup - Print VAT specification in LCY

    Tatiana

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,096 on at

    To me it looks like you do not have VAT in this sales invoice (at least, the sum of the lines gives the total without VAT). Check your VAT posting group settings for this invoice. Otherwise, what exactly report is it? Check also if it has been customized.

  • Community Member Profile Picture
    on at

    Hi, 

    They have same VAT posting group = DANMARK.

    In VAT entries it also have VAT entries.

    This is the only invoice it shows it like this. Its a standard report 206.

    333.PNG

  • Suggested answer
    Hasitha Jayasuriya Profile Picture
    645 on at

    Hi Christoper,

    Check if you entered prices "Excluding VAT". Maybe this is the reason.

    Regards,

    Hasitha J

    If my response answered your question, please take a minute to "Verify" the solution as it would help other forum members

  • Community Member Profile Picture
    on at

    Hi,

    Thanks for the help everybody. After spending quite some time on comparing data with other reports showing correct I found why this 1 invoice was showing different. Surprisingly the issue had nothing to do with VAT setup on the invoice header or line.

    As you can see in the first screenshot I posted. The invoice that isnt showing the VAT amount have description line as the last line. 

    If you have a description line as the last line on your invoice it wont show the VAT amount on the report.

    I solved this by changing visibillity on the amount lines which had a show based on an expression which wasnt working as it should.

    444.png

    I guess that this is a bug from microsoft side in the reports for NAV2017? How can I report it?

  • Suggested answer
    Amol Salvi Profile Picture
    18,698 on at

    You need to debug the program and check . Take help of developer

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans