RE: AP RECONCILIATION REPORT -- SYSTEM21

Eva,

What version are you on?  I had one customer who did not have a PLP20 record
for every PLP15.  The detail on the vendor inquiry screens did not equal the
vendor total ledger amount or log amount.

Run an SQL or query comparing PLP15 to PLP20.  We found that when an item
was moved from log to ledger, the original log PLP20 "IN" record was
missing.  Also, in some cases, the PLP20 ledger "IN" record was missing.

I would also check to make sure your G/L files are ok.  To do this, run an
SQL or query comparing PLP15 to FLP008.

Recreating the PLP20 record fixed the problem.  FYI, the customer was on
3.5.0.

Before you do any updating, I would copy the records into a test company or
test library and try the scenarios there.  You don't want to mess up your
financials.

Ed Lybrook



-----Original Message-----
From: owner-jbausers-l@midrange.com
[mailto:owner-jbausers-l@midrange.com]On Behalf Of Wu, Eva
Sent: Thursday, November 02, 2000 9:56 AM
To: JBAUSERS-L (E-mail)
Subject: AP RECONCILIATION REPORT


Can someone help me to fix the records that are showing up on my AP
Reconciliation Report (Menu APU, Option 14)?

I already ran Option 11 rebuild balances and Option 17 rebuild log balances
last night. Afterwards, I ran Option 11-verify balances & Option 16 verify
log balances. I did not have any error messages on the reports. I can't
think of anything else to try on the system.

The error messages I have are in:
*       Item to Transaction Error Section. What file is the Item Prime Value
& Item Base Value in and which file has the Transaction Prime Value &
Transaction Base Value? Can the files be fixed through DBU? Some of these
invoices showed up on my log rebuild report as being fixed. However, these
are still showing up in this report & in the Menu APE Option 1 as the
outstanding log balance for each vendor.
*       Transaction to Balance Error Section. What file has the Database
amount & which file is the Calculated number from? Can the files be fixed
through DBU?

I am getting an error message stating that the sum of prime / base
allocation is non zero in the Allocation Errors section. I am also getting
an error message stating that the base /prime discount total is non zero.
*       Some of these are on Invoices entered in foreign currency but paid
in USD dollars.  Others are invoiced and paid in USD dollars.

Any suggestions/information would be greatly appreciated. Does anyone know
why these errors are occurring? My report is growing every month.

Thanks

Eva

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---