Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Counting processed sales invoices

Posted on by 3
Hi, i want to make a count & record of invoices processed by each employee. I can't find this information via a report and have to go into the individual invoice record to find the employee name. Is there a report to show this information instead of having to access them individually?
 
Thanks :)
Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,333 Super User 2024 Season 2 on at
    Counting processed sales invoices
    Hi, just use the latest In-client Analysis mode, it is very simple to do.
    For example,
     
    Sorry I only have one Salesperson in my record.......
     
     
    Hope this helps.
    Thanks.
    ZHU
     
     
  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,234 Super User 2024 Season 1 on at
    Counting processed sales invoices
    Hi There, you can definitely use "Assigned User ID", but that requires all users processing the invoice to manually select their User ID here. If they forget, you get a posted invoice with a blank Assigned user ID. Alternatively:
    1.  If you do not use Salesperson/Purchasers for any other functionality in your system, you can create a salesperson for each of your user ID in BC and do the mapping in User Setup. Once this mapping is done, whenever a user creates a document, a salesperson will be auto populated from the setup and posted documents will show this salesperson. Then from the salesperson code you can trace back to the user who processed this invoice.
      1. However a user can edit the already populated salesperson code, so it meddles with the data integrity issue
    2. You can talk with your MS Partner, and ask them to expose a field on the list called as "SystemCreatedBy". This is a standard field available from Microsoft, which will record the user ID of the user who posted this document. No one can edit this field at any point of time. Much more reliable but you end up spending some $$ for development
  • Micheleish Profile Picture
    Micheleish 91 on at
    Counting processed sales invoices
    On the sales invoice list page, you can add fields such as salesperson and assigned user id - you can then sort by each person, used date ranges etc.  You can export it to excel if needed hope this helps.
     

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans