Sage 100

Problem in Bank Rec in 4.40.0.4. BR one bank code is giving an error message: ""The bank code p is in use."". Has anyone seen this before

That GLWSKA is still there. I don't know if it's still used. In fact don't know squat about B/R

I usually go into the GL.Bank.M4T file and edit the field for bank code in use. I delete the M,A,or P from this field

That is hilarious @RonGouveia !

GLWSKA still works. It didn't fix the problem. In GL_Bank.m4t it's blank.

As far as I know the GLBANK file is the replacement for the GLWSKA and we edit when printing hangs and this field is not cleared.

It actually looks like the bank code actually changed from capital P to lowercase p.

Can you still get into the code in bank code maintenance?

Yes. That's where I actually realized the case had changed. Looking through the transactions in Bank Rec, it looks like the change happened in August.

that's a problem because when i create a bank code P it automatically goes to upper case.

Yeah. It was P for years. Somehow in August it changed to p.

I've never seen a case where this error appeared and the bank in use field was blank. It probably doesn't like the lower case.

That was my thinking. I just haven't figured out how to correct it.

You could make a back up of GLBank, then delete bank code P in DFM and re-enter in bank code maintenance. Not sure that works but think it would. I guess you would have to manually re-enter balances?

I'll definitely test it.

I copied their data down to my computer. In GL_Bank, I changed the Bank Code from p to R. Then I changed it back from R to P. That seems to have worked. I'll test it on their system tomorrow and report back.

Clever!

Well, it sort of worked. The problem now is the 2800 records in BR_Transaction that has the bank code as lower case p. As long as the file only has checks where the Bank Code is upper case P in BR_Transaction, it works fine.

I'm off to reinit BR_Transaction and import the transactions back in.

@RobertWood, what is it with you and Bank Code P? https://90minds-com.socialcast.com/messages/13851115

Wow, @BrettZimmerman How do you remember this stuff?

Just sounded familiar so did a quick search in SC.

This is the same incident. The owner of the company was out of the country for a few months.

The issue is that the bank code got changed to a lower case p somehow. I don't know how it happened. Once the bank code got changed the new records going into BR_Transaction also had the bank code as lower case. When the Auto Reconcile hit a check with the lower case bank code, it would give us the in use message.

I got @AlnoorCassim to write a quick PVX program to go through and clean them up. It was cleaner and quicker than exporting, cleaning up in Excel, doing the reinit and import in the BR_Transaction table. Also if I did the import it would have changed the date and time imported. Thanks @AlnoorCassim!