web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Serial number management for Nav & LS Retail

(0) ShareShare
ReportReport
Posted on by 95

My company is installing MS Nav 2009 and LS Retail for finance, supply chain and sales.  We have products that are managed by item serial number, which can be transfered or sold in multiples of 1000, with many transaction per day. This is ok for supply chain but when the transaction is moved to the item legder and value ledger entry tables each line is split out per serial number. So the dbase increases very quickly and creates issues for the dbase size and running inventory avergae costs.

Does anyone have the same issue and how was it managed/overcome?  Currently my developers are saying we have to make new developments in Nav and LS Retail.

Thanks

Mike

*This post is locked for comments

I have the same question (0)
  • Roberto Stefanetti Profile Picture
    12,998 on at
    RE: Serial number management for Nav & LS Retail

    you are right,

    try to recalculate average cost in the night, with a NAS scheduled job (recalculate cost job report)

  • Verified answer
    Rashed Profile Picture
    3,765 on at
    RE: Serial number management for Nav & LS Retail

    If you are doing it for warranty reason, you can setup serial to be only required at the sale time.  So when you purchase and transfer it to store there would not be a need to enter the serial no. This will reduce the Item ledger entries.  

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans