Sage 100

I have a customer who did an AP electronic payment reversal in a manual check batch with several other actual wire transfers entered. Everything posted fine to GL/Vendors but in Bank Rec, the E reversal amount was added to all the other wire transfer amounts. For example, the reversal was -3003.50. The next wire was 5125.00 but in BR it appears as 8128.50. This also happened to the next 15 wires. v2016 5.30.2 standard Any ideas as to what is causing this? (It happened once before too.)

I have found that ""E"" checks bypass bank recon and assumes that there will be a one entry offset as an adjustment . So if you reverse a manually check you need to manually put them into bank rec as negatives.

Gee, that makes a lot of sense. They do an electronic payment and it DOESN'T hit BR?? I don't know why you would reverse an E payment anyway. It does not create a negative ACH file. According to the Help file, if you enter the reversal as a Check type and then enter the EXXXXX number, it is treated as a check reversal. I'm not sure what they did in this case but somehow, the negative amount was ADDED to all of the other entries in that batch (in BR only). And no, there is no record of the E reversal in BR.

Curious - what is the setting in AP Options ""Post to Bank Reconciliation in Detail""? If unchecked, what @JimWoodhead says is accurate about how it posts to BR. Otherwise, you get postings on the Checks tab. Haven't reversed one either way, so can't speak to the experience.