I'm not sure if you are talking about Sage 100 ERP error codes or Sage Intelligence.

Sage 100 ERP -  there used to be a nice list but I can't seem to find them.   This would be codes like ERROR 47,  ERROR 107,  etc.   These are generic codes and will lead you in the right direction but are not the specific answers for a specific situation.

If you are referring to more specific error messages that you might get which give an error code,  a program name and a line number,  your best resource is to use the Sage Knowledgebase.   Log in to the customer portal or the partner portal and search with that information.

Sage Intelligence - not sure.

I use Sage 100 ERP.  Some Errors we see a lot here are:

"Bank code in use by another"

"Unable to open selection table, GL_ACCOUNT. Table is locked."

"Module P/R is not on file"

For the most part, I understand how to get rid of the 'bank code in use by another" by either using GLWSKA or going into the designer tab and reentering the formula.  We also use SQL here, so not sure if that has something to do with why we are getting all these error messages.  

Thank you

I agree with Tom on the knowledgebase.  In fact, I would keep your Sage partner involved as self service is not always advisable.  For instance, getting the Bank Code error can actually mean someone is cutting checks or posting cash receipts, or a number of things (in which case overriding would be unwise) and your partner would ask the question of frequency. If you get it repeatedly, it could be indicative of processes not completing due to network issues or timeouts. I suggest that my clients ping me and ask if this is a good issue to blow a Sage case on or if it's an easy fix, etc.

Great thank you both

Your first two errors are just suggesting that the file is in use by someone else temporarily.  For example, two people cannot be printing checks simultaneously.

The last one seems kind of strange and bears looking into.

Your first two errors are just suggesting that the file is in use by someone else temporarily.  For example, two people cannot be printing checks simultaneously.

The last one seems kind of strange and bears looking into.

Yes the "bank code in use by another task" is very common at least for us.  We have over 150 company codes so we see it at least once a week if not more.

However, the bottom 2 error problems we experienced across 5 different computers yesterday (May 28, 2015) during the morning but by the afternoon, they did not appear and we were able to do GL entries, use the GL detailed ledger and update registers.  It was the first time we saw "module P/R is not on file."  We do not use the payroll system in Sage (I assumed that stood for payroll), so it was weird to see that come up while trying to update the invoice register.  

Thank you.

The Bank Code in use error would happen to us weekly.

We have 11 company codes and we have eliminated the "Bank Code in use by another task" issue.

support.na.sage.com/.../viewdocument.do  

Module P/R is not on file is really strange if you don't have payroll!   And even if you did have P/R installed,  why you would get a reference to that when using a different module,  that's still very strange.

I've seen odd "module not on file" errors when doing upgrades that are solved by deleting an orphaned row in a system file.   (Something like sy0ctl.soa ?)