RE: What is the limit of row in Item table ?
Dong,
I want to add onto what Steve has written. I have, in my 21 years implementing NAV/BC, had maybe 2 customers who stated we have over 750,000 Items. I know there is no limitation creating the 1.5 million items. What would be my concern is the processing, productivity, and administration. Steve's replied noted you should identify purchased and sold Items in the last 12 months. I have used 24 months in all my implementations. In fact, I recently did one for a clothing manufacturer who had almost 480,000 Items, of which a 1/3 were discontinued.
I am not sure if you are a distributor or manufacturer or both but you need to segment your 1/5 million Items into groups:
1. Discontinued - Meaning you are not purchasing them or manufacturing them
2. Purchases and/or Sales made within the last 24 months
3. Future Items to be sold in the upcoming Year/Season
One thing to consider when loading such a large number is that if you did bring 1.5 million Items into BC, you would have to use filters off the Item List and in a Configuration Package for export or editing in Excel. This is because Excel has a limit of 1048576 rows.
One last note, I am a big proponent of Vendor Catalog and Pricing and Steve's recommendation to use the Vendor Catalog is a must and I always implement this for all my customers. It is a great feature and help immensely with PO entry.
Hope this helps.
Thanks,
Steve
