How can I find the date when the Item or Customer first created in NAV 2009? I know I've last modified date but couldn't find the date created.
*This post is locked for comments
Then you can easily mention to your Nav partner that you need this and they will do it for a small fee.
Or make it a policy in your company that when a new customer is created - they should add the start date in the customer notes.
Or you can create a new flowfield in the customer table Called "First Invoice Date".
Where the fieldclass = flowfield
Where the calcformula = Min("Cust. Ledger Entry"."Posting Date" WHERE (Document Type=FILTER(Invoice),Customer No.=FIELD(No.)))
At least you'll have a date that you can use in reports n such that tells you the first day business began.
Savatage99: Thanks for your reply, Unfortunately I don't have Developers License.
you can add a field to the item. vendor & customer table called start date.
onInsert trigger of these tables you have to add
"start date" := workdate;
you need a dev license to add the code or have your Nav Partner do it for you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
