Sales Shipment Line Table is taking huge space on SQL server

khalilchahin

Hello everyone,

The "Sales Shipment Line" table is taking huge space on the SQL server ( more than 160 GB). and it has data on it since 2008 ( shipment date).
Any best practices of how to reduce the size of this table?
or info with regards deleting old data from this table . does this have any affect on other tables?

Appreciate your feedback.

Khalil

davmac1

well it is obviously tied to the sales shipment header.
The sales shipment header delete trigger deletes all associated records.

It will take a long time to delete that much data using NAV, so you will want to test it a small range and see how long it takes.

You should look at the size of your other tables as well.
Also consider carefully what and how much you want to purge.

khalilchahin

Thanks David for your reply. but I just want to be clear on it.
Do you think that deleting data from Sales Shipment Line table might have any side effects on Inventory , or any other tables in NAV?

Let me know please.

Thanks

Khalil

davmac1

I think if your purge program does not purge any shipments that are still in sales orders, you will be fine.
If you want to have some of the accounting experts look at your question, you should re-post your question with the heading - "Will deleting old sales shipments affect G/L or Inventory?"

If your sales shipment line table is so large, how big is your sales invoice line table?
I would expect it to have a similar size unless someone has already purged it.

navuser1

Use NAV GUI to delete old Sales Shipment, other wise you have to delete it's related info ( comment line, dimension, etc..) manually.

khalilchahin

Thank you for your reply.

Would you please provide me with more info with regards using NAV GUI to delete "sales shipment line"?

Khalil