Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / posting account: acctt...
Microsoft Dynamics GP (Archived)

posting account: accttype =0 and noteindex - 0.0000

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We created a posting account (or what should be a posting account) of income statement type, but are unable now to post to it or to pull it up in cards to delete or modify.

When pulling it up in account maintenance, an error message says that this account is not a posting account.

When pulling it up in unit account maintenance, an error message says that this is not a unit account.

I didn't create the account but our standard practice is to pull up an existing account of the same basic type, save (to pull all the posting settings) and then create the new account.

The two anomalies in its setup in GL00100 seem to be that its accttype is 0 zero but should be 1 and its noteindex is 0.0000. 

I ran maintenance >> check links against the Account Master but no errors were found.

Can anyone advise how we can repair this account?

Thanks

Paul

We're on Great Plains Dynamics GP 10.0 version 10.00.1579

Dexterity 10.0.331.0

SmartList 10.00.1549

DB Sql Server

System Windows Server 2008

 

Paul

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: posting account: accttype =0 and noteindex - 0.0000

    We have this same issue ... did you get it resolved?

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: posting account: accttype =0 and noteindex - 0.0000

    Paul,

    I will suggest you to run checklink and Reconciliation on Accounts Master.

    That may repair data.

    Thanks

    Sandip

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: posting account: accttype =0 and noteindex - 0.0000

    I would start by looking to see if there are any other accounts like this.

    Step 1)Select * from GL00100 where accttype=0

    Step 2)Select * from DYNAMICS..SY001500 and note the NOTEINDX for this company by looking at INTERID

    Step 3)select dex_row_id from gl00100 where acctype=0 and make note of the dex_row_id value

    then

    Step 4) update GL00100 set ACCTTYPE=1,NOTEINDX =Value from Step 2 where DEX_ROW_ID = Value from Step 3

    finally

    Step 5) Update DYNAMICS..SY01500 set NOTEINDX=NOTEINDX+1 where INTERID = value from Step 2

    Of course. make a backup of your DYNAMICS and company database and do this while no one is using GP.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans