Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Regarding Set filter

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

  • Suggested answer
    Miguel Llorca Profile Picture
    Miguel Llorca 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
    Shuabhm saxena 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
    Aleksandar Totovic 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
    Shuabhm saxena 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 Profile Picture
    Miguel Llorca 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
    Mohana Yadav 59,139 Super User 2024 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

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans