Welcome, Guest. Please Login.
05/15/24 at 10:56:29
News:
Home Help Search Login


Pages: 1
Send Topic Print
PO-I-E / PO-I-F No Longer Printing (Read 2687 times)
Jon Coulter
Browser
*


Is it 5 o'clock yet?

Posts: 24
Gender: male
PO-I-E / PO-I-F No Longer Printing
05/01/03 at 10:45:29
 
Since installing the last update (not the new one just posted), the reports PO-I-E and PO-I-F are no longer printing.
 
We fill in the blanks, click "Print", and it scrolls through POs in the upper right of the window.  Once it's finish scrolling through the POs, it dumps us back to the menu.
 
We're entering actual receive dates of 4/1/03 through 4/30/03.
 
Any suggestions?
Back to top
 
 

Jonathan Coulter
Administrative Vice-President
Chem-Pak, Inc.
Martinsburg, West Virginia

DBA Client-Server
v2002.4 with IS Tech Support Update 10/08/04
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: PO-I-E / PO-I-F No Longer Printing
Reply #1 - 05/01/03 at 10:53:22
 
The PO-I-E & F reports haven't changed since back in December other than a new RTM provided for PO-I-E.  Do you get anything if you enter a wider date range or maybe filter by part or PO number and no date filters?  It is possible your BKAPHPOL file is corrupted or something.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Jon Coulter
Browser
*


Is it 5 o'clock yet?

Posts: 24
Gender: male
Re: PO-I-E / PO-I-F No Longer Printing
Reply #2 - 05/01/03 at 11:05:17
 
Seems to work for any month except April.  We did lots of POs in April, so there is certainly something there to find.
 
In fact, any date range that includes an April date kicks us out.
 
Would reindexing anything help?
 
Thanks,
Back to top
 
 

Jonathan Coulter
Administrative Vice-President
Chem-Pak, Inc.
Martinsburg, West Virginia

DBA Client-Server
v2002.4 with IS Tech Support Update 10/08/04
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: PO-I-E / PO-I-F No Longer Printing
Reply #3 - 05/01/03 at 11:13:43
 
Yup, that sounds like data corruption.  I would try reindexing BKAPHPOL as a first step.  If that doesn't work, try looking at the file using Maintain Database and see if you can find something odd.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Jon Coulter
Browser
*


Is it 5 o'clock yet?

Posts: 24
Gender: male
Re: PO-I-E / PO-I-F No Longer Printing
Reply #4 - 05/01/03 at 11:42:48
 
Reindex did not work.
 
I tried looking at the file with Maintain Database, and I'm getting a Btrieve Status 35 error (which is unrelated to my problem).  Apparently Maintain Database is setting up this key: D:\DBAMFGCHEMPAK\filename.b.  It is missing the backslash between DBAMFG and CHEMPAK.  Any idea how to get the slash back in?
 
Anyway, I opened the file with MSAccess and I don't see anything that jumps out at me as being corrupt.  The only unusual thing is someone received a PO with a date in December of 2003.  This happened in January, so I don't see how it is just now picking on April.
 
Any ideas?  It's acting like it isn't finding any POs for April, but there are scads in the database file.
 
Thanks,
Back to top
 
 

Jonathan Coulter
Administrative Vice-President
Chem-Pak, Inc.
Martinsburg, West Virginia

DBA Client-Server
v2002.4 with IS Tech Support Update 10/08/04
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: PO-I-E / PO-I-F No Longer Printing
Reply #5 - 05/01/03 at 11:54:03
 
UT-J will rebuild the DDF files and should fix Maintain Database.  Check BKAPHPO too, it is possible it is the header rather than the line item file.
 
Can you get data for any date range within April at all?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Jon Coulter
Browser
*


Is it 5 o'clock yet?

Posts: 24
Gender: male
Re: PO-I-E / PO-I-F No Longer Printing
Reply #6 - 05/01/03 at 12:12:38
 
Today isn't my day.   Angry  I'm currently searching for a bigger hammer.
 
1. Reindex of BKAPHPO didn't work.
 
2. UT-J did not fix Maintain Database problem.
 
3. MSAccess did not show anything obvious in either file.
 
4. Report bombs out whenever April is entered for either (or both) dates (in Recp Act fields).
 
5. Report also fails when filtering on Order Date.
 
6. I ran report for just one item number, which I new we ordered in April.  The report worked perfectly, and the April purchases for this item showed up.
 
Next step?
 
Oh, this may help ... After talking with the accounting girl, the option screen is totally new to her.  We were running on 2002.1 up through a couple weeks ago.  I was way behind in getting all the updates installed.
Back to top
 
 

Jonathan Coulter
Administrative Vice-President
Chem-Pak, Inc.
Martinsburg, West Virginia

DBA Client-Server
v2002.4 with IS Tech Support Update 10/08/04
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: PO-I-E / PO-I-F No Longer Printing
Reply #7 - 05/01/03 at 12:55:56
 
Hmmmm.....  How big are the BKAPHPO and BKAPHPOL files?  Can you zip and email them to me?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Jon Coulter
Browser
*


Is it 5 o'clock yet?

Posts: 24
Gender: male
Re: PO-I-E / PO-I-F No Longer Printing
Reply #8 - 05/01/03 at 13:10:35
 
The two files zipped are about 4 meg.  I can send them if you want.
Back to top
 
 

Jonathan Coulter
Administrative Vice-President
Chem-Pak, Inc.
Martinsburg, West Virginia

DBA Client-Server
v2002.4 with IS Tech Support Update 10/08/04
  IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: PO-I-E / PO-I-F No Longer Printing
Reply #9 - 05/02/03 at 13:31:23
 
Might want to check the the P.O. Default settings SD-C, Invoice PO receipts thru a/P Y/N.  In my test company, I have set to yes and can get the reports.  In my "real" company it is set to no-I cannot get the reports.  
 
In the test co.  the only ones that show up under the actual date are the ones received after I answered yes.  Previous ones do not show up.
 
This is for PO-I-F-I get the message: There are no PO/Receipts for the chosen criteria.
 
PO-I-E seems to be printing ok.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Pages: 1
Send Topic Print