JOINING FILES

[Colin_Hugill]

Julius,



Before anything else, would you please follow the basic protocol for
this list by including in your email (usually included in the signature
text) the JDE Release and CUME levels currently in use at Steamships.



How long has this problem existed? When did it first become apparent?



Check prior history emails on this topic by searching JDEList.



First thing to check is that there are no "manual" journal entries in
the AR control account(s). If there are any, then they should be
reversed out and the PEC for the control account set to "M" and then
rerun the integrity report. If they are not reversed out then their
value must be used to manually adjust the values on the integrity
report.



Second thing, if you are on A7.3 before about cum 10 or 11, then make
sure that your integrity programs have all UQF's applied - there was a
problem with the integrity checking programs (from memory especially AP)
and a UQF was available from the KG.



Thirdly, there is a standard integrity program that checks between AR
and GL by batch - it is on the same standard "G" menu that the AR to GL
by offset program is listed. This will identify which batches are
suspected to be in error. Use this report to determine which batch
transactions to list.



Fourthly, has anyone been adjusting the F0901 balances for the controls
accounts by any method other than the GL post process (ie no DFU, no
SQL, no OBDC, no non JDE programs or interfaces)?



Finally, gut feel and experience lead me to suspect either manual
journals to the control account in GL or a GL Post process that crashed
without updating the control account balance record. Try running the
A/c Balances to Transactions integrity process in general ledger but
make sure you set the selection criteria to select only the AR control
accounts (using specific A/c ID's makes it a faster process).



There is one other possible cause - more than one GL post executing
simultaneously can result in the control account(s) not being updated
correctly. So, make very sure that ALL GL posts execute through one
single threaded job queue. Do not allow users to change job queues for
submitted jobs.





Regards,



Colin





Colin Hugill
Consultant
(World A7.3 cum12)

 

[juliuskilambu]

JULIUS W KILAMBU
COMPUTER SERVICES DIVISION
P.O.BOX 496,
PORT MORESBY
EMAIL. <[email protected]>
PHONE.....3220455/3220319
FAX............3211007



juliuskilambu
<jkilambu@steamshi To: [email protected]
ps.com.pg> cc:
Sent by: Subject: Re: JOINING FILES
jdeworld-bounces@j
delist.com


23/03/2004 15:14
Please respond to
JDELIST World
Discussions






juliuskilambu replied to your post at the site: .
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=69742

I check for all other transactions that were not generated thru the Debtors
system. Even other systems which interface into JDE and I can not get down
to the bottom of the problem so I need to join F0311 to F0911 so this
report can give batch by batch comparision of what went into Debtors and
Updated F0911/F0902

Thanks
Julius Kilambu
JDE A7.3 00009
Steamships



--------------------------------------------------------------
CAUTION:
1. This message may contain privileged and confidential information
intended only for the use of the addressee named above. If you are not the
intended recipient of this message; you are hereby notified that any use,
distribution or reproduction of this message is prohibited
2. If you have received this message in error, we apologise. Please notify
us immediately at [email protected]
3. Any views expressed in this message are those of the individual author
and may not necessarily reflect the views of Steamships Trading Company.
4. The sender disclaims liability for any errors, omissions, viruses, loss
and/or damages arising from using, opening or transmitting this e-mail.



JDE/400 7.3 00009
Papua New Guinea
Opinions or Post I express are not from my employer

 

[Colin_Hugill]

Try running the AR Integrity for AR to GL by Batch - it should report
any batch where the sum of entries in GL doesn't agree to the value of
the vouchers in F0311. It has three columns that for each batch will
tell the value of F0311 records and the values found in F0911 plus the
value that went to the control account (ie the sum of the AE entries for
the batch. Using this standard JDE function should reduce some of the
data you have to "dig" through manually.

Also, you better check out the post on this list from Marsh Narewec
dated 16 July 2003 - seems he had a problem with F0311 and F0411 records
being deleted "accidentally". Maybe your problem goes back to then -
one or more records may not have been recovered or not recovered
correctly.

Regards,

Colin


Colin Hugill (Consultant)
(World A7.3 cum12)

 

[juliesisson]

here's another alternative if you want to use IBM query. Take the F0911 file and run a distinct record file for DCT, DOCO, and ICU. Take the F0311 file and do the same. Then join the two files by unmatched to the primary file. Dependent upon the amount of records you have, takes only a few minutes to do.



Julie Sisson
Miller Zell
A73 cum 11