You’re offline. This is a read only version of the page.
Announcements
Hi,
We have discovered an issue with serial number tracking in NAV 2016 when we use it for items set up with average cost.
If an outbound document (i.e. Transfer Order, Sales Order) is raised for an item and a serial number is selected from the available list, if you have 2 or more item in inventory and you leave the APP.-TO ITEM ENTRY to 0, no matter what serial number you have selected in the list the outbound entry that gets linked to is the oldest item ledger entry with a remaining amount > 0 therefore does not take into account at all the serial number you selected?? The user therefore has to manually select the APP.-TO ITEM ENTRY in addition to selecting the serial number from the list.
Is there any way without modification to have it so that the serial number selected is the inbound item ledger entry that is automatically selected when dealing with ave cost items?
Hi,
No developer approach is to create new 41 items with information same as original just update Item Tracking Code to newly setup with SN Specific tracking. Then adjust the Inventory by making negative adjustment in old to make zero there and positive adjustment in new items with same quantity. This is better way to solve it.
Developer approach to modify simply without running OnValidate trigger. e.g. if we want to change it for Item 80216 we need to execute below lines.
Item.GET(80216);
Item."Item Tracking Code" := 'SNSALES';
Item.MODIFY;
Ok thanks for clarifying that.
We have 41 items that need to be switched to SN Specific Tracking.
Is there any process we can follow or must we get developers involved?
We like to keep modifications to a minimum where possible.
Hi,
If you use costing method SPECIFIC then it is mandatory to use SN Specific Tracking but you can use SN Specific Tracking without SPECIFIC as costing method.
For how many items you need to change this?
Hi Bilal,
Thanks for your quick response!
I just did some testing and you are correct, with SN SPECIFIC TRACKING on the entries are correctly matched/applied.
We were under the impression the you could only use SN SPECIFIC TRACKING when the items costing method were also set to SPECIFIC. The item I test it on was set to Average so looks fine.
Now we have a problem where we can't modify the existing items tracking code to include this option as we get an error saying existing item ledger entries exist. Even if I journal out the item inventory we still can't update that field?
Any suggestions on how to get around this?
Hi,
I have gone through the case you describe above. If you are even using Average Costing Method and you are specifying Serial No. then item related to this Serial No. should be picked and its related item ledger entry should be applied.
May be you need to check the Item tracking setup again. Open the Item tracking codes page and open the Item tracking code attached to that item. See if the SN Specific tracking checkmark is true.
You can test it and let me know.
#1
André Arnaud de Cal...
293,514
Super User 2025 Season 1
#2
Martin Dráb
232,594
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
