Helios Utility - Change Sales Codes

Andy · 09-30-2002, 01:54 PM

Just created an Access Utility to work with Helios Databases.

This utility allows you to Change Sales Codes and related History.

It displays certain fields from the Sales Code table (Sales Code, Description, Sales Code Type, Division, Department, Inventory Item 1, Inventory Item 2). Each/Any of these fields can then be changed and all related history will be updated.

If you change the Sales Code field itself, to another code that already exists ... it will provide a warning and if confirmed, the original sale code will be removed and the history amended to the other code.

The utility provides a report of the changes that you have requested.

The utility then in a batch run makes all of the requested changes to the Sales Code tables, the Inventory table, the Inventory Maintenance (Adjustment) table, the Transaction (Customer purchase history) and Void tables.

On a database with 300 Sales Codes and 150,000 Transaction records the utility completed the update in about 10 minutes. It took additional time to input the changes being requested. During the actual update, Helios can not be running.

This utility allows you to restructure your Sales Codes and establish the relationship for Historical Sales Reporting and Comparision to your new Division/Department structure.

This utility allows you to standardize your Sales Codes and related history between your locations if you operate multi locations.

Anyone that is interested in learning more about this utility can reach me at the toll-free number below.

_________________

Andy Thompson
ACT Business Solutions
Toll-Free 877-777-6717
andy@atso.ca
ACT Help Center [ This Message was edited by: Andy @ ATSO.ca on 2002-09-30 14:06 ]

Danno · 10-01-2002, 04:38 PM

Well, give it up!!!

will it work on Salon Net Server?

Andy · 10-01-2002, 09:19 PM

Dan, one of the primary purposes that I created this utility for is to assist in the standardization of Sales Codes between locations for a client about to implement Salon Net.

We will need to get John/Michael do a little more work to impact the Salon Net SQL Database as well as the Helios Databases that my Utility impacts.

_________________

Andy Thompson
ACT Business Solutions
Toll-Free 877-777-6717
andy@atso.ca
ACT Help Center [ This Message was edited by: Andy @ ATSO.ca on 2002-10-02 05:16 ]

Danno · 10-06-2002, 05:58 PM

may I see it Pleeeaaase!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
number 2000	electricparadise	Say What ?????	41	11-03-2005 02:11 AM
HELIOS Regional Trainings - Winter Schedule	Andy	Technology Forum	3	11-09-2004 07:19 PM
In Helios v11, can you set default sales codes for each month?	SunDizzy	Technology Forum	1	03-04-2004 11:59 AM
HELIOS - V10.0.84 issues	Andy	Technology Forum	5	02-21-2003 05:35 PM
Setting up inventory	terryberry	Technology Forum	4	04-03-2002 02:30 PM

09-30-2002, 01:54 PM	#1 (permalink)
Andy Join Date: Jan 25 2000 Location: CT Posts: 1,760 Rep Power: 9	Just created an Access Utility to work with Helios Databases. This utility allows you to Change Sales Codes and related History. It displays certain fields from the Sales Code table (Sales Code, Description, Sales Code Type, Division, Department, Inventory Item 1, Inventory Item 2). Each/Any of these fields can then be changed and all related history will be updated. If you change the Sales Code field itself, to another code that already exists ... it will provide a warning and if confirmed, the original sale code will be removed and the history amended to the other code. The utility provides a report of the changes that you have requested. The utility then in a batch run makes all of the requested changes to the Sales Code tables, the Inventory table, the Inventory Maintenance (Adjustment) table, the Transaction (Customer purchase history) and Void tables. On a database with 300 Sales Codes and 150,000 Transaction records the utility completed the update in about 10 minutes. It took additional time to input the changes being requested. During the actual update, Helios can not be running. This utility allows you to restructure your Sales Codes and establish the relationship for Historical Sales Reporting and Comparision to your new Division/Department structure. This utility allows you to standardize your Sales Codes and related history between your locations if you operate multi locations. Anyone that is interested in learning more about this utility can reach me at the toll-free number below. _________________ Andy Thompson ACT Business Solutions Toll-Free 877-777-6717 andy@atso.ca ACT Help Center [ This Message was edited by: Andy @ ATSO.ca on 2002-09-30 14:06 ]

10-01-2002, 04:38 PM	#2 (permalink)
Danno Join Date: Dec 10 2001 Location: Michigan Posts: 46 Rep Power: 0	Well, give it up!!! will it work on Salon Net Server?

10-01-2002, 09:19 PM	#3 (permalink)
Andy Join Date: Jan 25 2000 Location: CT Posts: 1,760 Rep Power: 9	Dan, one of the primary purposes that I created this utility for is to assist in the standardization of Sales Codes between locations for a client about to implement Salon Net. We will need to get John/Michael do a little more work to impact the Salon Net SQL Database as well as the Helios Databases that my Utility impacts. _________________ Andy Thompson ACT Business Solutions Toll-Free 877-777-6717 andy@atso.ca ACT Help Center [ This Message was edited by: Andy @ ATSO.ca on 2002-10-02 05:16 ]

10-06-2002, 05:58 PM	#4 (permalink)
Danno Join Date: Dec 10 2001 Location: Michigan Posts: 46 Rep Power: 0	may I see it Pleeeaaase!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)