Welcome, Guest. Please Login.
05/09/25 at 06:25:10
News:
Home Help Search Login


Pages: 1
Send Topic Print
RNI duplicated entries (Read 492 times)
rjpaper
Browser
*


I love YaBB 1G -
SP1!

Posts: 1
RNI duplicated entries
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?
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: RNI duplicated entries
Reply #1 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print