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

Counting processed sales invoices

(0) Share

Report

Posted on by Community member

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Micheleish 105 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,250 Moderator on at

Like (1)

Report
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:

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.

However a user can edit the already populated salesperson code, so it meddles with the data integrity issue

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 93,870 Super User 2025 Season 2 on at

Like (1)

Report

Counting processed sales invoices

Hi, just use the latest In-client Analysis mode, it is very simple to do.

More details: https://yzhums.com/35080/

For example,

Sorry I only have one Salesperson in my record.......

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No