Cash Receipt

[Jeff73]

Hi list:
This has to do with AR. When I go to to the Receipt Journal Review and type in one particular batch number, I get one amount under Input Total and the status is Posted. When I go to the G/L and enquire on the Bank account that corresponds to that payment, I see a different amount. Usually, they should be equal. I ran integrity report P03701 and P037001 and neither returned anything.
What am I missing here?
Thanks,
J.

 

[John_Dickey]

Have you looked at the journal entry from the batch posting?? My first
thought is that maybe there were entries to other bank accounts in that
batch?? Also, were there any credits in that batch?? I have learned to be
skeptical of that input total. I have not studied the JDE process for cash
receipts, but on Index Allocations in G/L they calculate that number by
adding up G/L entries with a positive amount. So if you allocate against an
account with a negative balance, the Input Total will NOT match what you
would expect the number to be. So if JDE does the same type thing in Cash
Receipts, you may be beating your head against the wall, trying to reconcile
something that cannot be reconciled. I have reported this issue to JDE and
am trying to convince them to change how ICAME is computed. Not sure I will
succeed. May need a whole group of people telling them to change this.

John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466

 

[Mike Dupaix]

Jeff,
If you're looking at the batch header information, it
is just that. Information. If you want to confirm
postings of specific items in a batch, look at the
transactiondetail and match that to the GL Bank.
You'll get better results.
--- Jeff73 <[email protected]> wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=46945


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



World, OW B733X and Xe

 

[Jeff73]

Re: RE: Cash Receipt

Thanks a ton. Yes, it seems to be JDE has some debit/credit issues when it comes to computing that total. However, my users have been relying almost exclusively on that total and have come to the point where they now think the detail of the batch (option 1) is wrong!! The trouble is that it's actually right, but doesn't include write-offs, so it looks different from what's on the GL... the challenge now is to explain that to my users.
Thanks again,
J.