ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> DE-A & T7GENIMP.RWN
http://www.istechforum.com/YaBB.pl?num=1416439038

Message started by AndyOB on 11/19/14 at 16:17:18

Title: DE-A & T7GENIMP.RWN
Post by AndyOB on 11/19/14 at 16:17:18

Trying to wipe out our LOT counts (there are a lot that are neg because people aren't correctly adding lot codes at finished production).

So, I exported the LOT table to a .csv using DE-A
Changed all the On-hand counts to 0 if negative

Now I'm running T7GENIMP.RWN to import the CSV replacing records in the LOT table.

The program compleats saying 11000+ records replaced, zero skipped, but when I go to LC-A to look at the records, nothing has changed? Is there a staging area for T7GENIMP that requires a second program to copy the data to the master file?

Thanks much,
-A.

Title: Re: DE-A & T7GENIMP.RWN
Post by Kelloggs on 11/19/14 at 18:52:07

maybe? perhaps? possibly?

DE-M Transfer Files to DBA

Purpose of Program

Use this program to transfer imported data to the permanent Master files for Inventory, Bills of Material, Routings, Customers, Vendors, and Chart of Accounts.

:-[

Kelloggs

Title: Re: DE-A & T7GENIMP.RWN
Post by Lynn_Pantic on 11/20/14 at 08:24:42

No, the Generic import does not use the temporary staging files. Whatever file you told it to import to is where the data went. If you want to change negative on hand in LOT to 0, you could use UT-A, NZFNR. File LOT, Action Replace, field MTLOT.ONHAND, Replacement Value 0, Filter MTLOT.ONHAND < 0. Then press Enter so the cursor is on the list of filters ready to select another one and press F10. Always a good idea to make a backup copy of the file first.