Account Maintenance - "this account is not a posting account"

(1) Share

Report

Posted on by hersheys

850

I set up multiple accounts and for some reason there were 3 that say account is not a posting account. For some odd reason they appear as "0" account type. How do I even go back and change it or even delete and recreate the accounts? Thank you so much.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (1)

Jason Boyd 77 on at

Like (1)

Report

Not quite sure if this is the answer, but you can change account information or delete an individual account through the account maintenance window. Cards > Financial > Account.

Was this reply helpful? Yes No
hersheys 850 on at

Like (1)

Report

I did try that already. Every time I enter the account number it automatically gives me that "This account is not a posting account". If you look at the list of account numbers it is there. I believe it just has the "0" account type instead of "1". I used this sql to determine what account type it was set up as.

SELECT ACCTTYPE, * FROM GL00100

Thanks.

Was this reply helpful? Yes No
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

If it is not a Posting Account, could it be an Allocation Account?

Tim

Was this reply helpful? Yes No
hersheys 850 on at

Like (0)

Report

I tried to use the allocation and the unit and they are not. It gives me the same message when I enter the account numbers. Thanks.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (1)

Report

Have you looked at Tools > Setup > Posting > Posting Account, you will have to go in there and indicate the account details.

Was this reply helpful? Yes No
Community Member on at

Like (2)

Report

Go to Cards - Financial - unit account - delete

About unit accounts from GP Help

Unit accounts are similar to posting accounts. Both are used in transaction entry, and historical information and budgets can be kept for both types of accounts. When you post to unit accounts, however, you post quantities rather than amounts. Unit accounts don't appear on financial statements.

You can use unit accounts to compare financial and nonfinancial information. You can also use them with posting accounts to calculate information such as sales per employee. Use unit accounts with variable allocation accounts to allocate amounts such as rent expense to each department based on its square footage.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (1)

Report

Practically speaking, the account type of GL accounts should be one of the following

ACCTTYPE (Account Type):
1 – Posting Account
2 – Unit Account
3 – Posting Allocation Account
4 – Unit Allocation Account

Reference: Victoria Yudin - GL Tables

In this essence, you should check the following tables:

GL00100 Account Master, GL00103 Fixed Allocation Master, GL00104 Variable Allocation Master

If you are definitely sure that this is a posting account, you consider a test (after taking a back up of your company), to update the account type value to 1.

Running check links for the financial series is a must of course

Your feedback is highly appreciated,

Was this reply helpful? Yes No
hersheys 850 on at

Like (0)

Report

Done that already. Same message. Thanks.

Was this reply helpful? Yes No
hersheys 850 on at

Like (0)

Report

This is not a unit account. We don't use unit accounts. Thanks.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi,

Have you tried to run checklink against account master. Please take a backup before running checklink.

Microsoft Dynamics GP menu >> Maintenance >> Check Links

Was this reply helpful? Yes No