|
General Tanning Industry Discussions Tanning Salon Owners and Professionals in The Tanning Industry Discuss a wide Variety of Topics. |
| LinkBack | Thread Tools |
12-24-2008, 12:19 AM | #1 (permalink) |
Join Date: Oct 27 2008 Location: lincoln rd ste k
Posts: 8
Rep Power: 0 | info on helios does anybody now if you can mass delete inventory in the helios program i bought a tanning salon 2 years ago i have a advisor who needs a up to date inventory sheet and i have over 1295 items that i dont even have in my inventory.help |
12-24-2008, 09:18 AM | #2 (permalink) |
I vote for DERF! Join Date: Jan 6 2004 Location: Midwest-ish
Posts: 4,400
Rep Power: 22 | Re: info on helios Helios told me no. In fact, with Helios there is a front and back end to any inventory item. You have the sales code and the inventory code. When people delete product codes they tend to just do the sales code. Makes a mess of things when doing inventory reports.
__________________ OMG! I made a post! :) |
12-24-2008, 10:13 AM | #3 (permalink) |
I love Derf!! Join Date: Feb 10 2006 Location: Toronto, Canada
Posts: 931
Rep Power: 20 | Re: info on helios You might be able to in Helios Back office or using Microsoft Access....but i wouldn't know how. I've always done it manually one by one...but i haven't let get out of hand. When i drop a line, i go in and delete the 10-20 products manually.
__________________ www.ChronosMarketing.com 1-844-CHRONOS SOME PEOPLE ARE LIKE SLINKIES. NOT REALLY GOOD FOR ANYTHING, BUT THEY BRING A SMILE TO YOUR FACE WHEN PUSHED DOWN THE STAIRS |
12-24-2008, 10:34 AM | #4 (permalink) |
Join Date: Jan 6 2003 Location: Florida
Posts: 284
Rep Power: 22 | Re: info on helios i believe helios has a utility they can run to clear it out. you could always swap out the inventory.mdb file with the one that comes on the disk. I think helios preloads a bunch of inventory codes on there so not sure how much work that would eliminate for you. (maybe they can send you an empty inventory.mdb file..not sure. I would suggest calling them. |
12-24-2008, 10:43 AM | #5 (permalink) |
I vote for DERF! Join Date: Jan 6 2004 Location: Midwest-ish
Posts: 4,400
Rep Power: 22 | Re: info on helios The problem is with helios date checksum. Otherwise you would think that swapping out a "virgin" file would work. Worth a shot but I would think the "invalid date" error would come up.
__________________ OMG! I made a post! :) |
12-30-2008, 04:21 PM | #8 (permalink) |
Join Date: May 7 2005 Location: North Carolina
Posts: 151
Rep Power: 19 | Re: info on helios At your own risk, open the mdb file directly with Access. Create a query using the SQL query window to select and delete the required items based upon some type of criteria. For example with zero inventory and last receive date before a certain date... You'll have to link the Salecode:sales_code and the Invt:inventory tables. (File --> Get External Data --> Link Tables) Helios 11 is just a gui front-end of an access database. I've had to through the years fix many issues directly in the data that the Helios program couldn't find. Also, what's with their stupid "invalid date" error? Just a gimmick to force people to call support? Anytime we are closed for more than a few days in a row, we will get this error. In case anyone is curious, to resolve when receiving this error due to "extended" days lapsed with no Helios usage, just close Helios, set your PC time to 3 days after the last Helios transaction date. Open Helios, do a sample/test transaction. Close Helios. Increase your PC date 3 more days. Open Helios, do a sample/test transaction. Just repeat until you have caught up with your current correct date. This has always fixed our problems when getting the date error in Helios. Last edited by beachbumz; 12-30-2008 at 04:25 PM. Reason: Edit data at your own risk ;) |
12-30-2008, 04:30 PM | #9 (permalink) |
Join Date: May 7 2005 Location: North Carolina
Posts: 151
Rep Power: 19 | Re: info on helios A sample access query to join the two tables would be: SELECT inventory.*, sales_code.* FROM inventory INNER JOIN sales_code ON inventory.inv_code = sales_code.code; Do this after linking one of the tables to the other database file. |
Bookmarks |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
| |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
UPC info and Helios | unity | Technology Forum | 8 | 10-27-2008 01:17 PM |
Info about 1998 Puretan bed Tanfit III 28??? Any info?? | Tetor23 | New To The Tanning Business | 3 | 02-07-2008 11:54 AM |
info | springboktanning | General Tanning Industry Discussions | 0 | 09-30-2007 01:46 AM |
IN NEED FOR INFO | CRYSTALSHORT | New To The Tanning Business | 1 | 04-05-2004 08:24 PM |
Date problem when inputing sales info into helios v9.4 | tony246 | Technology Forum | 1 | 07-07-2003 07:26 PM |