In SAP Business One, how can I check how many items have been issued against my Employee Code?

[williamwachholz]

Hello,

You wanna know how many lines of marketing documents that the employee is the owner of the document?

Best regards,

[williamwachholz]

Hello,

In this case you can write a query that search all possible marketing documents. I will give an example of RDR1 (Sales Order). Then you can replicate the same logic for other marketing documents.

SELECT count(*),

               T2."firstName"

FROM ORDR T0

INNER JOIN RDR1 T1 ON T1."DocEntry" = T0."DocEntry"

INNER JOIN OHEM T2 ON T0."OwnerCode" = T2."empID"

GROUP BY T2."firstName"

Additionally you can adjust the query to fit your scenario (e.g exclude canceled documents, include other marketing documents; maybe transform in a count widget per user - that shows only their documents; or a dashboard, or a formmatted search to be user like a report).

I don't know all the details of your scenario but that is a start point because a default functionality for your requirement in SAP B1 is unknown to me.

Best regards

[MBilalazhar]

Yes, i wanna to know