Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

How can I reset the total sales on Nav2018?

Posted on by 51

How do I reset the total sales of my customer in Nav2018? or How do I reset my total sales in Nav2018?

  • Verified answer
    Poundex Profile Picture
    Poundex 51 on at
    RE: How can I reset the total sales on Nav2018?

    Hi Zhu and others who took their time to help me. We found our solution by adding a fiscal year. So we are good now. Thank you very much

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: How can I reset the total sales on Nav2018?

    Hi, Have you tried the report below?

    pastedimage1673828942351v1.png

    pastedimage1673829152258v2.png

    pastedimage1673829166126v3.png

    pastedimage1673829198156v4.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: How can I reset the total sales on Nav2018?

    hello, you need a customization

  • Poundex Profile Picture
    Poundex 51 on at
    RE: How can I reset the total sales on Nav2018?

    Hey DAniele,

    So I tried what you said and it now shows only 2023 total sales on customer list. But is it possible to do this also on a customer card? Even if it shows 2023 total sales on the customer list, when I open the customer card it still show previous years of total sales

  • Poundex Profile Picture
    Poundex 51 on at
    RE: How can I reset the total sales on Nav2018?

    Hello DAniele,

    Thank you for taking the time to answer my inquiry. I know about the filter and you are talking about the customer list total sales. However, my concern is about (eg. 1 customer total sales includes all the years of that customers' total sales) What I want is to filter that customers sale of year 2023 only. I don't want to see the customers total sales previous year. Thanks

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How can I reset the total sales on Nav2018?

    You can talk to your developer and have them add a flowfield that only shows the sales for 2023.

    Or you can use the flowfilter and have a field that shows only the sales for the period that match your flowfilter.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: How can I reset the total sales on Nav2018?

    hi

    that is a flowfield, you should do a development

    but if you go to the customer list you can use the filter by total, to get the situation of the period you are interested in

    pastedimage1673634924650v1.png

    pastedimage1673635017857v2.png

    pastedimage1673635136010v3.png

    DAniele

  • Poundex Profile Picture
    Poundex 51 on at
    RE: How can I reset the total sales on Nav2018?

    What I'm trying to accomplish here is reset the total sales so that only 2023 will reflect on the total sales. Currently, total sales include 2022.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: How can I reset the total sales on Nav2018?

    Hi, As far as I know, this is not possible in standard functions. You need to block the current customer and create a new one.

    This is because the posted data cannot be deleted in NAV, unless you customize to clear the data, but this is very dangerous and not recommended.

    Hope this helps.

    Thanks.

    ZHU

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