Item expiry date calculation
krvenkata
Member Posts: 154
Hi
I had created an item in item card with Item Tracking code as EXP and in the expiry date calculation, i had given the value as 1Y (1 year).
Now in the sales order, when i went to the item tracking lines, i can see the expiry date disabled with blank. I am not getting the expiration date populated based on the date.
How to do it or should i be able to enter the expiration date manually? Am i doing the correct process?
I am sure that unless the expiry date is populated, we will not be able to replenish the stock of FEFO basis? Can anyone handled expiry of items? If yes, can you let me know the process of doing it?
I had created an item in item card with Item Tracking code as EXP and in the expiry date calculation, i had given the value as 1Y (1 year).
Now in the sales order, when i went to the item tracking lines, i can see the expiry date disabled with blank. I am not getting the expiration date populated based on the date.
How to do it or should i be able to enter the expiration date manually? Am i doing the correct process?
I am sure that unless the expiry date is populated, we will not be able to replenish the stock of FEFO basis? Can anyone handled expiry of items? If yes, can you let me know the process of doing it?
0
Comments
-
My memory tells me this is the expiry date of the item inbound. As theoretically this is not necessarily "your" expiry of the outbound transaction when you issue it you need to defne it manually. Navision also does not issue stock on a FEFO basis, although this is in version 5 (5.1?) I believe, so maybe expiry on outbound transactions is as well.The art of teaching is clarity and the art of learning is to listen0
-
The whole purpose of entering the Expiration date in Inbound transactions is to issue materials on FEFO basis during sales transaction. If that is missing, what is the fun in entering during receipt. Is it only to take item expiry report.
Atleast there should be a provision during sales to display the items on expiry date basis, so that the user carefully picks it.
Any solution available. I am trying in NAV 5.0, still its not working.0 -
What there should and should not be in Navision is a bone of contention - one thing I can assure you of is prior to 5 there is no concept of issuing outside of the financial arena - so you cannot issue on first expiry.
Of course the beauty of Navision is you can easily make it do what you want, so you will need to develop your solution to "pick" on earliest expiry (not easy to do automatically I am sure) but also display the expiry dates during the sales process (which should be easy) and of course putting the inbound date on the outbound transaction.
Don't shoot the messenger
The art of teaching is clarity and the art of learning is to listen0 -
Thanks a lot....
Not my real intention to do so
0 -
In "What’s New in Microsoft Dynamics NAV 5.0 − Application Part II" you can find some more detail about FEFO for sales picking. Look into chapter I concerning Item Tracking.
You can get this document if you have access to partnersource or customersource0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 329 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