You’re offline. This is a read only version of the page.
I tried to run my Chart of Accounts integration which has always worked in the past and I'm receiving these errors:
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Sql procedure error codes returned:
Error Number = 8085 Stored Procedure= taUpdateCreateAccountRcd Error Description = The Account Type is set to a Posting Account (ACCTTYPE = 1) and the Account Category (CATEGORY) passed does not exist in the GL Account Category Master table - GL00102
Node Identifier Parameters: taUpdateCreateAccountRcd
ACTNUMST = 0-1125-147-00
Related Error Code Parameters for Node : taUpdateCreateAccountRcd
ACCTTYPE = 1
CATEGORY = Note: This parameter was not passed in, no value for the parameter will be returned.
<taUpdateCreateAccountRcd>
<ACTNUMST>0-1125-147-00</ACTNUMST>
<ACTALIAS></ACTALIAS>
<ACCTTYPE>1</ACCTTYPE>
<ACTDESCR></ACTDESCR>
<PSTNGTYP>0</PSTNGTYP>
<Category>Balance Sheet</Category>
<ACTIVE></ACTIVE>
<TPCLBLNC>0</TPCLBLNC>
<USERDEF1></USERDEF1>
<USERDEF2></USERDEF2>
<PostSlsIn></PostSlsIn>
<PostIvIn></PostIvIn>
<PostPurchIn></PostPurchIn>
<PostPRIn></PostPRIn>
<ACCTENTR></ACCTENTR>
<USRDEFS1></USRDEFS1>
<USRDEFS2></USRDEFS2>
<UpdateIfExists>0</UpdateIfExists>
<NOTETEXT></NOTETEXT>
<DSPLKUPSSALES></DSPLKUPSSALES>
<DSPLKUPSIV></DSPLKUPSIV>
<DSPLKUPSPURCH></DSPLKUPSPURCH>
<DSPLKUPSPR></DSPLKUPSPR>
<RequesterTrx>0</RequesterTrx>
</taUpdateCreateAccountRcd>
Help?
Thanks.
Still researching this (or at least trying to) and I see the error 8085 relates to a possible E-Connect error. Since this integration has worked in the past and there were no changes, would it be safe to say that my problem isn't necessarily IM-related?
Thanks for any advice/help!
Jesus,
Thank you for your reply. I reformatted my spreadsheet and tried it again. It didn't work.
I was confused anyway because I didn't change anything on my original file that has worked up to this point.
Here's a sample of the correction and the error message I'm still receiving. It appears to be the same error message:
PSTNGTYP TPCLBLNC ACCATDSC ACTNUMST
0 0 4 0-1125-147-00
0 0 4 1-1125-147-00
0 0 4 2-1125-147-00
0 0 4 4-1125-147-00
0 0 4 0-1130-147-00
0 0 4 1-1130-147-00
0 0 4 2-1130-147-00
0 0 4 4-1130-147-00
0 0 5 0-1200-147-11
DOC 1 ERROR: Sql procedure error codes returned:
Error Number = 8085 Stored Procedure= taUpdateCreateAccountRcd Error Description = The Account Type is set to a Posting Account (ACCTTYPE = 1) and the Account Category (CATEGORY) passed does not exist in the GL Account Category Master table - GL00102
Node Identifier Parameters: taUpdateCreateAccountRcd
ACTNUMST = 0-1125-147-00
Related Error Code Parameters for Node : taUpdateCreateAccountRcd
ACCTTYPE = 1
CATEGORY = Note: This parameter was not passed in, no value for the parameter will be returned.
<taUpdateCreateAccountRcd>
<ACTNUMST>0-1125-147-00</ACTNUMST>
<ACTALIAS></ACTALIAS>
<ACCTTYPE>1</ACCTTYPE>
<ACTDESCR></ACTDESCR>
<PSTNGTYP>0</PSTNGTYP>
<Category>4</Category>
<ACTIVE></ACTIVE>
<TPCLBLNC>0</TPCLBLNC>
<USERDEF1></USERDEF1>
<USERDEF2></USERDEF2>
<PostSlsIn></PostSlsIn>
<PostIvIn></PostIvIn>
<PostPurchIn></PostPurchIn>
<PostPRIn></PostPRIn>
<ACCTENTR></ACCTENTR>
<USRDEFS1></USRDEFS1>
<USRDEFS2></USRDEFS2>
<UpdateIfExists>0</UpdateIfExists>
<NOTETEXT></NOTETEXT>
<DSPLKUPSSALES></DSPLKUPSSALES>
<DSPLKUPSIV></DSPLKUPSIV>
<DSPLKUPSPURCH></DSPLKUPSPURCH>
<DSPLKUPSPR></DSPLKUPSPR>
<RequesterTrx>0</RequesterTrx>
</taUpdateCreateAccountRcd>
The account Category is not Balance Sheet or Profit and Loss. That is Posting Type. The value that GP is expecting from the Categories file. Categories are like Cash, Accounts Payable, Long Term Debt, Sales, etc. There are 48 default categories in GP and you can add more categories if you like. The value that you pass has to be in the Categories table.
you can print a report from the Financial -> Setup to look for your categories.
Here's a partial sample of my file:
PSTNGTYP TPCLBLNC ACCATDSC ACTNUMST
0 0 Balance Sheet 0-1125-147-00
0 0 Balance Sheet 0-1130-147-00
0 0 Balance Sheet 0-1200-147-11
0 0 Balance Sheet 0-1200-147-12
0 0 Balance Sheet 0-1200-147-21
1 1 Profit and Loss 0-4000-147-31
1 1 Profit and Loss 0-4000-147-32
1 1 Profit and Loss 0-4000-147-33
1 1 Profit and Loss 0-4000-147-34
1 1 Profit and Loss 0-4000-147-35
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (