Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Serial No Tracking and...
Small and medium business | Business Central, N...
Suggested answer

Serial No Tracking and Ave Cost Method

(0) ShareShare
ReportReport
Posted on by CILGroup 397

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? 

  • CILGroup Profile Picture
    CILGroup 397 on at
    RE: Serial No Tracking and Ave Cost Method

    No problem thanks for your help on this issue Bilal

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 248 on at
    RE: Serial No Tracking and Ave Cost Method

    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;

  • CILGroup Profile Picture
    CILGroup 397 on at
    RE: Serial No Tracking and Ave Cost Method

    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.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 248 on at
    RE: Serial No Tracking and Ave Cost Method

    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?

  • CILGroup Profile Picture
    CILGroup 397 on at
    RE: Serial No Tracking and Ave Cost Method

    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?

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 248 on at
    RE: Serial No Tracking and Ave Cost Method

    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.

    SN-tracking.PNG

    You can test it and let me know.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans