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


Pages: 1
Send Topic Print
OPEN PO REPORT (Read 951 times)
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
OPEN PO REPORT
09/25/06 at 10:17:16
 
When I run an Open PO report, for one particular PO, I get a open total for the PO that is not the same as the total on the po.  I have looked at the BKAPPO and POL files and find the total on the PO is correct, but I can't find the number I am seeing on the report.  Where is this report getting data?
 
This is a PO with one line, no receipts.  I can't tell if there were changes-- if only there was a PO changes report!   Wink
 
---update--
I printed this report both in text and with the RTM in DBA classic and the report has the correct open amount( matches the PO)  So it is only the RTM in Evo that is not correct-  I can't check the text version because Evo closes the PO-I-A screen without a report when I choose text version.
(The numbers make no sense-  the correct amount is  1000 @ 3.43 =3430 and the amount showing on the Evo RTM for open PO's is 1000@3.43 for a total of 2915.50.)
Back to top
 
« Last Edit: 09/25/06 at 11:56:07 by cathyh »  

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
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: OPEN PO REPORT
Reply #1 - 09/28/06 at 12:02:18
 
try using the RTX version, and see if you still have the same problem.
 
what is the date of your PO-I-A? mine is 7/18/02 with evo ver 2006.1 8/11/06
 
my po-i-a totals fine.
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: OPEN PO REPORT
Reply #2 - 10/02/06 at 07:40:28
 
The problem seems to be with only this PO-- at least it is the only one I have found.  My T6POIA.RUN file is dated 8/8/06.
Since I looked at this PO  last, another line has been added, different part, same cost, same quantity, and the total on the open PO report is off by double the original amount.
My RTM's and RTX's for POIA (version 1 and 2)are all dated 10/13/04.
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: OPEN PO REPORT
Reply #3 - 10/02/06 at 09:20:54
 
My month end routine includes printing a open PO report and a receiving report for the month.  THis month I did them both in both Evo and DBA classic.  I found another PO for the same vendor in the receiving report, with the same problem. Line numbers as follows:
Vendor: FILEXT            FILTRONA EXTRUSION                                                      
PO #      Emp #      Item      Recd Qty            QC Qty      RNI Qty      Invcd Qty      Cost      UM      Act Date      Work Ord #
  4173       106      1100003          1000.00                   0.00             0.00          1000.00             3.4300      FT      09/20/06           0
  4173       106      1100010          1000.00                   0.00          1000.00             0.00             3.0622      FT      09/20/06           0
                 Recd Qty            QC Qty      RNI Qty      Invcd Qty      Recd $      QC $      RNI $      Invoiced $
FILEXT      FILTRONA EXTRUSION                2000.00                   0.00          1000.00          1000.00          4905.93             0.00          1990.43          2915.50
                                               Recd $      QC $      RNI $      Invoiced $
                                   Grand Total $                4905.93             0.00          1990.43          2915.50
 
What is driving these numbers?  Not the PO record, since in Classic they are correct, see below:
 
Vendor      PO #      Emp#      Item      Rcvd Qty      QC Qty      RNI Qty      Invcd Qty      Cost      U/M      Act Date
 
FILEXT      4173      106      1100003      1000      0      0      1000      3.43      FT      9/20/2006
FILEXT      4173      106      1100010      1000      0      1000      0      3.0622      FT      9/20/2006
 
     Rcvd      QC $            RNI Qty      Invcd Qty      Rcvd $            RNI $      Invoiced $      
FILTRONA EXTRUSION      2000      0            1000      1000      6492.2            3062.2      3430      
 
 
PS  How do I display a printout of a report so that the fields line up better ?  I know this is hard to read but I can't seem to make it better.
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: OPEN PO REPORT
Reply #4 - 10/11/06 at 09:06:27
 
I am still stumped by this and would really like to fix this vendor.  It does seem to be just this vendor.  And all of the PO reports (open PO,RNI, Receiving) print incorrectly in EVO and correctly in DBA Classic.  
Any ideas, anyone?   ???
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: OPEN PO REPORT
Reply #5 - 10/11/06 at 10:07:46
 
Another thing I have discovered is that in the BKAPHPO file for this customer the total invoiced field (BKAP.PO.ITOTAL) is exactly double the PO total field.  This started with a March 2006 PO, all PO's before this have the right amount in the Invoice total field.
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: OPEN PO REPORT
Reply #6 - 01/26/07 at 08:55:53
 
Well, I finally figured out and fixed this problem but I don't think it should have been a problem in the first place.
The part numbers for this vendor are purchased used and sold in the same UM- feet.  Someone put a weight in the weight field  since it seemed from the help description that it was a shipping weight.  The help file says that if the purchase UM is lbs or CWT and Stock UM is something else, PO's use this to calculate the price.  
In our case, it is using the weight to calculate the price, ONLY in the PO Reports and not on the PO, even though my UM's are the same.  When I took out the weight, the Open PO report printed correctly.
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: OPEN PO REPORT
Reply #7 - 01/27/07 at 09:36:41
 
PS-- apparently this is only happening when the UM is FT; I have others that are purchased in UM of EA  and GAL and the weight does not affect the report.
 
PPS I get the feeling I am talking to myself!
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
Pages: 1
Send Topic Print