Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Misc Tax Schedule ID (...
Microsoft Dynamics GP (Archived)

Misc Tax Schedule ID (MSCSCHID) does not exist in the Sales/Purchse Tax Schedule Master Table

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

I get the following exception when posting an invoice to Gp through eConnect.
Can some one help me to understand the cause of the issue and the possible fix for this? 
Thanks in advance..!!

Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned: 
Error Number = 311  Stored Procedure= taPMTransactionInsert  Error Description = Misc Tax Schedule ID (MSCSCHID) does not exist in the Sales/Purchse Tax Schedule Master Table - TX00102
Node Identifier Parameters: taPMTransactionInsert
BACHNUMB = MT_INV
VCHNUMWK = 755210
VENDORID = <![CDATA[C0VIVID]]>
DOCNUMBR = INV-0717
DOCTYPE = 1
DOCDATE = 10/26/2016
Related Error Code Parameters for Node : taPMTransactionInsert
MSCSCHID = Note: This parameter was not passed in, no value for the parameter will be returned.




*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Misc Tax Schedule ID (MSCSCHID) does not exist in the Sales/Purchse Tax Schedule Master Table

    Thank you for your response..!!

    We see this issue in production, client's machine, do not have access to their DB to run the profiler.

    Even I am unable to reproduce this error.

    I do not think this is related to vendor id as the error message clearly says the issue with the Tax Schedule ID.

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: Misc Tax Schedule ID (MSCSCHID) does not exist in the Sales/Purchse Tax Schedule Master Table

    I tried different combinations and couldn't reproduce the error.

    There should be the actual insert part of the Error which contains more of the Insert code.  Either in the Event logs, or may need to run SQL Profiler to get the insert statement, which is the stored procedure running.

    Also, is the VENDORID shown an actual Vendor, as at this stage the correct Vendor ID should be displaying.

    Mick

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