Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to resolve Error N...
Microsoft Dynamics GP (Archived)

How to resolve Error Number = 11479 ?

(0) ShareShare
ReportReport
Posted on by chan boon hong 55

i using the econnect 11.0

while i try to trigger the <PMTrxEConnect > i getting the error below

Sql procedure error codes returned:
Error Number = 11479  Stored Procedure=   Error Description = Error Codes were not found in table DYNAMICS..taErrorCode. Please insure that the table taErrorCode is up to update. 11479


<taPMTransactionInsert>
 <BACHNUMB>PIDM_PM_27-09-11</BACHNUMB>
 <VCHNUMWK>00000000000000038</VCHNUMWK>
 <VENDORID>ABC</VENDORID>
 <DOCNUMBR>TRV00540</DOCNUMBR>
 <DOCTYPE>1</DOCTYPE>
 <DOCAMNT>1500.00</DOCAMNT>
 <DOCDATE>2011-09-20</DOCDATE>
 <PSTGDATE>1900-01-01</PSTGDATE>
 <PRCHAMNT>1500.00</PRCHAMNT>
 <CHRGAMNT>1500.00</CHRGAMNT>
 <CREATEDIST>0</CREATEDIST>
</taPMTransactionInsert>

 

 

can i know how to resolve this ????

*This post is locked for comments

  • chan boon hong Profile Picture
    chan boon hong 55 on at
    Re: How to resolve Error Number = 11479 ?

    thanks,

    it work just fine

  • Chris Roehrich Profile Picture
    Chris Roehrich 289 on at
    Re: How to resolve Error Number = 11479 ?

    You have a couple issues with this one....

    First, the error 11479 indicates the following problem:

    No Checkbook ID has been passed for the new batch number - pass a batch checkbook id (BatchCHEKBKID) or add a default checkbook in Payables Setup

    This is resolved if you pass the checkbook ID on the batch to the BatchCHEKBKID in taPMTransactionInsert or use a default checkbook ID in Payables Mgmt.  There is actually a bug written up on this issue (61256) where eConnect does not retrieve the checkbook id.  If you don't know what the value is for the checkbook ID (even  then a pre procedure can be used to get the existing checkbook ID for that batch number and pass it to BatchCHEKBKID.  

    The second issue is that itappears the taErrorCode table in DYNAMICS database does not have an error code for 11479.  I am not sure how you are in this situation but it can be populated with the following insert statement:

    insert into DYNAMICS..taErrorCode values

    (11479, 'taPMTransactionInsert','No Checkbook ID has been passed for the new batch number - pass a batch checkbook id (BatchCHEKBKID) or add a default checkbook in Payables Setup',

    'BACHNUMB VCHNUMWK VENDORID DOCNUMBR DOCTYPE DOCDATE','BatchCHEKBKID')

    If you would like to work with us in Dynamics GP Support regarding the 11479 error due to the checkbook ID problem, please open a support case as you could be running into the bug I mentioned.   Issues due to bugs are not chargeable support incidents.

    Thanks,

    Chris Roehrich

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How to resolve Error Number = 11479 ?

    Hi Chan, got your email there. Its a weird one alright. Not something I have come across before. Let me research and see what can be done.

    Ian.

  • chan boon hong Profile Picture
    chan boon hong 55 on at
    Re: How to resolve Error Number = 11479 ?

    anyone ?

  • chan boon hong Profile Picture
    chan boon hong 55 on at
    Re: How to resolve Error Number = 11479 ?

    Anyone ?

  • chan boon hong Profile Picture
    chan boon hong 55 on at
    Re: How to resolve Error Number = 11479 ?

    Anyone can help me take a look on my issue ? i urgently needed. thanks pls...

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