• 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!

G/L Bank Account in A/R

Hi all,

I hope someone out there can help me with this....

I am currently looking at Accounts Receivable and have noticed something strange. G/L bank account in the AR ledger is sometimes blank....is this normal? I am trying to do some reporting off of this file (F0311) for a client and this is causing me some grief.

Thank you in advance,
Jill MacLaurin
 

Graham_Aberdein1

Active Member
Hi Jill,

We don't use A/R, but I'm wondering if there is an AAI setup for the bank
account?

Graham Aberdein
Clarica
WorldSoftware A7.3 cum 11 (G/L, A/P, F/A)





jill_maclaurin <jill.maclaurin@cognos.com>@jdelist.com on 10/04/2001
12:13:24 PM

Please respond to jdeworld@jdelist.com

Sent by: owner-jdeworldml@jdelist.com


To: jdeworldml@jdelist.com
cc:
Subject: G/L Bank Account in A/R


Hi all,

I hope someone out there can help me with this....

I am currently looking at Accounts Receivable and have noticed something
strange. G/L bank account in the AR ledger is sometimes blank....is this
normal? I am trying to do some reporting off of this file (F0311) for a
client and this is causing me some grief.

Thank you in advance,
Jill MacLaurin


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=W&Number=8909
 

tpayne

Reputable Poster
I don't know about Accounts Receivable, but you had better BEWARE in
Accounts Payable, since the G/L Bank Account is written to the F0411 file
when an invoice is entered.
This same bank account is used when the invoice is paid, therefore if you
change bank (as we have done recently) or have multiple bank accounts to pay
from, the system may not pick up all the items for payment that you expect.
We ended up writing a patch program to update the bank account in the F0411
as we were getting so many problems.
As regards the case with the AR ledger, could the source of the transaction
in F0311 be the reason for some records having a blank bank account? Could
be one program sets this field while another doesn't. Might be worth a
check.
Hope this helps.
----------------------------------------------------------
Tony Payne - Senior Systems Analyst
United Musical Instruments USA Inc.
1000 Industrial Parkway
Elkhart, Indiana 46516
Tel: (219) 295 0079 ext. 2337
Fax: (219) 295 8613
Email: tpayne@umi-usa.com
(Running JDE A73 cum 10 on V4R3M0)
 
The default bank account is set in the AAI RB (03.100) for AR and PB
(04.015) for AP. If you unsure of creating or hesitant in changing AAI's,
request assistance from local JDE support.

Regards
Ian Newman

Omni Leisure Operations Limited
World A7.3 c11 AS/400 V4R5
Em: ian_newman@omnileisure.com.au
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
Top