Amy Walsh takes a look at an issue that we ran into recently. A client had two bank account numbers for a single account. Somewhere along the way the bank had merged or been acquired and the client’s account number changed. However, the number was never…

With a nice look at what bank transaction Line goes where, Belinda, the GP CSI leads us…

In her newest post, Belinda, the GP CSI looks at Where's the cash Account for this Cash…

Last week we looked at comparing the AP subledger to the GL via SQL. This week I want to give you some SQL code to compare the Bank subledger to GL. Yes, this is actually very easy to do inside the GP interface, easier than AP or AR but since you’ll have those two via SQL, why not have everything in one place.

The code is below and you’ll need to change the bank in the code to the bank name and…

Mohammad Daoud looks a couple of Bank Deposit issues that he has had recently in his posts:…