Sage 100

A user is reporting that one cash receipt didn't post to the bank reconciliation. How could this happen other than turning off the integration?

Do they have multiple bank codes and did they check the other bank codes, just in case someone chose the wrong one?

@BethBowers I checked the AR Cash Receipts Report and it shows the deposit was bank code B. When I look at bank code B for the deposit date in bank rec the deposit isn't there.

I have seen BR hang up. Frequently a co-occurring issue at the same time is the out of balance on the printed registered is different than what appears on the screen. The BR utility must be run to get them back in alignment. I know in one instance we could not determine cause but did have users overly frequently in the BR module holding up the file (daily bank reconciliation).

I have seen Cash Receipts take a dump before posting to BR. I may recommend @WayneSchulz customer in the future. Unless you can spot a pattern, chalk it up to the school of hard knocks.

@JeffSchwenk I was going to recommend I conduct a six hour analysis to make sure there isn't any additional data corruption.

Well, if you can get the money, go for it! I am sure you can set their expectations accordingly.

I'm joking Jeff. If I cant figure it out in fifteen minutes I am going to recommend making an adjustment in BR to make it reconcile.... after I see if the printed reconciliation report agrees with the screen image.... unless someone has a better idea.

This wasn't a wire was it ?

Possibly. I will check. What difference does that make? Shouldn't a wire still post to the BR?

I don't believe the wire transfers go to BR though I think they impact the balance. Theory is that the wire shouldn't be outstanding.

Interesting. I will check on that.

It isn't a wire. It was a deposit with one check applied to about 20 invoices. Also, the bank reconciliation report is out of balance by the same amount as the out of balance on the screen. The out of balance amount is the same amount as this missing deposit. Very odd. I am going with Jeff's recommendation and tell them this was an aberration and let me know if it happens again.

There's some type of trick to rebuild BR. I always have to look in the KB to see what it is. I'm thinking maybe rebuild sorts.

Rebuild the BR sort keys and life goes on.

Manually enter as a deposit in Bank Rec - or spend tons of time analyzing.

@LeeGraham Yep. Did that this morning . I made one last attempt at fixing by rebuilding BR keys and sorts. It didn't help so sent an email recommending adjusting in BR.

Maybe copy to a Test company and try that deposit again to see if it posts to B/R ?