Search results for query: *

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!

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...

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

Has there ever been any reports of items in the sent folder being auto-deleted to the deleted items? Or a condition that may cause this to happen? I have a user that insists this is happening. AutoArchiving settings are configured to move sent items to the archive file per scheduled setings and...

Has there ever been any reports of items in the sent folder being auto-deleted to the deleted items? Or a condition that may cause this to happen? I have a user that insists this is happening. AutoArchiving settings are configured to move sent items to the archive file per scheduled setings...

I'm upgrading my server using the Ed Crowley method. When I select a public folder to replicate to the new server, the items vanish from my outlook (2000) client. They are there in the public folder resources of the old server (Total K, and Total no. items), but are not visible in outlook...

Is it possible that email does not bounce if the address is bad? Can a server be set up not to bounce? Thanks

I came across this condition while at the 2073a class. Modifying data through views using WITH CHECK OPTION while doing excercise 3 in module 8 prevented updating the supplier id from 14 to 12, as long as it was via query analyzer. When I went into the EM though, I was able to change the value...

Has anyone used a direct thermal printer to print out receiving labels? We are exploring the option of printing out pallet tags using this method. I've created a form that will print 3.5 X 8 (3 Up) labels on a 8.5x11 sheet. We'd like to print them out though on a thermal printer, but I have...

I have an external internet address set up in my system recipient list. When I email a Word document to that address, everything is fine. If I add that address to my personal contacts OR to a contact list in the public folder, and email the same document (addressing it from either contact...

I have created a basic chart to show qty over a 12 month period. I created a moving average as well for it. I use 12 as the order for the avg. When I have data saved, it displays fine. When I switch to design mode though, it crashes. In design mode, there are only three data points shown...

I've set up a public calendar to record 1 hour appointments. I've set the default appt. time to 60 min. BUT... The first time available will be 8:30. I'd like to change the default time display from the top of the hour to the bottom of the hour to better correspond to this type of appt. I've...

I am trying to create two tables via a stored procedure, RECEIVED and DISTRIBUTED. Then use those tables as part of a crystal report that compares those tables with an existing table. The stored procedure will be crystal data source. Problem is the stored procedure needs to delete existing...

I am currently suffering the load error 179 on my Citrix XPa farm after upgrading Win2k to sp3. Have tried all the reg hacks etc. to minimize the errors, but they still appear. Re-booting nightly seemed to really minimize the frequency, but still a problem. Rolling back to sp2 is not an...

We have been using public folder calendars to maintain appointments. Due to several complex filters on start/stop dates, the re-curring feature does not work correctly, so we copy future appts using CTRL and drag & drop. However, various appointments that have been previously copied are now...

I am trying to create a report to tally the results of a survey. It comprises 30-40 questions with up to 9 different responses. I am just looking to count up each response to each question in the least painful way. Am I doomed to 30*9 running totals? Thanks for any input!