Sales Shipment Line Table is taking huge space on SQL server

Comments

• Options

  davmac1 Member Posts: 1,283

  2015-05-01

  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.

  David Machanick
  http://mibuso.com/blogs/davidmachanick/

  0
• Options

  khalilchahin Member Posts: 25

  2015-05-01

  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

  0
• Options

  davmac1 Member Posts: 1,283

  2015-05-03

  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.

  David Machanick
  http://mibuso.com/blogs/davidmachanick/

  0
• Options

  navuser1 Member Posts: 1,329

  2015-05-04

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

  Now or Never

  0
• Options

  khalilchahin Member Posts: 25

  2015-05-04

  Thank you for your reply.
  
  Would you please provide me with more info with regards using NAV GUI to delete "sales shipment line"?
  
  Khalil

  0