web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(1) ShareShare
ReportReport
Posted on by 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)
  • Jason Boyd Profile Picture
    77 on at

    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.

  • hersheys Profile Picture
    850 on at

    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.

  • Suggested answer
    Tim Foster Profile Picture
    8,515 on at

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

    Tim

  • hersheys Profile Picture
    850 on at

    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.

  • Rosemary Profile Picture
    10 on at

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

  • Community Member Profile Picture
    on at

    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.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    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,

  • hersheys Profile Picture
    850 on at

    Done that already. Same message. Thanks.

  • hersheys Profile Picture
    850 on at

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

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    12 on at

    Hi,

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

    Microsoft Dynamics GP menu >> Maintenance >> Check Links

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans