EXPIRY DATE issue

edwinskie

Is it possible to have a EXPIRY DATE option that we may use in navision3.7 since our products also involves quality issue?

easabangan

I think it is possible, but there are lot of things that should considered.

johnson_alonso

If you need to implement expire date, you can implement it per item in the expiration calculation field on the item tracking tab in the item card.
Is that what you need ?


rgds,
Johnson Alonso

"fight fire with fire"

edwinskie

yes johnson,

During item receiving, we would want also to enter the product expiry date in the system for traceability purposes.

salamat!

kine

1) You must use Lot No. or Serial No. to be able to enter Expiration Date on Purchase...
2) If you enter the item which have the item tracking, open the Line - Item Tracking Lines. In this window you can Unhide the column Expiration Date or Waranty Date
3) This date is transfered into Item Ledger Entry.Expiration Date

johnson_alonso

Hi edwin,
Your indonesian is okay. how can you understand and where do you learn ? Are you live in the south of philiphines ?
As about expire date, you could simple write 5y in the field, it means 5 years, if the field located on the item tracking tab, it means you need to apply item tracking features. It relates to inventory management.
The item tracking setup consists of three elements:
∙ Item Tracking Codes Setup: An item tracking code defines which item
parameters (serial number, lot number, or both) the program will use to
track the items and in which operational areas.
∙ Serial and Lot Number Setup: When a company wants to assign serial
and lot numbers to items automatically, it is necessary to set up
number series that the program will use. The process of setting up
these number series is similar to that of other number series and is part
of the General Ledger Setup.
∙ Item Setup: To be able to track a specific item, a company must first
set it up for item tracking by applying a particular item tracking code.
The setup may also include a serial/lot number series and expiration
formula

hope the explanation more clearly and suitable for you.


rgds,
Johnson Alonso

"whenever I may roam"

gerardschipper

Within Navision 3.7 HF 17 you will notice that the expiry date is not transferred to the posted item tracking lines, the code is simply missing within the posting routines. This issue has been solved in versions 4. If you send me your e-mail address I will send you a set of patched objects.

Regards,

Gerard

jreynolds

A problem with expiration date is that it is calculated and stored with each item ledger entry (based on the posting date and the expiration calculation for the item). Therefore, it is possible to have several item ledger entries for the same lot all with different expiration dates. With Strict Expiration Posting turned on this can be a problem because the sale may be applied against several item ledger entries some where the expiration date is OK and some where it isn't. I would recommend storing the expiration date with the lot information record (table 6505) and modifing the checking logic in codeunit 22 to use this expiration date rather than the expiration date on the item ledge entries.

apickard

Is it possible please to help me with the below,

I am trying to setup Item Tracking codes to items which have entries already posted in Item Ledger (such Items were not set to use Item Tracking). The system is giving me an error - "You cannot change Item Tracking Code because ledger entries exist".

Is there any easy way to setup Item Tracking codes for these items?

Thanks for your help