• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Intigrity issue

Hi List,
We are live on JDE financials. (AR, AP and GA)
We have a problem which I would like to put in front of the list. Somebody
I am sure will be able to answer.
I ran the trial balance by alternate account query and found a difference
of 25488 in the trial. The TB by company query did not show this difference
although the same difference was there. On importing to excel and summing
we found this difference.
I ran the Company within batch out of balance report (R09706) and found
that three batches were thrown up as error and the total amount of these
batches is 25,488. The difference in the trial balance is also 25488.
I want to know how we can rectify this problem.

Any help in this regard will be appreciated.
Thanks in advance

Arup Choudhury
Sr. Manager - Business Applications
Lafarge India Limited
Calcutta
India

1 ES, 1 DS, 2 Citrix
Windows NT EE, Oracle 8.1.6, OneWorld B73.3.2 SP 10.1
 
Arup,

Post the batches that are being shown as out of balance in the integrity
report by using the override Allow batch to Post out of balance . This
should solve your problem.

Rohini Kumar
 

graham_jones

Active Member
Arup,

You might want to take a look at ESU JD10869 as this covers a LOT of
integrity issues including R09706. Our finance team are in the process of
testing this one. Hope this helps.

Graham Jones
JDE Systems Manager
graham.jones@parkgroup.co.uk

B7332 SP15 / AS400 V4R4 (CO on AS400) / Fat clients NT4


***** DISCLAIMER ***** This communication contains information which is
confidential. It is for the exclusive use of the intended recipient. If you
are not the intended recipient, please note that any distribution, copying
or use of this communication or the information in it is prohibited. If you
have received this communication in error, please notify us by email or by
telephone on 0151 653 1700 and then delete the email and any copies of it.
*****
 

dave_laha

Active Member
Arup,

When you are saying the batches are in "error", are you saying that these
batches did not post and the batch status is "error", OR are you saying that
these were out of balance batches that were posted? Are these A/P, A/R or G/L
batches?

If the batches did not post, it could be an AAI issue. But then again, I am
wondering how you could have picked them up in the Company Out of Balance
report. If the batches posted out of balance, then there are more than one ways
of fixing it.

Guess, we need some more information.

Dave Laha
CNC / Finance
PCI Services








Arup_Choudhury <Arup.Choudhury@in.lafarge.com> on 07/16/2001 01:18:21 AM
 

Mike Dupaix

VIP Member
Arup,

Check the processing options to see if you are viewing all batches or only posted batches.
Hi List,
We are live on JDE financials. (AR, AP and GA)
We have a problem which I would like to put in front of the list. Somebody
I am sure will be able to answer.
I ran the trial balance by alternate account query and found a difference
of 25488 in the trial. The TB by company query did not show this difference
although the same difference was there. On importing to excel and summing
we found this difference.
I ran the Company within batch out of balance report (R09706) and found
that three batches were thrown up as error and the total amount of these
batches is 25,488. The difference in the trial balance is also 25488.
I want to know how we can rectify this problem.

Any help in this regard will be appreciated.
Thanks in advance

Arup Choudhury
Sr. Manager - Business Applications
Lafarge India Limited
Calcutta
India

1 ES, 1 DS, 2 Citrix
Windows NT EE, Oracle 8.1.6, OneWorld B73.3.2 SP 10.1




--------------------------
 
Top