ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> RNI duplicated entries
http://www.istechforum.com/YaBB.pl?num=1068578335

Message started by rjpaper on 11/11/03 at 11:18:55

Title: RNI duplicated entries
Post by rjpaper on 11/11/03 at 11:18:55

A receipt we entered duplicated itself tens of thousand of times. We did not discover this until we ran a RNI report three weeks later. (The transaction report for that part number is normal.) The report hung up and froze DBA.

We realize that the fastest way around this is to use our backup file however we would need to re-enter three weeks of receiving data. The challenge is to remove thousands of entries from Bkaphpol. Using the data base manager you can only remove one line at a time. Does anyone have any idea how we could export that program to a file such as excel so we can remove the bad lines and then import it back into dba?

Title: Re: RNI duplicated entries
Post by Lynn_Pantic on 11/11/03 at 11:42:09

IS Tech Support has a $49.95 utility that can Find and Replace, Adjust or Delete based on up to 6 different filters that could be used to clean up the file. There is no import/export capability for the PO Receipt file although you could hook to it using Access if you know how to use ODBC to connect to the file.

See http://www.istechsupport.com/addonut.asp if you are interested in the utility program. Works on any version of DBA.