Welcome, Guest. Please Login.
05/20/25 at 11:01:26
News:
Home Help Search Login


Pages: 1
Send Topic Print
Junk lines in SO-O-A Open Sales Orders by Item (Read 671 times)
sunmfg
Member
**




Posts: 59
Junk lines in SO-O-A Open Sales Orders by Item
05/20/08 at 08:58:50
 
There are lines in my Open Sale Orders by Item Number report that show a sales order number of "0" and are all credits in quantity.  They show no customer, or customer PO.  If I go to SO-A looking for sales order # 0, it is not there.
 
Which file contains these lines, and how do I get rid of them?
Back to top
 
 
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Junk lines in SO-O-A Open Sales Orders by Item
Reply #1 - 05/22/08 at 08:42:39
 
The file is BKARINVL.  You could delete them in Maintain Database or, if there are too many, contact me, we have a search and replace/delete utility .
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
sunmfg
Member
**




Posts: 59
Re: Junk lines in SO-O-A Open Sales Orders by Item
Reply #2 - 05/22/08 at 10:04:34
 
There are 10 lines, all at the bottom of the list because they have invoice numbers greater than our series.  How does one delete a line?  I can't see a way to do it.
 
Thanks.
Back to top
 
 
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Junk lines in SO-O-A Open Sales Orders by Item
Reply #3 - 05/22/08 at 11:01:01
 
You have to check the edit box in the upper right corner,and then the "+" and "-" sign shows in the bottom left.  Go to the line you want to delete and click on the minus sign.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
sunmfg
Member
**




Posts: 59
Re: Junk lines in SO-O-A Open Sales Orders by Item
Reply #4 - 05/22/08 at 12:09:15
 
But I have no edit box.  The only boxes in the upper right are the three Windows buttons for minimize, etc.  (I am using dba classic v 2004.1 with IStech update 5/08/06.)  Then I have three windows for files, indexes, and fields.  Below that is the list of records in the file.
Back to top
 
 
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Junk lines in SO-O-A Open Sales Orders by Item
Reply #5 - 05/22/08 at 13:13:38
 
I just checked in my classic version and you are right, there are no buttons to edit highlighted.  I don't know much about classic anymore!  Sorry I can't help you.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Junk lines in SO-O-A Open Sales Orders by Item
Reply #6 - 05/22/08 at 13:21:15
 
Actually I just went back to Classic and when I picked a file to look at the plus and minus signs "lit up".  Do you have "Maintain database" rights?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
sunmfg
Member
**




Posts: 59
Re: Junk lines in SO-O-A Open Sales Orders by Item
Reply #7 - 05/22/08 at 14:01:56
 
OK, now I found the minus sign.  Thanks for sticking with me.  (I'm a little slow!)
Back to top
 
 
Email WWW   IP Logged
Pages: 1
Send Topic Print