Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deleting "A" records in IMINVTRX

Status
Not open for further replies.

Clundey

Technical User
Jul 20, 2001
42
US
Is it safe to delete these allocation records from the IMINVTRX_SQL table as long as the orders have been posted and nothing is currently in the open order table?

I'm using SQL Server 2000 for a db.

Thanks in advance.

Chris
 
My vote would be yes, as I have written script to just do this, it would delete all allocation records. Then later run reset allocations.
When post invoices, the process actually deletes the allocation record, I have seen once or twice where you will not be able to post an order because the allocation record was missing. But again the solution was to run reset allocations.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top