Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

The headline of last week's insight does not Update new the top customer and top selling item

Posted on by 15

Hello everyone,

The headline of last week's insight does not update the customer and top selling customer is top customer for January but many customers have more than this after that. kindly any help

Additionally, this item has not been the top seller for the past few months

 

 

 

  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 6,993 Super User on at
    The headline of last week's insight does not Update new the top customer and top selling item
    You can also check the Job Queue Entries page and see if the job queue with Object ID 1441 has an error. The system uses job queues to update the headline so perhaps there is an issue there.
     
  • Suggested answer
    Faisal Qureshi Profile Picture
    Faisal Qureshi 15 on at
    The headline of last week's insight does not Update new the top customer and top selling item
    Using the below top customer query directly, I got actual top customers, but I don't know why in standard, the same query from Microsoft doesn't work automatically. Can you suggest a trigger or procedure to resolve the problem?
     
     
    although I am using latest extension for headlines 
     
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 5,007 Super User on at
    The headline of last week's insight does not Update new the top customer and top selling item
    Hi
    You could review the code if possible.
    Here in the query to obtain the top customer, we see that it adds the "Amount (LCY)" field from the "Cust. Ledger Entry" table
    And about the top item it is the sum of the "Quantity (Base)" field of the posted sales invoice lines.ALAppExtensions/Apps/W1/EssentialBusinessHeadlines/app/src/queries/BestSoldItemHeadline.Query.al at main · microsoft/ALAppExtensions · GitHub
    BR
    GR

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans