Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Sales Shipment Header & Lines
Savatage
Member Posts: 7,142
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.
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
MVP - Business Apps
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