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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
Deleting "Sales Shipment Lines" where quantity =0
khalilchahin
Member Posts: 25
Hello NAV Developers,
I have large "$Sales Shipment Line" table and upon investigation I found out that there are huge amount of records where Items exist in this table has :
Quantity =0 and "Quantity Invoiced" = 0 and "Qty Shipped Not Invoiced" =0
so I am just wondering if I can delete these records from SQL Management Studio using this command?
Delete
FROM $Sales Shipment Line
where $Sales shipment line].Quantity = 0
AND $Sales shipment line].[Quantity Invoiced]=0
AND $Sales shipment line].[Qty_ Shipped Not Invoiced]=0
AND $Sales shipment line].TYPE= 2 //this is to filter on Items only.
if you have any thoughts please share it with me .
I am looking to find answers on why NAV creates these records on the first place? any financial or inventory consequences will be created upon purging these records.
I appreciate your feedback.
Khalil
I have large "$Sales Shipment Line" table and upon investigation I found out that there are huge amount of records where Items exist in this table has :
Quantity =0 and "Quantity Invoiced" = 0 and "Qty Shipped Not Invoiced" =0
so I am just wondering if I can delete these records from SQL Management Studio using this command?
Delete
FROM $Sales Shipment Line
where $Sales shipment line].Quantity = 0
AND $Sales shipment line].[Quantity Invoiced]=0
AND $Sales shipment line].[Qty_ Shipped Not Invoiced]=0
AND $Sales shipment line].TYPE= 2 //this is to filter on Items only.
if you have any thoughts please share it with me .
I am looking to find answers on why NAV creates these records on the first place? any financial or inventory consequences will be created upon purging these records.
I appreciate your feedback.
Khalil
0
Comments
Just to give you my feedback on this issue that I posted.
I delete all records from Sales shipment lines table where quantity =0.
1- These records were created due to a bug in NAV customization when posting shipment.
2- I tried this deleting in the test system and didn't have any impact on financial or chart of accounts since quantity and amounts were zero.
this shrank the database dramatically and freed space on the server.
Thanks
Khalil
It is not a bug. NAV has always done that for record-keeping.
If I remember correctly, I did the same thing : removing those records in NAV 4.0 SP3. No problems encountered. And it shrank the table a lot!
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!