Re: Out of balance between AR (F0311) and GL AR Trade account *DELETED*

Re: Out of balance between AR (F0311) and GL AR Trade account *DELETED*

Post deleted by ekempter

Re: Out of balance between AR (F0311) and GL AR Trade account

Ben,

Did you try running report P03701? This is an integrity from F0311 to
F0911. Usually any out of balance condition will be caught by this. The
only thing this report would miss is the case where there are some
orphan records in F0911 with no corresponding records in F0311. Now to
catch such situation one can run another report P007021. This will give
you all those transactions which have hit G/L but didn;t hit A/R.

Depending on the data in your files, both these reports might take
quite some time to run.

Now as for the reason as to why this might have happened, there can be
many. One of the common ones is that if the I or R batch posting job
gets killed in the middle, then this would create such out of balance
situations. So that might have happened at some point of time leading
to unbalance situation ever since.

I hope this helps.

Thanks,
Ashutosh Agarwal
[email protected]




--- dupe03 <[email protected]> wrote:
>
> --------------59E7C47EBB079679F175D7DF
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> test
>
> svdgi wrote:
>
> > If the F0311 is populated through P42800 , then there
> > is a processing option of consolidate this amount in
> > F0311 and F0911.
> >
> > Another quick and dirty way is to correct the correct
> > the F0911 entries with F0311 amount.This amount can be
> > derived using identical batchno,docno,and doctype.Only
> > the miscelleneous amount is to be selected.A Small
> > World writer can do this. Make sure to check with the
> > F0011 file too as the batch amount resides in that
> > file too.
> >
> > --- support28 <[email protected]> wrote:
> > > Date: Wed, 18 Oct 2000 18:58:45 -0400
> > > From: Ben Tonti <[email protected]>
> > > To: "'[email protected]'" <[email protected]>
> > > Subject: Out of balance between AR (F0311) and GL AR
> > >
> > > Trade account (F0911)
> > >
> > >
> > > We have been carrying an out of balance condition
> > > between the F0311 and the
> > > AR trade account in the GL for months. The amount
> > > out
> > > has remained unchanged
> > > for the past four months. We would like to resolve
> > > the
> > > difference and have
> > > been unable to do so.
> > >
> > > I am looking for a method to isolate the differences
> > >
> > > between the two files.
> > > I am new on the scene but not new to the JDE system;
> > > no
> > > one is able to help
> > > with what might have changed four months ago. The
> > > integrity reports don't
> > > shed any light on the problem either. I suspect a
> > > correction to some AAIs.
> > >
> > > I would appreciate any input you may have.
> > >
> > >
> > > Ben Tonti
> > > Solution Managers International, Inc.
> > >
> > >
> > > ----- End forwarded message -----
> > >
> > >
> > >
> > >
> > > --------------------------
> > > Visit the forum to view this thread at:
> > >
> >
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=31
> > >
> > >
> > *************************************************************
> > > This is the JDEList World Mailing List.
> > > Archives and information on how to SUBSCRIBE, and
> > > UNSUBSCRIBE can be found at http://www.JDELIST.com
> > >
> > *************************************************************
> > >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Messenger - Talk while you surf! It's FREE.
> > http://im.yahoo.com/
> >
> > --------------------------
> > Visit the forum to view this thread at:
> >
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=75
> > *************************************************************
> > This is the JDEList World Mailing List.
> > Archives and information on how to SUBSCRIBE, and
> > UNSUBSCRIBE can be found at http://www.JDELIST.com
> > *************************************************************
>
> --------------59E7C47EBB079679F175D7DF
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> test
>

svdgi wrote:
> <blockquote TYPE=CITE>If the F0311 is populated through P42800 , then
> there
>
> is a processing option of consolidate this amount in
>
> F0311 and F0911.
>

Another quick and dirty way is to correct the correct
>
> the F0911 entries with F0311 amount.This amount can be
>
> derived using identical batchno,docno,and doctype.Only
>
> the miscelleneous amount is to be selected.A Small
>
> World writer can do this. Make sure to check with the
>
> F0011 file too as the batch amount resides in that
>
> file too.
>

--- support28 <[email protected]> wrote:
>
> > Date: Wed, 18 Oct 2000 18:58:45 -0400
>
> > From: Ben Tonti <[email protected]>
>
> > To: "'[email protected]'" <[email protected]>
>
> > Subject: Out of balance between AR (F0311) and GL AR
>
> >
>
> > Trade account (F0911)
>
> >
>
> >
>
> > We have been carrying an out of balance condition
>
> > between the F0311 and the
>
> > AR trade account in the GL for months. The amount
>
> > out
>
> > has remained unchanged
>
> > for the past four months. We would like to resolve
>
> > the
>
> > difference and have
>
> > been unable to do so.
>
> >
>
> > I am looking for a method to isolate the differences
>
> >
>
> > between the two files.
>
> > I am new on the scene but not new to the JDE system;
>
> > no
>
> > one is able to help
>
> > with what might have changed four months ago. The
>
> > integrity reports don't
>
> > shed any light on the problem either. I suspect a
>
> > correction to some AAIs.
>
> >
>
> > I would appreciate any input you may have.
>
> >
>
> >
>
> > Ben Tonti
>
> > Solution Managers International, Inc.
>
> >
>
> >
>
> > ----- End forwarded message -----
>
> >
>
> >
>
> >
>
> >
>
> > --------------------------
>
> > Visit the forum to view this thread at:
>
> >
>
> <a
>
href="http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=31">http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=31</a>
>
> >
>
> >
>
> *************************************************************
>
> > This is the JDEList World Mailing List.
>
> > Archives and information on how to SUBSCRIBE, and
>
> > UNSUBSCRIBE can be found at <a
> href="http://www.JDELIST.com">http://www.JDELIST.com</a>
>
> >
>
> *************************************************************
>
> >
>

__________________________________________________
>
> Do You Yahoo!?
>
> Yahoo! Messenger - Talk while you surf! It's FREE.
>
> http://im.yahoo.com/
>

--------------------------
>
> Visit the forum to view this thread at:
>
> <a
>
href="http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=75">http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=75</a>
>
> *************************************************************
>
> This is the JDEList World Mailing List.
>
> Archives and information on how to SUBSCRIBE, and
>
> UNSUBSCRIBE can be found at <a
> href="http://www.JDELIST.com">http://www.JDELIST.com</a>
>
>
*************************************************************</blockquote>
> </html>
>
> --------------59E7C47EBB079679F175D7DF--
>
>
>
>
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=78
>
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/