Recent content by Clundey

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

Is it possible to prevent Macola from creating backorders at all? The nature of our business is such that they are not needed, and are a nuisance to clean up after the invoices have been posted. Thanks in advance for any insights!

Browneye You can get the 32bit media for SQL 2005 through eopen.microsoft.com. Chris

Thats a much better idea! Thanks a lot!

Thanks Peter, the function is there, and it works. However, I needed to duplicate items by product category and item wgts, not just item number sequence :( I was thinking of just writing an update sql stmt that would change the loc field for the selected items. What is the impact of having...

I am creating a new location within the warehouse. I have a LOT of items that I need to 'move' from one location to the new one. Inventory transaction>transfer says "Item not stocked at this location" when I try transferring the items because I did NOT create item first in Item/Loc...

I'm using Office 2003 and want to do a mailmerge in Word with Excel data. I click the "Open Data Source" button and select *.xls for type of file. Browse out to the .xls data source. (First row=header, etc) and select it. But instead of getting the "Select Table" requester with the list of...

Re-installing the sql client tools took care of the problem. Thanks abaldwin!

I can no longer add, edit or delete users via Visual Menu Builder to SQL 2000. Been getting "Error during removelogin, automation error, library not registered" when deleting. "Setting Database rights failed 0" when modifying, and "Adduser-1 username: password: Add to sql failed" when adding...

thanks for the advice! One of the mods we have is on the OE line item. (It is to prevent over-shipping) What is the bug ?

POP orders only. Am looking at upgrading, but have several VBA customizations in place, and things have been VERY stable.

We are looking into manufacturing item(s) that consist of 1 component. This component will never change. The items we are "manufacturing" are simply food items that are sorted out of the "component" item and put into boxes. The "manufactured" items will be treated as cases, where the...

I'm using MS SQL. There are 1.2M records in the bin table.

The IMINVTRX contains data from other modules that I'd prefer to hang on to. I don't need the bin transactions as much as the other stuff. Percentwise, I have more bin trx's than anything else, so I want to get rid of them to get the db smaller.

Thats what I found out. I'd like to keep the IMINVTRX records, but just prune out the IMBINTRX table. I'm on SQL so it wouldn't be a big deal to do this. The bin trx records are not as critical here as the data in IMINVTRX. I'm just concerned about any possible orphan records created...