Dynamics User Group

Dear all,

I have to make a report that how many entries a user did per day(not posted entries) in Journals i.e. Total entries of a user per day

What code is required for that ? and which tables ?

Has your system been modified to maintain that information?  The standard database does not store that information.  Therefore that report is not possible.

This information is stored in Gen. Journal Line table.

i.e. all the entries which are not posted yet, are stored in Gen. Journal Line table.

 Hey dear,

Actually I work in Ax, but I think the principles are common.

As what I understand you would like to show how many transaction somebody enter in particular day - even you can get it within period.

any how all the vouchers entries and transaction are stored in the table "LedgerJournalTrans" whatever they are posted or not.

that table has many important fields:

- JournalNum: - LineNum: - AccountType: - AccountNum: - Company: - Dimension: - Qty: - Price:- Voucher:- ApprovedBy 

and much much information.

any how I think which will be useful for you are  these

 - JournalNum: Journal Number

 - AccountType: Customer, Bank, Assets (so you can choose one type)

 - Company: Choose a company in case your system is inter-company.

 - Price: So you can get the total transaction.

 - ApprovedBy: So you can filter by the name of the responsible, or group it up for each responsible.

So as you see you just to create a wizard report, and make the table "LedgerJournalTrans" as datasource, and give some ranges depend on your need.

I hope I understand your question and I gave you what you need.

Mohammad Sallout:

...any how all the vouchers entries and transaction are stored in the table "LedgerJournalTrans" whatever they are posted or not.

...

Is that a custom table or unique to a specific localization?  I'm not familiar with that table.  Could you provide the table number?  It does not appear to be part of the WW or US versions.

babrown:

Mohammad Sallout:

...any how all the vouchers entries and transaction are stored in the table "LedgerJournalTrans" whatever they are posted or not.

...

Is that a custom table or unique to a specific localization?  I'm not familiar with that table.  Could you provide the table number?  It does not appear to be part of the WW or US versions.

 

Mohammad Sallout:

As I said I worked with Ax so, you may find some difference with the name, but it is table of ledger transaction, it should be some thing close.

Sorry, missed that part.  Reading too fast this morning. (or not enough coffee)

Anyway that feature does not exist in NAV.  I do NAV development but am also a user of AX.  These products can be quite different.  Don't assume a common feature set between the products.

babrown:

Anyway that feature does not exist in NAV.  I do NAV development but am also a user of AX.  These products can be quite different.  Don't assume a common feature set between the products.

I think you know better,

It is just a "try to help" and I'm not sure about.

 Thanks for your note.

But I hope you drink well next time,