mibuso.com

Microsoft Business Solutions online community
It is currently Fri May 24, 2013 5:12 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 18 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: How to create Item Tracking Lines automatically?
PostPosted: Mon Apr 13, 2009 12:26 pm 
Offline

Joined: Fri Aug 31, 2007 10:13 am
Posts: 135
Location: Tbilisi
Country: Georgia (ge)
Is there any way to create Item tracking lines automatically??
thanks a lot

_________________
MCSD
Attain Navision


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Mon Apr 13, 2009 1:06 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Feb 03, 2006 10:15 pm
Posts: 2272
Location: Houston, TX
Country: United States (us)
I've had a few posts on this. Search the forum and you should find them. You can start in the Reservation Management codeunit.

_________________
Matt Traxinger - ArcherPoint
Microsoft Dynamics NAV 2009 Programming Cookbook
Do you have an idea to improve NAV? Submit it at I Love NAV


Top
 Profile  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Mon Apr 13, 2009 2:37 pm 
Offline

Joined: Fri Aug 31, 2007 10:13 am
Posts: 135
Location: Tbilisi
Country: Georgia (ge)
I need to create Item tracking lines automatically when sales order is created...
thanks again for your post..

_________________
MCSD
Attain Navision


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Tue Apr 14, 2009 12:25 am 
Offline

Joined: Tue Jan 02, 2007 6:12 pm
Posts: 90
Location: Ontario
Country: Canada (ca)
Look at codeunit 99000830
The functions you will want to use are CreateReservEntryFor and CreateEntry


Top
 Profile  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Tue Apr 14, 2009 9:40 am 
Offline

Joined: Fri Aug 31, 2007 10:13 am
Posts: 135
Location: Tbilisi
Country: Georgia (ge)
I turned on Reserve on every item card to Always.. But after Whse.Shipment is created and Pick is created and registerd, we need to post the shipment, but it says that , Lot No. is required for particular Item. In my case I need to assign lot no automaticaly when Sales order is created.. And I need your help :) How this is possible?

_________________
MCSD
Attain Navision


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Tue Apr 14, 2009 10:04 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Jun 27, 2007 9:53 am
Posts: 1281
Location: Southampton
Country: United Kingdom (uk)
The system does not contain this functionality as standard, so you cannot set it up to achieve this. You need to write a modification to fit your needs, and hence the previous suggestion to search the forum for this request previously as it has been discussed on a number of occassions with different requirements.

_________________
The art of teaching is clarity and the art of learning is to listen


Top
 Profile  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Tue Apr 14, 2009 10:12 am 
Offline

Joined: Fri Aug 31, 2007 10:13 am
Posts: 135
Location: Tbilisi
Country: Georgia (ge)
So as I found out, codeunit - Create Reserv. Entry contains a function "CreateWhseItemTrkgLines"..What if I create Item Tracking Lines from Reservation Entry Table? Does it sound like a near to solution stuff?

_________________
MCSD
Attain Navision


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Tue Apr 14, 2009 3:25 pm 
Offline

Joined: Thu Oct 30, 2008 10:38 am
Posts: 987
Location: Earth
Country: Netherlands (nl)
I've been working on automatic Item tracking for a couple of months now.
First, no that doesn't sound like a near solution.
Second, get yourself a nice testing environment
Third, start to study the reservation entry table, item tracking table, the codeunits, ...
Map it out, create use cases, learn the flow of the code and then start to automise it.
And sorry no, I can't give you those.

In short, it is possible, but it takes a while if you don't have the knowledge.

_________________
|Pressing F1 is so much faster than opening your browser|
|MCBMSS: 5.0 intro|MCTS:NAV09 839..841|JetReports© Certified Specialist|
|Dynamics Anywhere: Mobile Business Solutions|


Top
 Profile  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Tue Apr 14, 2009 3:51 pm 
Offline

Joined: Fri Aug 31, 2007 10:13 am
Posts: 135
Location: Tbilisi
Country: Georgia (ge)
Sog =;

thanks a lot..

_________________
MCSD
Attain Navision


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Tue Apr 14, 2009 5:01 pm 
Offline

