Item tracking - Automated creation of Item Tracking Lines

Torben
Member Posts: 21
Hi all
I order to ensure that the right lot of purchased items is used when using subsequent transferorders, I am considering using Item Tracking
So, I go to the PurchOrderlines, itemTrackingLines and key in the LOT info. (And yes, I have entered Item Tracking Code on the items)
When I need to move the items using transferorders, I again go to Lines, Item Tracking Lines and key in the info
:-k It must be possible to automate this keying in. As we are talking many purchorderlines, tha manual job can take some time!
The LOT nr I intend to use (Supplied to me from the vendor) is actually also present on the PurchOrderHeader and om the TransferOrderHeader.
This LOT nr should apply to all lines on the PurchOrder/TransferOrder
With the lot nr present it should be somewhat "easyer" to automatically create some tracking lines to the PurchOrder and TransferOrder.
Inspecting form 6510 Item Tracking lines, which uses a lot of code on the form :shock: it seems rather difficult to simulate keying in the data into the recs
:?: So, any suggestions on how to automatic generate the ItemTrackingLines to PurchOrder and TransferOrders, would be greatly appriciated !
Best rgds
Torben
I order to ensure that the right lot of purchased items is used when using subsequent transferorders, I am considering using Item Tracking
So, I go to the PurchOrderlines, itemTrackingLines and key in the LOT info. (And yes, I have entered Item Tracking Code on the items)
When I need to move the items using transferorders, I again go to Lines, Item Tracking Lines and key in the info
:-k It must be possible to automate this keying in. As we are talking many purchorderlines, tha manual job can take some time!
The LOT nr I intend to use (Supplied to me from the vendor) is actually also present on the PurchOrderHeader and om the TransferOrderHeader.
This LOT nr should apply to all lines on the PurchOrder/TransferOrder
With the lot nr present it should be somewhat "easyer" to automatically create some tracking lines to the PurchOrder and TransferOrder.
Inspecting form 6510 Item Tracking lines, which uses a lot of code on the form :shock: it seems rather difficult to simulate keying in the data into the recs

:?: So, any suggestions on how to automatic generate the ItemTrackingLines to PurchOrder and TransferOrders, would be greatly appriciated !
Best rgds
Torben
0
Comments
-
Hi,
The data on the form 6510 Item Tracking lines come from table 337 Reservation Entry.
The Tracking Specification table on the form is used to show temporarily the data and accept your input.
You could enter the specification you want by hand, inspect the table 337 for that entry, and then write your code to auto-insert your LOT no. specification for every line in your Purchase Order.
You should also keep in mind the Assign Lot No. code that is in the menu item, which creates a Lot number for you and assigns the quatities that you have entered. So you could use that code too...
The application uses the same logic for the transfer orders too...
I hope I helped you...0 -
You could also look at the:
http://www.mibuso.com/forum/viewtopic.php?t=37870 -
Thx for the input. I will take a closer look right away.
Best rgds
Torben0
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