Sage 100

UG from 4.4 to 2016.3 - customer now says that ACH created and posted in AP since the upgrade do not transfer to BR like they did before. The integration is turned on and the registers appears to have all been posted. I do see there is an option under AP - Setup - ACH to post in detail which is UNCHECKED (customer does not want the detail only total). Does not seem as if anything from ACH has posted into BR. Anyone else seen anything similar when the option NOT to post ACH in detail to BR is selected? Update: Logged in with Sage, they could not duplicate. We fiddled and ultimately took case # 8005905335. Brett suggested click/unclick the post in detail option. I found another company in the customers system and looked via DFDM and found that if their PostBankRecInDetailACH$ was = [] then no ACH goes to BR. Solution is DFDM this field to either Y or N or check/uncheck in options as Brett suggested.

I think you may need to just toggle it on and then off to reset the setting.

They have one batch that had both checks and ACH - the checks post to BR. The ACH does not.

right

Did they look under the Deposits tab in BR? I think one way posts it as an adjustment, and the other as a check...

Yes

On the phone with Sage - taking a case # as this appears to be a bug. Sage is trying to push back saying that in order to integrate you must check off the ""post to bank reconciliation in detail"". Thankfully the help file says otherwise.... They shifted me to another tech who tried the same but I persuaded them that it the help file said otherwise. They say they can't duplicate so now they are looking again.

@WayneSchulz, I'm a little confused. Did you try what I suggested? That worked last week for one of our Consultants.

No - Sage is on now. I can hear the customer next questions ""so do we have to go click every option ...

Or maybe I wasn't exactly clear. I was suggesting you toggle on/off the 'ACH Post in Detail' setting.

Well tell them to try that first. :)

And if there's other settings they have to do that for, you'll of course offer to do that for them ""no charge"". lol. Only other situation I heard of that's similar is in P/O and S/O which was previously discussed in SC.

Copied to a test company and could not duplicate so unsure what's happening.

Appears that if AP_Optionis..M4T field PostBankRecInDetailACH$=[] that no ACH posts to BR. If you set it to N either by DFDM or check/uncheck then ACH post to BR. All other postings to GL and AP seemed ok. This just impacted BR.