Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Chart of Accounts Inte...
Microsoft Dynamics GP (Archived)

Chart of Accounts Integration

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

Note:  Posted this earlier in the week but not to this forum.  Hoping that maybe it will be seen by a broader audience here.  Thanks!

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>

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

Thanks in advance for any help/suggestions!

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Chart of Accounts Integration

    You are most welcome

    Never hesitate to share any further inquiries,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Chart of Accounts Integration

    It worked, Mahmoud!

    Thanks so much.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Chart of Accounts Integration

    <Category>Account Category Description</Category>

    Include the Account Category Description in this parameter, not the account category number.

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Chart of Accounts Integration

    Mahmoud,

    Thank you.  I meant to include that someone suggested I put the category #'s in that column.  I tried that and it gave me the same error.

    Instead of the #'s (1-48) for categories, should I use the category word?

    Thanks.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Chart of Accounts Integration

    This is related to the account category, as I can see from your data set that the ACCATDSC has values of (balance sheet or profit and loss), these values are already passed as (1 or 0) under the posting type parameter.

    Under Account Category, you need to pass something like; Accounts Payable, Property, Plant and Equipment ... etc. According to the values included in GL00102

    The bottom line, the integration is checking for an account category of Balance Sheet or Profit and loss, which apparently does not exist.

    Please never hesitate to share any further inquiries,

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans