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

Regarding Set filter

(0) ShareShare
ReportReport
Posted on by 220

Dear

I would like to total of item quantity from sale invoice line I can done it though total field assign quantity in from  sales line table but the problem is that while we are using the  type g/l account at the place of item and filled its quantity it also add in grand total. which I don't  want please provide the solution for it .I have no specified range for items also  

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Miguel Llorca Gómez Profile Picture
    7,019 User Group Leader on at
    RE: Regarding Set filter

    Check the MSDN guides: msdn.microsoft.com/.../jj551761(v=nav.70).aspx

  • Shuabhm saxena Profile Picture
    220 on at
    RE: Regarding Set filter

    Provide some guidance for sort out that problem .

    how I can perform it .

    which type of filter I used what is the code for it . variable constant etc.

    Regards

    Shubham

  • Suggested answer
    Aleksandar Totovic Profile Picture
    16,765 on at
    RE: Regarding Set filter

    If you are beginner, you cannot do it alone, because you must know about coding. You have to ask it from your implementation partner.

  • Shuabhm saxena Profile Picture
    220 on at
    RE: Regarding Set filter

    yes I want to do it in sales invoice report .

    I am a beginner so I am not much aware about where to write down code for it and what is code for it .

    I just use to drag & drop in reports .so kindly tell me the way or method to get resolve such issues

    Thanks & Regards

    Shubham

  • Suggested answer
    Miguel Llorca Gómez Profile Picture
    7,019 User Group Leader on at
    RE: Regarding Set filter

    I mean that you want that for the Sales Invoice, right? The only way for doing that thing is modifying the report, filtering the line types, and so on.

  • Mohana Yadav Profile Picture
    60,604 Super User 2025 Season 2 on at
    RE: Regarding Set filter

    Can you be more clear please?

    where do you need this?

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans