Search results for query: *

Say I have a game with 999 lights that are named Light001, Light002, Light003 through Light999. At the start of the game I need to turn all 999 lights to on. Is there a way to use For/Next to do this rather than have to individually write code to turn on each light? ex. Dim i For i = 1 to 999...

Have an Optional Field that was originally setup with the Validate check box ticked. Would now like to change the optional field to not validated but the box is greyed out. Anyone know of a way to gain access to the Validate Checkbox? I tried logging in on the Administrator account but still do...

Running Data Integrity check on IC with "Fix minor errors" box checked did not resolve the problem. I don't know where to find the Product Update information. I thought Help>System Information was the most likely place but no info there.

Sage Accpac 500 ERP (Version 5.5A)

I ran a check without the "fix" box checked and it found no errors.

Thanks for the help but I think I will leave it alone for a few reasons. 1) I'm not sure I'm comfortable with editing the data when I'm not sure how it's interconnected. I miss the days of when I built and managed the database. Then I knew what every field did and how it was interconnected. 2)...

What program might I use to do that?

How do I get at that field to set it? It isn't listed in the Location Details module.

Thanks for the help. Contacting our business partner just to delete one item is not worth the price of admission IMO. I'll just chalk it up to we got accpaced and move on.

Below are the errors that get thrown. There are no Kitting records or Vendor Details for this item. There is a Locations Detail record but that cannot be deleted and results in the same message "Day End Processing is pending for the iteam at location". [135c] IC0355: ICKITD...

Is there any way to get RVSpy to dump to a text file? I unchecked Options>Output>Window and checked the File box but can't find any log file. The box next to File reads "Not Found!". I changed the text to RVSpy.log but that did not create a file of that name. I had to resort to using just the...

Hmmm, I'm only guessing you mean run RVSpy and capture what happens when trying to delete this item? Or do you mean capture what happens during Day-End Processing? I have the text for when I try to delete the item but there doesn't appear to be any way to get the returned text to an outside file.

Those 3 fields are all 0. All fields for that item number: ITEMN: 66812 LOCATI: LANSDA AUDTDA: 20110114 AUDTTI: 15460595 AUDTUS: xxxxx AUDTO: xxxxx PICKINGS: ACTIV: 0 DATEACT: 0 USE: 1 LASTUS: 20101008 QTYONH: 0 QTYONOR: 0 QTYSALO: 0 QTYOFF: 0 QTYSHNO: 0 QTYRENO: 0 QTYADNO: 0 NUMNO: -1...

In case you get to the next step of adding more than one optional field I created the attached cheat sheet for myself.http://i818.photobucket.com/albums/zz101/fu2jobu/CrystalAccpac-MultipleOptionalFields.jpg

Yes, I have run I/C Periodic Processing multiple times now on different days but still can't delete the item.

I'm trying to delete an item but get the error message: Incorrect procedure. Day-end processing is pending for the item at location XXXXXX. Record cannot be deleted. There are no open Sales Orders or Purchase Orders for the item. I also checked Receipts, Shipments, Internal Usage...

It's working now. I started from scratch late Friday and the totals are now adding up correctly. I don't have an explanation (besides user error) for why they were not adding up right before but I am just relieved that they are now correct.

1 more zip file attached containing 3 images: 1 - Tables.jpg. Shows how I have the tables in the report setup 2 - Report.jpg. Shows the report as I would like it to be seen/grouped. 3 - ICITEMO Table.jpg. Shows the funky setup of the Optional Fields...

I realized grabbing the Order Total will not work. While most of our orders are confined to one brand only we do have some that may contain more than one brand. Therefore I needed to go back and base the report off of OrderDetails rather than Order. I went through the trouble to make a sample...

Nevermind I think it's time to just give up on the report. With the amount of time spent trying to get it to work I could have looked the records up individually and totaled them by hand for the next 3 years and still have spent less time. My best guess is the problem stems mostly from our...