Expiry Date Calculation Formula

jaiverma2k2
Member Posts: 112
Hi All,
I required a item wise Expiry date calculation formula.
On item i created a Item Tracking Code
In Expiration Calculation i put 36M, but system not calculating the expiry date,
please suggest, what is missing.
Regards,
Jai Verma
I required a item wise Expiry date calculation formula.
On item i created a Item Tracking Code
In Expiration Calculation i put 36M, but system not calculating the expiry date,
please suggest, what is missing.
Regards,
Jai Verma
Regards,
Jai Verma
Jai Verma
0
Comments
-
Did you try +36M?Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
I've try +36M but still the expiry date is not populate.
i'm trying this in Item Jounal, i just put the Positive entry, enter the quantity and then entering the Lot no.
Lot. No. series is mapped with item.
Manufacture Date is also entered manually (is there any way so the documate date is populate as mfg. date), then as per mfg. date system should populate the Expiry Date.
Still the Expiration Date is not populating.
Please suggest.Regards,
Jai Verma0 -
I believe the Expiration Date in the item journal has a different meaning then on the item card.
Read this...
Expiration Date Field
The Item Journal Line TableEnter the last date on which the recurring journal will be posted, if you have indicated in the Recurring field of the journal template that the journal be a recurring journal.
The field determines the date on which the line will be posted for the last time.
By using this field you can enter a line in the journal even though it will only be posted for a limited period. The line will not be posted after the date shown in the field.
The advantage of using the field is that the line will not be deleted from the journal immediately and you can always replace the present expiration date with a later one so that you can use the line further into the future.
If the field is blank, the line will be posted every time you post until it is deleted from the journal.0 -
Expiration Date NOT in the Item Journal, in Item Journal i just putting the Positive Entry.
i'm talking abt the Expiration Date in Item Tracking LineRegards,
Jai Verma0 -
jaiverma2k2 wrote:I've try +36M but still the expiry date is not populate.
i'm trying this in Item Jounal0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions