RE: AP RECONCILIATION REPORT

["Wu, Eva" <Evawu@xxxxxxxxxxxxx>]

Ed,

We are on version 3.51. You were right about the missing PLP20 records. That
is definitely part of the problem. 

Thanks,

Eva

-----Original Message-----
From: Ed Lybrook [mailto:elybrook@btcgrp.com]
Sent: Friday, November 03, 2000 10:02 AM
To: JBAUSERS-L@midrange.com
Subject: RE: AP RECONCILIATION REPORT


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



-

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