activities for the user

[Former Member]

How do I know if I want anyone who is using this program, and only the directions where

for each user, for me to check them every day working on what

Thanks

[Former Member · Accepted solution]

hi,

->> Transaction Journal Report. result is all journal transactions details and all Users create the transaction details.

->> Try to Create Query Report so if you need the user report. try that User Traking_All Activites.

Report,

Madhan.

[Former Member · Accepted solution]

Hai all .. thank you have responded to my question,

Yes I want to see in the use of tracking each user to be able to report what has been done,

so how can I see it. Query if the how to make

How to help me ..

Thank you

[Former Member · Accepted solution]

Hi Siauling,

Do this,

If you using SAP B1 2005. Try this In SAP B1 2005.

->> Reports (Module)

->> Query Generater.

->> Open the Query Generater Window and Click Execute Button in Bottom of Left.

->> Clcik the Pencil Button in Top of Left on Query Window and Remove the *SELECT * * then Paste the below query.

->> Click Execute Button in Bottom of Left. Query will Execute and Display the Result of User Traking_All Activites.

->> Execute the below Query and save as the Query Manager.(Click Save Button in Bottom of Right and save the query)

Use this Query. Copy and Execute the Query

Select CASE T1.[TransType]
       When 20 THEN 'GRPO'
       When 13 THEN 'AR Invoice'
       When 14 THEN 'AR Credit Memo'
       When 15 THEN 'AR Delivery'
       When 16 THEN 'AR Sales Return'
       When 18 THEN 'Purchase Invoice'
       When 24 THEN 'Incoming Payment' 	
       ELSE 'Other...'
       END,
T1.[Number], T1.[TaxDate], T1.[LocTotal] from OJDT T1 where 
T1.usersign = ((Select cast(T0.Internal_K as nvarchar(2)) from OUSR T0 
where T0.U_Name=[%0] )) and (T1.[TaxDate] between [%1] and [%2])

Regards,

Madhan.

[keith_taylor2 · Accepted solution]

The posted code is good. I added additional document types that I had in my list. I also added (nolock) to the query which is recommended to avoid locking tables. Added display of journal ID so orange arrow is visible

Select CASE T1.[TransType]

When 13 THEN 'AR Invoice'

When 14 THEN 'AR Credit Memo'

When 15 THEN 'AR Delivery'

When 16 THEN 'AR Sales Return'

When 18 THEN 'AP Invoice'

WHEN 19 then 'AP Credit'

WHEN 20 then 'Goods Receipt PO'

WHEN 21 then 'Goods Return'

When 24 then 'Incoming Payment'

When 25 then 'Deposit'

When 30 then 'Journal Entry'

When 46 then 'Outgoing Payment'

When 57 then 'Check'

when 60 then 'Goods Issue'

when 59 then 'Goods Receipt'

when 67 then 'Inventory Transfer'

when 162 then 'Inventory Re-valuation'

When 69 then 'Landed Cost'

ELSE 'Other...'

END,

T1.[TransId], T1.[TaxDate], T1.[LocTotal] from OJDT T1 where

T1.usersign = ((Select cast(T0.Internal_K as nvarchar(2)) from OUSR T0 (NOLOCK)

where T0.U_Name=[%0] )) and (T1.[TaxDate] between [%1] and [%2]) order by T1.[TaxDate] for browse

[Former Member · Accepted solution]

Hi keith tailor,

thanks for your replay my Question but, i try the your queryeroor

the syntax is:

incorrect syntax near '0', statement service contract (OCDR) could not be prepared

thx.

[Former Member · Accepted solution]

Hi

Try this, it will be work exactly.

SELECT CASE T1.TransType 
    WHEN 13 THEN 'A/R Invoice'
    WHEN 14 THEN 'A/R Credit Memo'
    WHEN 15 THEN 'A/R Delivery'
    WHEN 16 THEN 'A/R Sales Return'
    WHEN 18 THEN 'A/P Invoice'
    WHEN 19 THEN 'A/P Credit'
    WHEN 20 THEN 'Goods Receipt PO'
    WHEN 21 THEN 'Goods Return'
    WHEN 24 THEN 'Incoming Payment'
    WHEN 25 THEN 'Deposit'
    WHEN 30 THEN 'Journal Entry'
    WHEN 46 THEN 'Outgoing Payment'
    WHEN 57 THEN 'Check'
    WHEN 60 THEN 'Goods Issue'
    WHEN 59 THEN 'Goods Receipt'
    WHEN 67 THEN 'Inventory Transfer'
    WHEN 162 THEN 'Inventory Re-valuation'
    WHEN 69 THEN 'Landed Cost'
ELSE 'Other...'
END,
T1.TransId, T1.TaxDate, T1.LocTotal from OJDT T1 WHERE
T1.UserSign = ((SELECT CAST(T0.Internal_K as nvarchar(2)) FROM OUSR T0 (NOLOCK)
WHERE T0.U_Name='[%0]' )) AND (T1.TaxDate BETWEEN '[%1]' AND '[%2]') 
ORDER BY 
T1.TaxDate for BROWSE

Close the Thread if issue solved

Regards,

Madhan.

[Former Member · Accepted solution]

hi Madhan Babu C

thank all for helping me ..

all of the great

thx

[Former Member · Accepted solution]

how to include BPcode and BPname? I try to include OPCH T2 but it came out a different report.

[Former Member]

hi,

Try this

->> Administration.

->> Financials. -> Financials Reports. -> Accountting. -> Transaction Journal Report.

Else, Try this, Report Query, it will come User Traking_All Activites.

Select CASE T1.[TransType]
       When 20 THEN 'GRPO'
       When 13 THEN 'AR Invoice'
       When 14 THEN 'AR Credit Memo'
       When 15 THEN 'AR Delivery'
       When 16 THEN 'AR Sales Return'
       When 18 THEN 'Purchase Invoice'
       When 24 THEN 'Incoming Payment' 	
       ELSE 'Other...'
       END,
T1.[Number], T1.[TaxDate], T1.[LocTotal] from OJDT T1 where 
T1.usersign = ((Select cast(T0.Internal_K as nvarchar(2)) from OUSR T0 
where T0.U_Name=[%0] )) and (T1.[TaxDate] between [%1] and [%2])

Report,

Madhan.

[Former Member]

Hi,

Option 1:

Use Transactional Journal Report

Go to Financial ->Financial Reports->Accounting->Transaction Journal Report

In this Report is shown the what are the transactions are Booked in the User.

Option 2:

Use the Following Query

Select CASE T1.[TransType]
       When 20 THEN 'GRPO'
       When 13 THEN 'AR Invoice'
       When 14 THEN 'AR Credit Memo'
       When 15 THEN 'AR Delivery'
       When 16 THEN 'AR Sales Return'
       When 18 THEN 'Purchase Invoice'
       When 24 THEN 'Incoming Payment' 	
       ELSE 'Other...'
       END,
T1.[Number], T1.[TaxDate], T1.[LocTotal] from OJDT T1 where 
T1.usersign = ((Select cast(T0.Internal_K as nvarchar(2)) from OUSR T0 
where T0.U_Name=[%0] )) and (T1.[TaxDate] between [%1] and [%2])

*Close the thread if issue solved.

Regards

Jambulingam.P

[Former Member]

Hi!

What u want to know ? Which user is logged in SAP B1 ?

Please explain clearly.