Deleting "Sales Shipment Lines" where quantity =0

khalilchahin

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

khalilchahin

Hello everyone,

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

kriki

A little late, but..

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!