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!
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...
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...
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...
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...
Yes, the report says it will purge records from iminvtrx and imbintrx as well if the show bin is checked. What I wanted to do is leave iminvtrx intact (since there is a lot more info from other sources besides bin trx) but just purge records in imbintrx.
Is this an advisable thing to do? ie...
I've got the IMBINTRX_SQL file getting a tad big, but cannot find any reports that would allow me to spool/delete them.
Is this a job for ISQL?
Thanks in advance for any help.
Chris
I had found some remnants of a palm pilot installation still running on the machine in question. Namely Hotsync and the chapura conduit on outlook. I have removed those and am just monitoring it to see what happens.
The settings on the blackberry were ok and are the same set on all the...
The tick mark to save a copy to sent items is checked. No filters applied that I can see.
The weird thing is that the sent items is mostly empty except for a couple msgs, and the rest of the items are sitting in the deleted folder.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.