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
This same thing happened again. I figured out how to delete these accounts and was able to recreate. I went to Mass Modify Chart of Accounts and pick "Delete" under the Modify: drop down selection. Enter the account you need to delete. Hit Modify at the bottom of the screen. Then once they are deleted, I was able to recreate the same accounts without any problems.
I just had this particular scenario happened to us and solved it going to cards>financial>Unit Account and deleting the account.
previous to deleting the account I did a select * from GL00100 where ACCTYPE = '2' to verify the status. The creation date was 6/28/2016 (so someone create it in the wrong place yesterday). No transaction in the inquiry window.
once we deleted the acct my finance mgr proceded to create the account again and it was fine.
I have a wonderful IT person that has been so involved with any of my GP issues. He was able to fix my issue. Here's what he sent me on how he fixed it.
In the company database having account issues, I located the bad Account records using the SQL query below.
I do not know how or why GL00100.AcctType was a value of 0:
-- We had three consecutive new accounts that were “bad”
SELECT ACCTTYPE, *
FROM GL00100
WHERE ACCTTYPE = 0
-- SQL for fixes below:
/*
-- For each bad Account, only once, run this commented section to generate a next NOTEINDX
-- For us on the “bad” accounts they were zero values as well
DECLARE @MyOutput table(
OldNOTEINDX numeric(19,5),
NewNOTEINDX numeric(19,5)
)
UPDATE DYNAMICS.dbo.SY01500
SET NOTEINDX = NOTEINDX + 1
OUTPUT deleted.NOTEINDX, inserted.NOTEINDX INTO @MyOutput
WHERE CMPANYID = 1
-- Make note of the NewNOTEINDX value and use in your GL00100 update(s) below
SELECT * FROM @MyOutput
SELECT NOTEINDX FROM DYNAMICS.dbo.SY01500 WHERE CMPANYID = 1
*/
/*
-- Fix each of the ACTINDX records by setting ACCTTYPE=1 and assign a generated next NOTEINDEX value
UPDATE GL00100 SET ACCTTYPE = 1, NOTEINDX = 5359559.00000 WHERE ACTINDX = 32311
UPDATE GL00100 SET ACCTTYPE = 1, NOTEINDX = 5359560.00000 WHERE ACTINDX = 32312
UPDATE GL00100 SET ACCTTYPE = 1, NOTEINDX = 5359561.00000 WHERE ACTINDX = 32313
-- Determined the needed items by examining GP stored procedure: dbo.smLoadDefaultAccounts
*/
I am having the same issue as of 4/1/2015. I setup one new expense account. It doesn't recognize it as a posting account. I see it listed under Unit Account, Variable Allocation, and Fixed Allocation, but if you select it it states it is not a 'unit', 'variable', or 'fixed' account.
You have looked up the account type in SQL - have you also looked to see if there is any data in the GL tables?
When you look at the GL00100 table, does the account number (s) in the table create a complete account number?
In this am looking to see if all the segements are populated?
How was the Chart of Accounts Created? Was it done manually, via Import or did you do a SQL table mapping move from another system?
Interested to know the answers.
Hi,
Have you tried to run checklink against account master. Please take a backup before running checklink.
Microsoft Dynamics GP menu >> Maintenance >> Check Links
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,
#1
André Arnaud de Cal...
291,904
Super User 2024 Season 2
#2
Martin Dráb
230,605
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
