Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 389

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 389 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 45 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 389 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 45 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 389 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 45 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans