I'm having some problems with a new system I'm trying to implement and am wondering if anyone else is having or has seen the same problems.
 
First some background,  We were initially a manual company what only shipped a couple of units each year.  DBA was purchased and used for processing AR and AP transaction only.  Needless to say the system was a mess. Since this time,  we have cleaned up the PO system and process, the SO process and Inventory.  We have done physical inventory and streightened our books out.
 
Currently, we have WOs in the system but not necessarily routes and BOMS.  However,  all parts on the floor are labeled (if not, they come and get me and I lable it) with a bar code and all parts have a route of 10 as general labor.  I have purchased Symbol P470 scanners and have written a program for them that tracks labor and parts to a work order.  At the end of the day,  I download the info from the scanners and import into DBA.  After the WO is complete,  I examine the BOM and Hours.  If they appear correct, I enter the part and in the specs, enter BOM=R, ROUTE=I (R for revision, I for incomplete), Copy the work order BOM to the part and give the paper work to our production manager to enter the routing.  After the BOM comes back three time with no changes to the WO BOM, or the ROUTE,  BOM and ROUTE are changed to C (complete) in the spec for the part, and the cost is rolled up for standard cost.
 
1st question:  When I import material (DE-H-B), I have to change "Validate WOBOM components" to Y.  is there a way to set this to default to Y?
 
2nd question:  Since there are no BOM Items on the parent part, they are imported and added to the WO BOM.  This is great except when the same part is entered again,  it adds it to the WO issue without increasing the number for the WO BOM!  Example:  Bill pulls a HCS-12 bolt to use in his section.  the part is imported and added to the BOM as 1 required.  Later, Tony pulls 3 of the same bolts.  When the work order is imported, it adds the three bolts to the issue but does not set the WO BOM to 3 required.  When the BOM is rolled over to the parent part, only 1 bolt shows on the BOM.  Is there a way to easily increase the required quantity on the WO BOM?
 
3rd question:  I have written a program to talk directly to the scanner and the database through ODBC.  I have set the databases in the scanners to have the same fields and field sizes as DBA.  However, I do not know what tables to bring part issues and labor into or what else I have to do to populate the table correctly.  Any help on which tables for which data and what calcs need to be done on my side would be a great help.
 
If anyone else is using MCL capable scanners and would like my code, just send an email and I'll be more than happy to pass it on "as-is"
 
thanks,
 
Tim