Skip to main content

Notifications

Announcements

No record found.

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

Mismatch on Dashboard [Ongoing Sales - Sales Order quantity]

(0) ShareShare
ReportReport
Posted on by 60
My dashboard for the Ongoing Sales - Sales Orders is not showing the correct figure and I don't know how to fix it. The other cards on the dashboard are correct, it's just this one. Any ideas to fix? 
 
It reality, we have 71 unposted Sales Orders.
  • Verified answer
    AllieKGB Profile Picture
    AllieKGB 60 on at
    Mismatch on Dashboard [Ongoing Sales - Sales Order quantity]
    I found the problem, but not sure what caused it. I did have some filtered views that was hiding the unknown Sales Orders. Once I removed the filters, I found 120 blank orders that were generated right around the same day. Must have been some web app glitch for day. Thanks for everyone's help!
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    Mismatch on Dashboard [Ongoing Sales - Sales Order quantity]
    Hi, below is the standard logic for this cue, which is very simple. If the numbers don't match up, I suspect there is customization on your Sales Order List.
     
    Hope this helps.
    Thanks.
    ZHU
  • Brett F Profile Picture
    Brett F 191 on at
    Mismatch on Dashboard [Ongoing Sales - Sales Order quantity]
    Did you confirm that the list that opened has no filters?  Which role center are you using?
  • AllieKGB Profile Picture
    AllieKGB 60 on at
    Mismatch on Dashboard [Ongoing Sales - Sales Order quantity]
    I appreciate the response.
     
    This is a built-in default filter so I didn't filter anything myself. When I click the card, it takes me to my open sales order queue. (Sales orders that have not been fully posted (defined as being fully shipped and invoiced). The card part says a large number but clicking into it takes me to this list where the numbers don't match.
     
    I have gone to the Cue Setup section to look at Cue ID 24 (Ongoing Sales Orders) but this only seems to allow me to adjust the colors based on quanitites triggers.
     
    Taking a deeper dive, this section of the dashboard, called "Activities" takes data from the Activities Cue table. When I look at the Activities Cue table, there are certain columns that are linked to other tables, but not the "Ongoing Sales Orders" column. It must be a formula set somewhere but that is the problem - I don't know where.
     
  • HVGEEL Profile Picture
    HVGEEL 288 on at
    Mismatch on Dashboard [Ongoing Sales - Sales Order quantity]
    You might check the definition of the Cue
     
    What is the exact filter?
    - sales header (more general than Type::Order)
    - what about the 'unposted' notion in your question: Unposted is not a status of a Sales Header, what is your exact definition of 'unposted'? 

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans