ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> OPEN PO REPORT
http://www.istechforum.com/YaBB.pl?num=1159208236

Message started by cathyh on 09/25/06 at 10:17:16

Title: OPEN PO REPORT
Post by cathyh on 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! ;)

---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.)

Title: Re: OPEN PO REPORT
Post by dameng on 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.

Title: Re: OPEN PO REPORT
Post by cathyh on 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.

Title: Re: OPEN PO REPORT
Post by cathyh on 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.

Title: Re: OPEN PO REPORT
Post by cathyh on 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? ???

Title: Re: OPEN PO REPORT
Post by cathyh on 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.

Title: Re: OPEN PO REPORT
Post by cathyh on 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.

Title: Re: OPEN PO REPORT
Post by cathyh on 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!