I have two tables
110 - Sales Shipment Header
111 - Sales Shipment Line
These are huge and I don't need 2003 & 2004 info.
Does anyone see problems with deleting these two years from these tables?
Quickly thanks - I have an ichy finger on the delete button =P~
Thanks.
0
Answers
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
http://www.BiloBeauty.com
http://www.autismspeaks.org
If you are using serial or lots there is another table. I can't remember the name right now.
[edit] Item Entry Relation that relates to sales shipment line.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
We've done this at the request of one installation site back in 2003 and we haven't ran into any problems yet.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
no serial or lots - very very basic
http://www.BiloBeauty.com
http://www.autismspeaks.org
2003 & 2004 I sure hope so - else we're gonna have some upset customers
http://www.BiloBeauty.com
http://www.autismspeaks.org
I'm not sure how it happened, but it does. :?:
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
so I printed them to a phoney printer & deleted the output from the queue.
It generated a 150,000 pages.
My database size went down 10% \:D/
We never use these by the way - it just grows forever.
http://www.BiloBeauty.com
http://www.autismspeaks.org
Of course you would have to analyze each and every key's usage before you start disabling them. The good part is though that if you run into an issue you can easily turn them back on.
RIS Plus, LLC
You could've just removed the code where it tests the No. Printed... Or print to the Microsoft Office Document Image Writer, which by the way, is one of the more unused/unknown tools.
The Sales Shipments are mainly used to print Bills of Ladings. However, if you're using any Lanham products, you can generate teh BOL from the posted invoice.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
We do use Lanham & that's exactly what we do.
http://www.BiloBeauty.com
http://www.autismspeaks.org
I hear ya! that table is a monster
Here are my current keys n info for ILE
http://www.geocities.com/navision_attain/ILE-KEYS.pdf
you guys work saturdays too I see
http://www.BiloBeauty.com
http://www.autismspeaks.org
No, we just have nothing better to do.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book