Joined: Thu Oct 30, 2008 10:38 am
Posts: 987
Location: Earth
Country: Netherlands (nl)
I'm just warning you that it is a lot of work to automise item tracking.
I know it is not the answer you were hoping for, but in my experience it's a lot of work and swearing.
I hope for both our sakes that somebody will post here saying, hey it's not that hard, you only have to do this and this and it works. Alas I fear that nobody will have that answer.

_________________
|Pressing F1 is so much faster than opening your browser|
|MCBMSS: 5.0 intro|MCTS:NAV09 839..841|JetReports© Certified Specialist|
|Dynamics Anywhere: Mobile Business Solutions|


Top
 Profile  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Tue Apr 14, 2009 7:08 pm 
Offline

Joined: Tue Jan 02, 2007 6:12 pm
Posts: 90
Location: Ontario
Country: Canada (ca)
use codeunit 99000830. Here is a snippet of code that I used. All you would have to do is pass your own parameters and enter an applicable Lot No. for SomeLotNo. You can also do this for serial numbers.

Code: Select all
CreateReservEntry.CreateReservEntryFor(
  DATABASE::"Sales Line",
  SalesLine."Document Type",
  SalesLine."Document No.",
  '',
  0,
  SalesLine."Line No.",
  SalesLine."Qty. per Unit of Measure",
  ABS(SalesLine.Quantity),
  SomeSerialNo,
  SomeLotNo);

CreateReservEntry.CreateEntry(
  SalesLine."No.",
  '',
  SalesLine."Location Code",
  SalesLine.Description,
  0D,
  SalesLine."Shipment Date",
  0,
  3);


Top
 Profile  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Wed Apr 15, 2009 10:55 am 
Offline

Joined: Fri Aug 31, 2007 10:13 am
Posts: 135
Location: Tbilisi
Country: Georgia (ge)
Okay, thanks for your help... And I've made the following: The field on Item Card RESERVE: chnged to ALWAYS for each item, and after sales line is created Items are reserved automatically.. But the problem is, when I open Reservation Entries from Sales order form , there's a line , but Lot No is blank.. In Reservation entry table negative lines appear with no Lot No. When I'm assigning Lot Nos manually, everithing goes well, with shipment posting and etc.. So is that a key to assign Lot Nos manually in Reservation Entry table?

_________________
MCSD
Attain Navision


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Wed Apr 15, 2009 3:07 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8701
Location: 3rd rock from sun
Country: United States (us)
The reservation entry is used for mulitple purposes. One is reservation.
Second it also stores tracking lines (Lot Serial).
It is also used by MRP to track all the demand and supply in NAV.

I suggest to use the code provided above otherwise you have to specify what you shipping. The whole point of lot tracking is so that you actually scan what you ship so you know what lot it came from. So when you need to do a recall you can recall the whole lot.

Why are you using lots to begin with if you don't care what you sell?

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Thu Apr 16, 2009 5:32 am 
Offline

Joined: Tue Jan 02, 2007 6:12 pm
Posts: 90
Location: Ontario
Country: Canada (ca)
Becka, you still have to pass the Lot No. you want to use to the function CreateReservEntryFor. Otherwise there will be no Lot No.

But I agree with Rashed. Why do you want to use Lot control if you don't care what you sell? And remember, the Lot No. you use has to have availability; you can't use just any arbitrary Lot No.


Top
 Profile  
 
 Post subject: Re: How to create Item Tracking Lines automatically?
PostPosted: Thu Apr 16, 2009 9:33 am 
Offline

Joined: Fri Aug 31, 2007 10:13 am
Posts: 135
Location: Tbilisi
Country: Georgia (ge)
In my case, when i reserve Items, It creates positive and negative lines in Reservation Entry. In the case of positive line there's right Lot No assigned, but in negative line Lot No is blank.. All i have to do is assign right Lot No to Negative line. I think it sounds like an easy solution.. what you think guys?

_________________
MCSD
Attain Navision


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 18 posts ]  Go to page 1, 2  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 18 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: