web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
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 
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

I have the same question (0)
  • Mick Egan Profile Picture
    Mick Egan 3,561 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans