FAQ
From EvoERPWiki
[edit] Frequently Asked Questions
Please add anything in here that you feel might be asked on a regular basis or that you've had to answer repeatedly. And don't forget to try the Official FAQ on the IS Tech web site.
[edit] Who is ISTech?
ISTech Support is the company that has taken over support for the DBA Manufacturing software product. They provide both support and updates to the system. In addition they have created EvoERP, a successor of sorts to DBA. EvoERP adds features and a better GUI to DBA. ISTech's website is here: ISTech Support
[edit] What is the story with DBA?
March 27, 2006 DBA sent a letter to its customers stating that they would no longer be providing support for their DBA Classic product. They now are supporting only their new DBA Next Generation product. Many customers with DBA Classic did not want to switch to DBA Next Gen for a number of reasons. However, ISTech is authorized to provide updates and support for DBA Classic and its successor EvoERP.
[edit] Why do we need a Wiki?
How is this wiki thingie different from the forum, eh?
[edit] Work Order Questions
Visit the Work Order Questions Page
[edit] Inventory Questions
Visit the Inventory Questions Page
[edit] Manufacturing Questions
Visit the Manufacturing Questions Page
[edit] How Do I Get at DBA Data for Custom Reports?
Visit the Accessing DBA Data Page
[edit] Data Maintenance Questions
Visit the Data Maintenance Questions Page
[edit] The Evo~ERP Menus
Answers to questions about the Evo Menus (TAS-G)
[edit] Problems/Errors
Getting error 94, frequent crashing, or totally unable to use DBA? Maybe you should check Mismatched_PSQL to see if that's the problem.
[edit] Working with Image Links in Bulk
I have done this process twice. The first time we were changing the location of the files (prints) on our network. I used an MS Query to bring all of the links into Excel, where I did a search and replace to change the first part of the path. The query was very simple, since it just grabbed all of the columns in BKQTTEMP.Bnn
The second time I did this I started from scratch, exporting a complete list of all inventory items of type A and F and building paths to where their prints should be on our network. That was a big job, but I was able to do 5933 links inside of six hours, which I spread over about four days.Again, I used Excel, building the document path in one column (e.g. the path for all of my parts starting with 'SA6' the path was U:\Assy\SA\SA6\), merging the part number and path into a third column (e.g. part # SA6-23B has a print at a path of U:\Assy\SA\SA6\SA6-23B).
Since I wanted all of these prints to be the first (and only, for now) link for type A and F items, I went ahead and removed all of the then current links for type A and F items in Evo. At that point there were only one hundred or so that had links. This was our first big push to start using links. I used the Pervasive Control Center to execute a SQL query that removed the old links. If there had been a number of links that I wanted to keep for these items, I would have exported them all and edited them into my Excel file. (much easier than weeding or blending inside Evo)
Next I set up my Excel table to have the complete info for each link by adding a column for Order (this link first in the links list) and a column for Use Global Path set to N. You may also want to add columns to set Print with Traveler, etc. (see DE-S for fields) to your links. I saved the Excel file as CSV so that I could import it as a comma delimited file in DE-S
Finally, I used the DE-S utility (read the Help file entry) to import the links. The utility appends your file of links to the current list of links, which is both good and bad. Bad because if you load links for items that have links already you might be duplicating links. Good because you don't wind up squashing links others have added. If you are careful to make a back up of the BKQTTEMP.Bnn file prior to running DE-S, then you can fix any boo-boos easily. Also, save the CSV file you have made in case you have not done everything just right.
Also, don't be afraid to export, empty, and/or re-import links to get things set just the way you need them. You can also use the Maintain Database program to fix little quirks. Remember to make a backup of of BKQTTEMP before editing it.
[edit] What File holds My Data?
Q: Can anyone help me out with the name of the file that keeps the approved Manufacturers and their part numbers?
A: It is BKSBMFG.B
Here is what I did to find it: open IN-B, bring up an item, add an entry under "Mfgrs" (manufacturers), then open the DBAMFG (or EVOERP) folder on the server, go into company files folder, sort by date modified (descending) and look at the files that have been modified in the past few minutes. Only one of them had the letters "MFG" in the name. Then I opened that table with Maintain Database to see if my entry was in there.
These same steps can be modified slightly to help find just about any data needed. There is also a spreadsheet available for download from the IS Tech web site that may help: DBAFILEN.lxs is pretty extensive, but several years old. Many of the IS Tech changes and additions are not represented. This file is great for figuring out which fields to look for once you find the right file, too.
[edit] Updating RTMs
Q: I installed the latest update last weekend and now we can't print RMAs from Evo. Anyone know how to fix this?
A: There is a subfolder named "RTX" in which are master copies of the the standard RTMs, except that their suffix is ".RTX". If you are having problems with, say, T7SOB4.RTM and want to try the newest version of the standard form, rename your current T7SOB4.RTM to T7SOB4.OLD and copy the T7SOA4.RTX from the RTX folder into your company folder. Rename the RTX to end with RTM. That gives you the most up-to-date copy of the form (if it has been changed as part of a recent update), with the only caveat being that, if you have customized the form, you may need to reapply your mods. I've had to update a few forms recently, so I just copied our header mods from the old form into the new one with the form editor.
