Finance | Project Operations, Human Resources, ...

"Not a posting account type"

(0) Share

Report

Posted on by CedarM

Hello!

Several months ago we set up a balance sheet account to track specific deposits that go into it. We recently found out that that account, while registering in the checkbook register, does not post to GL. When we tried going to account maintenance to see what possibly could cause this and edit it, we cannot log into account. The error message immediately pops up stating that "This account is not a posting account".

We then figured out that when going through purchasing module, that account# defaults to "unit", instead of purchasing. However, when trying to go to Financial -> Cards -> Unit Account and then plugging that account#, it gives us an error stating "it's not a unit account". We tried fixed and variable allocation to see if we could fix it from there - and nothing. The system will not allow us to access that account # at all in order to correct it. This is very frustrating. What are we doing wrong? And what do we need to do in order to change that account# to a posting account so that the transactions we had entered finally register on general ledger.

Thank you!

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (8)

Answers (0)

Andrea Melroe 3,437 on at

Like (0)

Report
Copy link

Link copied!

Hi CedarM,

It sounds as though you may have a problem in the account setup tables. There are two main tables that store account setup information:

GL00100 – Account Master

GL00105 – Account Index Master

It almost sounds as though one of these tables is missing a record for this account.

Here’s how you can check:

Run the following sql script against the company database:

Replace XXXX with the account you’re receiving an error message for. Enter the account exactly as you’d see it on the front end (for example 000-1100-00):

SELECT * FROM GL00105 WHERE ACTNUMST = 'XXXX'

Did you get any results?

If so, note the ‘ACTINDX’ associated with this record and run the following to view its associated record in the GL00100 table (Replace Y with the account index you noted above):

SELECT * FROM GL00100 WHERE ACTINDX = 'Y'

Is there a record? If there is, does the account number ‘match’ what you see in the GL00105 table?

The resolution here will be dependent on where the record is wrong/missing.

Let me know what you find, and I’ll do my best to assist. Thanks!

Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

Was this reply helpful? Yes No
CedarM 20 on at

Like (0)

Report
Copy link

Link copied!

Thank you Andrea! However, this is a bit over my head here. What is "sql script" and how do I run it? I am not a programmer. I am an accountant who ran into this issue... I thought there would be an easier way to look this up and fix. I guess GP does not make it easier for users, huh?!

Was this reply helpful? Yes No
CedarM 20 on at

Like (0)

Report
Copy link

Link copied!

Is this what you are talking about?

Was this reply helpful? Yes No
Andrea Melroe 3,437 on at

Like (0)

Report
Copy link

Link copied!

No, do not do anything with that SQL Maintenance window! I don't want you to lose any data.

I'm talking about SQL Server Management Studio specifically. This is where you can run scripts against the company database to look at the data sitting in the tables.

Do you have an IT person who is familiar with SQL? Perhaps they could run those scripts for you so we can at least see how the data is sitting?

Was this reply helpful? Yes No
Young_12 5 on at

Like (0)

Report
Copy link

Link copied!

I m still not able to post any account type whereas my my data is also being removed every time I enter it.

iMessage App

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try going to Tools->Financial->Remove History. Click both Transaction History and Account History Print buttons. Then click Range. Does it allow you to select this account? If it does click the Process button after setting the range. Does this return anything? There are 4 different types of accounts:

1- Posting Account

2-Unit Account

3-Posting Allocation Account

4-Unit Allocation Account

Do you have anyone who can run SQL scripts?

Run this first

SELECT * FROM GL00105 WHERE ACTNUMST = 'XXXX'

then this

SELECT * FROM GL00100 WHERE ACTINDX = 'Y'

Make note of GL00100.ACCTTYPE

Let us know that value. If you are stuck send me a PM and I can connect and help. We will need to connect to your server to run these scripts. Maybe you can find someone in IT to join us.

By the way, if you can pull up this account in GP and there is no history you can delete it and re-enter it with the correct account type.

Was this reply helpful? Yes No
Hosler_23 5 on at

Like (0)

Report
Copy link

Link copied!

I'm talking about SQL Server Management Studio specifically. This is where you can run scripts against the company database to look at the data sitting in the tables. In here I am not able to post any data in it. Whenever I enter any data it removes it and resets the field.

please provide some solution for it.

Official Website

Was this reply helpful? Yes No
Suggested answer

Andrea Melroe 3,437 on at

Like (0)

Report
Copy link

Link copied!

Hello,

To determine best steps to resolve the problem you’re seeing for this particular account: I’d need to be able to see how the data is sitting on the back end. Honestly, I think as Richard stated earlier, it makes sense for someone to connect/stream in with you directly to review the data (in the GL00100, GL00105, and in the GL10001/GL20000/GL30000 to see if the account is actually associated with any records in those tables), fix the data if needed, and get a new account setup accurately. The resolution will likely entail some work in SQL Server Management studio, and some work on the front end of GP.

While I’d like nothing more than to do that, it’s not something I can do within the community forums platform. However, I am more than happy to assist you with this via a support case. You can open a support case here: Microsoft Dynamics Support

Thank you,

Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

Was this reply helpful? Yes No