field where the name of the user who mode an order is stored

tomdepoorter

Hi


I'm using NAV since a few months now.

A few days ago an enduser came to me
and asked if he could filter all the orders he made.

I started to look for a field in the table "Sales header"
but I didn't find such a field.

So there is no solution for his question?


Best regards

Tom Depoorter

vijay_g

No, you can't find creation userid in document this have only tracking for posted document.

You can add a field "Created By" and add code in oninsert trigger of 36 table.

"Created By" := USERID

tomdepoorter

thx for your quick reply Vijay.

I thought it was a best-practice to provide those fields in a program.
Do you know of that field will be a default field in the next version?


Best regards

Tom

Savatage

It hasn't been a field for as long as I know, so I see no reason they would add it now.

There is no sure way to guarantee that the person who f3'd to get a new order number is the person entered(created) the order. all it does it show who create the order number.

There just might be an open number that someone decides to use.
You can create different number series per order entry user also as a way to determine who "created" the order.

plus if you really need it - the code is so simple (as seen above) that your solution center can add it in seconds.

ufuk

Or you can activate Change Log to see who creates or modifies that record. (Be aware of performance issues)

vijay_g

Savatage wrote:

plus if you really need it - the code is so simple (as seen above) that your solution center can add it in seconds.

:thumbsup: