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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ZulumanatSPI

  1. ZulumanatSPI

    Lock Up When Adding Table To SQL Search In IM

    DG, I think if I tried this again, my IT guy would hang me upside down by my ears and kick me to the curb like a bad Novell server. As much as I would actually like to try it again, I would probably lose my job if I tried. It's like a piece of candy in front of a diabetic child.... The good...
  2. ZulumanatSPI

    Lock Up When Adding Table To SQL Search In IM

    I am hearing from our experts that we will need to re-install the search database for item searches. So far that is the only known fix.
  3. ZulumanatSPI

    Lock Up When Adding Table To SQL Search In IM

    It is, in fact, locking on all searches the look for an Item number (Item Master Maintenance, Single-Level Where Used in BOM package, Item/Location Maintenance, etc). And it is locking up in all companies as well...We also don't have the Test Data because they didn't yet convert it over or...
  4. ZulumanatSPI

    Lock Up When Adding Table To SQL Search In IM

    DGillz, it is the item number search...The same one you just tried to edit. Perhaps this is an unfound problem with Macola 7.6.100a MS SQL and not associated with the action that I took to try and add a table??
  5. ZulumanatSPI

    Lock Up When Adding Table To SQL Search In IM

    Thanks for the advice. But can you tell me how to fix it??
  6. ZulumanatSPI

    Lock Up When Adding Table To SQL Search In IM

    I wanted to add the Location Quantity On Hand and Quantity Allocated fields to the search screen.
  7. ZulumanatSPI

    Lock Up When Adding Table To SQL Search In IM

    We just switched over our BTrieve server to a SQL sever Running Macola 7.6.100a SQL. In IM, under Multi-Level Item View, I tried to add the IMINVLOC table to the Search function, which only had the IMITMIDX table. Now, when we click on the binoculars, it hangs, and I have to press...
  8. ZulumanatSPI

    Resetting Count Tag Numbers

    Thanks DG! You are the master! Going into the IM Setup did allow me to reset the Tag Number. It gave me a warning that by changing the number, it may effect Historical Data. But I'm gonna do it anyway. Again, thanks!
  9. ZulumanatSPI

    Resetting Count Tag Numbers

    Does anyone know how to reset the Cycle Count Tag Numbers, so that I can use the number "1" again? It keeps forcing me to use a number greater than an exisiting Tag number, but I have no Batches to count. Thanks.
  10. ZulumanatSPI

    Number To Time Function Needed

    I know that Crystal has a Macola NumberToDate conversion function. I need the same thing but for Macola time. So that 105318 comes out to 10:53:18. Does anyone know of a built-in or add-on function to do this? Thanks.
  11. ZulumanatSPI

    MRP By Date Order No Generation

    I'm on a new Macola system now so please refer to knowledge based on Macola 7.5.103f. We are running an MRP by Date report and finding some funky Order No's that we cannot find in the system anywhere else. They seem to be generated by existing Shop Orders, creating subsequent lines (SO H2134...
  12. ZulumanatSPI

    machine won't reboot!

    All the time......Chalk it up to poor operating system. Solution ---> Live with it....Or switch to Unix. Thank goodness for the reset key.....It's Window's best friend.
  13. ZulumanatSPI

    How to clean system

    Very easy......The secret to clean installs is a Windows98 Startup Disk. This magical entity will allow you to start your computer from your floppy drive and install CD drivers at the same time. Then all you do is format your C drive, and run the setup from the Windows disk. 1) Create...
  14. ZulumanatSPI

    Drill-Down Crystal Report From Macola Data

    dgillz, I've been playing for a few minutes with this approach and I can see where you're coming from. I know how to work with the aliases. But it's working with the multiple detail sections that a killer. For instance.... Let's say I do a single level bill of material with 1 detail...
  15. ZulumanatSPI

    Special Index Field For Parent Item Status?

    d, Thanks for the offer, but we already own the Macola upgrade and have decided not to go with it. We like the older DOS version and will stick with it. Our Inventory Transactions are posted real-time, which would mean we really don't use the IMTRXFIL. Now that I think back, I was unable...

Part and Inventory Search

Back
Top