Cash Receipts only posting to GL and not to Cash Account

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

We are experiencing unexpected behavior when posting via Cash Receipts i.e., there are not errors when posting. However, when we run the Reconcile to GL we see that the transactions are indeed posted to the GL but not to the Cash Account.

Can someone here point me to a possible clue as to where the problem may be resolved?

Thanks,

Gus

*This post is locked for comments

All responses (8)

Answers (0)

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: Cash Receipts only posting to GL and not to Cash Account

It didn't strike me immediately either Speedy!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Cash Receipts only posting to GL and not to Cash Account

Frank,

You were absolutely correct.. Occam's Razor.. Always!

Thank You.
Justin Thorp 2,265 on at

Like (0)

Report

RE: Cash Receipts only posting to GL and not to Cash Account

I recommend comparing what's in GL20000 and RM10101 for this particular payment, and see if there's something that doesn't seem right.

So, for example run the following statements with your payment number, and see if anything sticks out as not being right:

select * from RM10101

where DOCNUMBR = 'PYMT040604'

select * from GL20000

where ORDOCNUM = 'PYMT040604'

Thanks,

Justin
Community Member Microsoft Employee on at

Like (0)

Report

RE: Cash Receipts only posting to GL and not to Cash Account

Hi Justin,

Please see below. And, thanks in advance for any help.
Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: Cash Receipts only posting to GL and not to Cash Account

I know this is a simple question - but has a deposit been posted to the checkbook? That's what posts the cash receipt to the checkbook, not the Cash Receipts posting.
Justin Thorp 2,265 on at

Like (0)

Report

RE: Cash Receipts only posting to GL and not to Cash Account

Thanks for the screenshots. Can you please provide another?

When you click on the Distributions button in the Cash Receipts Inquiry Zoom, what is seen there?

Thanks,

Justin
Community Member Microsoft Employee on at

Like (0)

Report

RE: Cash Receipts only posting to GL and not to Cash Account

Hi Frank,

We have run a number of these transactions thru a test company and receive the same results (see below for screenshot of the issue).

1. We are running into this issue with both the Web Client and PC Client.

2. This is a new install for 2015 so there was no activity prior to 2014. So, no YE update applied.

3. We are running GP2013R2
Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: Cash Receipts only posting to GL and not to Cash Account

The first thing I would do is run a test in a test company. Enter and post 1 cash receipt and look at all the posting journals to see if you can spot anything unusual. If not, then look at the checkbook immediately after posting the cash receipt and see if it's in there.

I would also be curious to know if this is happening on one workstation or all, and if it's happening for one user or all. Also, I assume this just started happening. Have you applied the 2014 Year End update recently?