How to find a list of Item and Vendor Creation Dates in Navision 2018

(0) Share

Report

Posted on by Lovisa LH

Hello helpful colleagues

I need to find a list of new suppliers and new items for 2021 in Navision 2018, ie the item card and its creation date.

I have seen several blog posts for earlier versions noting similar requests, and I think its possible to find this info either through Change Log Entries, or to set this up by adding a field to the table in the Development environment. Am I on the right track?

I hope that someone can give up to date advice on the best way to find this information, or how to set it up in NAV 2018. I do have a Developer Licence but am a complete beginner.

Thanking you in advance!

Louise

Below relevant blogposts

https://stackoverflow.com/questions/42033313/is-there-a-way-to-pull-vendor-creation-date-in-dynamics-nav-2016

I have the same question (0)

All responses (15)

Answers (1)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Hi,

Lovisa, can you first check in table 27 is there any field available Date modified or similar? I don’t have installed nav 2018 version but might be this field is already there if yes you can reuse that to solve your query otherwise please create a new field Modified date and whenever you insert or modify this table record please put a date after writing below code on Oninsert trigger and Onmodify Trigger.

Also if would have enabled log setup you can find date and user id who and when that particular record modified.

let me know if this the answer of your question

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Dear Nitin,

Thank you for your reply! I checked table 27 and I found nothing that could answer the query there

Could I ask you to explain more clearly about how to create a new field, or to find out if I have enabled log setup?

Thank you!

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Hi Lovisa,

Please search "Change Log Setup" in search field, and Activate the boolean field as per below image. After enable it, Click on Table button as per image and defined your table, in my case its a Table 27 (item) and choose your desire option as per second image.

now go to the Change Log entries page and find the log after modify anything on the Item card, see Image 3

With the above case there is no need to do any development.

Image 1

Image 2

Image 3

Hope it will help you.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

So per your image, we have Last Date Modified date and time fields, by using that you search when the records has been modified.

It will also help you.

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Dear Nitin

Thank you for the more detailed reply.

I checked steps 1 and 2, and my Navision is set up this way.

However regarding step 3, I don't understand how this solves my problem.

What I need to find is a list of Items and item numbers that we have in NAV, and the date that the Item Card was created.

Then I can get a list for the auditor of new items created in March 2022.

Does Change Log Entries Show that information?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Hi,

Since you have already a last date modified field so you can develop a list type report and filter with this field by putting the March month filter it will give the results of all the items.

Thanks

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Hi Nitin,

I still don't understand; I need to know date the item card was created, not date last modified.

Do you mean that in Change Log Entries Log Insertion means that a user has created an Item Card? Where do I see the item number?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Ok do one thing create a new item card with all dummy details and the. Find that field value it must be there when anyone creates a new record

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Hi Nitin,

That's just the thing, it seems that this info is not recorded.

Take a look at these answers -

community.dynamics.com/.../97493

stackoverflow.com/.../is-there-a-way-to-pull-vendor-creation-date-in-dynamics-nav-2016

I think it might be possible t find the item cards and the'r creation dates in Change Log, but I don't exactly know where

or

it's necessary to add a field to the table, which I would also need guidance on how to do

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to find a list of Item and Vendor Creation Dates in Navision 2018

Hi,

Create a new field with 50000 id let’s say field name “date created” with Date data type and oninsert trigger and Onmodify trigger add below code of the table.

“Date created “ := Today

Please check this.

Was this reply helpful? Yes No