Support
FAQ's V2.x:
Here
are some common answers to CostGuard tech support questions. The
topics include:
>> Index Out Of Date, key violation &
other data problems
>> Access violation
>> Autoexec.nt error
>> EDATABASE Engine Errors, data directory
is not properly initialized.
>> Dates are two digits for the year (e.g.,
03), instead of four digits (e.g., 2003)
>> Error running Module and
Feature Unlock Utility
>> Directory is controlled by other .NET
file, network & File Sharing Error Messages
>> Field 'CELLPHONE' not found
(or similar)
>> Printing
>> Conversion
>> Purge
>> Backups and Moving Data
>> Index Out Of Date & other data problems:
This is a data corruption that occasionally occurs.
Version 2.80 or greater: The
rebuild should begin automatically. If it doesn't, you can run
it from within CostGuard (version 2.80 or greater: Tools >
Rebuild). Or, you can start it externally: Start > Programs
> CostGuard > Rebuild Utility.
Versions prior to 2.80: Go to Start > Programs
> CostGuard > (in versions prior to 2.80) CostGuard Utilities > File Rebuild Utility.
Select your data folder. It's usually CGW\DATA\MAIN, unless your
data is stored on a server or another folder. You should see a
number of files with the ".db" extension. Click "Select
All", then click "Rebuild".
When the rebuild is complete, look at the listing for the status
of COULD NOT REBUILD. If the file name is _COUNT.DB, or starts
with TMP or SLT, then ignore. If the file name looks like a CostGuard
file name (e.g., items.db, icntdet.db, ircptdet.db, etc.), then
make a note of the file name, close this utility, and continue
to the next paragraph. If there were no exceptions then close
this utility and start CostGuard again.
If
the problem persists, then you should upgrade to version 2.80
or greater, which includes a more powerful rebuild.
>>
Access Violation
This is essentially a memory 'collision' in Windows, and requires
at least a CostGuard restart. If it persists, then you will need
to reboot your computer to clear memory.
>>
Autoexec.nt error
This appears to be a XP/SP2 problem. You can download and run
a small fix program by clicking here.
>>
EDATABASE Engine Errors:
Occurs when CostGuard can't find the data files. This can be fixed
by Start > Programs > CostGuard > (in versions prior
to 2.80) CostGuard Utilities > CostGuard Configuration. This
program contains settings for your CostGuard data. Please see
the Installation section of your documentation for details.
>>
Dates are two digits for
the year (e.g., 03), instead of four digits (e.g., 2003)
This is a Windows setting. To change Control Panel, press Help,
then search for Date (or date settings), and follow the instructions
for setting the short date format. Select a format that has yyyy
instead of yy for the year. After making that change, you may
need to exit and re-enter the CostGuard screen you're in for this
change to take affect.
>>
Error running Module and Feature
Unlock Utility
Under certain conditions, this utility may not work properly:
you may get an error message, or it simply won't work. If you
haven't received a newer copy of this program, please call support.
After you've received the new program:
- If you received unlockcg32.exe, simply download, double click,
and follow the instructions.
- If you received unlockcg32.zip, simply download, double click,
select extract, then select your c:\cgw folder.
The Module and Feature Unlock Utility should then work properly.
>>
Network Usage & File Sharing
- Directory is controlled by other .NET file
-
Multiple Net Files in Use, or lock files error message, error
with pdoxusrs.net or paradox.lck:
These errors can occur on both networked and standalone workstations.
All CostGuard users have PDOXUSRS.NET and Paradox "lock"
files in their data folders (c:\cgw\data\main, or elsewhere depending
on your install settings). Normally, when you exit CostGuard,
these files close properly. But if you don't exit normally, these
files are left open. The next time CostGuard opens, the system
detects that the lock files are already in use and returns the
error messages.
To
fix, you can erase any paradox.lck, paradox.lck, and pdoxusers.net
files on your PC. Here are instructions if you need them:
WINDOWS
2000/XP
1. Make sure no one is using CostGuard.
2. Click Start > Search > For Files or Folders.
3. The "Search Results" window opens.
4. Type P*.LCK;P*.NET in the "Search for files or folders
named" box.
5. Set the "Look in" box to search the \CGW folder for
the drive CostGuard is installed on (for example, Q:\CGW on a
network, or C:\CGW on a standalone PC).
6. Click the "Search Now" button.
7. The system will search for lock files, including PARADOX.LCK
and PDOXUSRS.LCK.
8. Delete any Paradox and Pdoxusrs that are found.
You can delete all the files at once if you press
CTRL + A to select them all, then press the Delete key.
You can delete the files one at a time if you select each one
in the "Search Results" list, then press the Delete
key.
WINDOWS
98 AND WINDOWS NT WORKSTATION 4.0
1.
Make sure no one is using CostGuard.
2. Click Start > Find > Files or Folders.
3. Type in P*.LCK;P*.NET;INTERLCK.* in the "Named" box.
4. Set the "Look in" box to search the \CGW folder for
the drive CostGuard is installed on (for example, Q:\CGW on a
network, or C:\CGW on a standalone PC).
5. Press Enter or click the "Find Now" or button.
6. The system will search for lock files, including PARADOX.LCK
and PDOXUSRS.LCK.
7. Delete any Paradox and Pdoxusrs that are found.
You
can delete all the files at once if you press CTRL + A to select
them all, then press the Delete key.
You
can delete the files one at a time if you select each one in the
"Search Results" list, then press the Delete key.
-
Other errors occurring over the network. Generally, these errors
have to do with rights on the network. CostGuard users need full
rights to all CostGuard directories. In addition, since we maintain
a .ini file in the Windows directory, they need access to that
directory also.
-
Record controlled by another user message:
This relates network access and configuration. First, make sure
that the user has complete rights to the entire CostGuard directories.
Second, make sure the configuration program is set correctly,
especially for the Network Setting. Start > Programs > CostGuard
> (in versions prior to 2.80) CostGuard Utilities > CostGuard Configuration
>>
Field Not Found
The 2.80 update requires some additional fields (vendor cell phone,
web page, email address), and creates them on the fly when it
opens for the first time. If you're running 2.80 or greater, and
you see this message, then erase pxupgrade.log from your data
directory (e.g., c:\cgw\data\main; keep in mind that your data
may be on a server, not the C drive, and your unit name may differ
than 'main'). After erasing this file, start CostGuard again.
>>
Printing
- If you try to print and nothing happens, then you probably need
to update your printer driver. You get this directly from your
printer manufacturer, and can usually do it from their web page.
Here's a link to the HP web page for driver updates:
http://www.hp.com/cposupport/software.html
>>
Conversion
Files that are required are pro.com, prosetup.exe, and setup.dat
>>
Purge Inventory Items
Purge is part of the Module and Feature Unlock Utility, starting
on the first page of the Appendix section.
The
purge is a global function that erases ALL transactions for ALL
items for the date period you specify. It doesn't delete inventory
items, but if that's still more than you want to do, then you
can rename the item(s) starting with xxx[item name] so that it
is moved to the bottom of the list, and will be out of the way.
You can also remove it from locations (after
zeroing out the levels), and remove it from vendors.
>>
Backups and Moving Data
We can't tell you HOW to backup (and move) your data, because
that depends on your backup method (CD, zip, tape, etc.). But
the files you need to backup/move are \cgw\data\main (as long
as you've accepted our defaults during installation). Otherwise,
the data will be on your networked drive.
Technical Support
support@costguard.com
(914) 337-9030, ext. 12
At-Your-Service
Software, Inc.
450 Bronxville Rd.
Bronxville, NY 10708
Fax: (914) 337-9031
www.costguard.com
Previous
Updates
Version
2.60
Version
2.50
Version 2.40
Version 2.30
Version 2.23
Version 2.20
Top
2.60
INVENTORY
Updates
-
An optional Transfer transaction has been added. It is an
upgrade to the multi-unit controller, and allows you to
actually transfer inventory from one unit to another. There
is complete detailed reporting, including a transfer journal
and updates to all usage reports. Please call us if you'd
like to purchase this new feature.
-
Clickable vendor email and web page fields have been added.
New vendor fields for cell phone, email address, and web
page appear on the vendor edit, order, receiving, and bids
screens.
-
Current inventory level is displayed on the inventory count
sheets.
-
Short date format of yy will default to 2000 (instead of
1900). This prevents transactions from accidentally being
saved with the wrong date.
Fixes
-
Requisitions and prep recipes: prep recipes now appear on
the select list and the requisition journal; you can requisition
the 'small' unit of a prep recipe.
-
Requisitions:
the sorting spinner now works for requisitions created from
recipes.
-
Requisitions: all items appear on the journal (items without
a vendor were not appearing)
-
Builds now appearing in the appropriate journals.
-
Accounting export working for units other than MAIN.
-
Under certain conditions, open orders were erased. This
has been fixed.
-
'FILL' OPTION IN NEW ORDERS IS FASTER!!
-
Selecting single items in certain journals no longer creates
an error
-
Reporting error (Type Mismatch In Expression) with Canadian
formatted dates has been fixed.
-
Certain
cases of usage reports adding together counts (instead of
replacing them) has been fixed.
RECIPE
Updates
-
A Close button has been added to make saving easier
Fixes
-
Can no longer open the same recipe twice (this caused problems
when saving the recipe)
-
Recipe pricing report allows for selection of saleable inventory
items
-
Recipe pricing report now displays correctly for 'margin
food cost' option
SALES
Updates
-
Micros 3700 interface
Option to print daily sales mix without dollars.
VENDOR TRANSPORT
-
Added eSysco in all VendorTransport options.
-
Bulk import fixed to import quantity and unit from vendor
items
(previously only importing unit)
-
An
import invoice option had been added
-
An IDS/PowerSell item import has been added
System
Wide:
-
An auto-rebuild, which detects database problems and runs
automatically. This can also pack data, and detect 'widow/orphan'
records and delete them. It automatically detects where
your data file is.
-
Database
upgrader, which detects a database update requirement, and
performs it automatically.
-
You can open a saved report from the File menu (previously
you had to preview a report in order to open a saved report)
View error log in File menu.
-
A new delete capability in Inventory and Recipe that can
removes related transactions, so that you don't need to
run the purge in order to delete items.
Top
2.50
Fixes
and modifications include:
INVENTORY
- Reports:
the 'details off' setting now shows all relevant transactions.
Printed Count sheet shows additional decimal places.
- Usage
Alert Reports: These have been moved to the new Alert tab
in Reports.
RECIPE
- Shows
the entire Portion and Yield in recipe printout. Recipe
Copy command now copies Prep Notes.
- Recipe
Import now skips over items already existing in the target
database.
SALES
- The
problem with depleting prep recipes is fixed.
The
problem with depleting recipes that have quantities in the portion
field is fixed.
Key
enhancements include:
SALES
- Sales
Mix import optionally uses the Sales dollars along with the
quantity sold from the POS import. Instead of calculating
sales dollars from the recipe selling price, CostGuard can
now import the total sales dollars. This helps account for
meal period pricing and comps.
- SellWise
(CAP Automation) is now included as a POS selection.
RECIPE
- Recipe
cross-reference report displays the quantity used.
- Inventory
cross-reference report displays the quantity used and the
current on-hand.
INVENTORY
- Purchasing
Alert Report: this new report has been added, and is available
from the Alert tab of Reports. It highlights items that have
increased in the time-frame requested.
- A
'Save + New' button on the inventory item screen automatically
saves the current item AND adds a new one at the same time.
This saves keystrokes when entering new items.
ACCOUNTING
EXPORT
- Calculates
the Due Date in QuickBooks export.
Top
2.40
INVENTORY
- Inventory
item print from directory.
- PO:
4th fill option - fill with cheapest vendor.
- VendorTransport
now includes an interface with US Foodservice.
Have
more questions?