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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error number = 67
Microsoft Dynamics GP (Archived)

Error number = 67

(0) ShareShare
ReportReport
Posted on by Roberto Ribeiro de ... 120

Hi, 

    I have a error message, where can be the problem?

 

 

Sql procedure error codes returned: 

Error Number = 67  Stored Procedure= taSopHdrIvcInsert  Error Description = Subtotal does not match the line item totals

Node Identifier Parameters: taSopHdrIvcInsert

SOPNUMBE = 00100108

SOPTYPE = 3

Related Error Code Parameters for Node : taSopHdrIvcInsert

SUBTOTAL = 15.0000

 

 

Thanks,

 

Roberto

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Roberto,

    Are you passing in the Subtotal?

    Could you post your file?

    Kind regards,

    Leslie

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,061 Moderator on at

    Hi Roberto,

    Is this during a normal SOP Form entry (i.e. full GP client) or is this thru eConnect ? If it's thru the full GP client, looks like you got a corrupted SOP entry... you may try to run a checklinks against your Sales module to fix the issue (after having taken a full backup of course from your company DB).

  • deanne917 Profile Picture
    deanne917 2,035 on at

    Getting the same error - using SmartConnect.  I've tried it with a subtotal in the excel file and tried it without.  What's the trick here?  

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,061 Moderator on at

    Hi Deanne,

    Have you tried to post your question in the Forums about SmartConnect from eOne ?  I've not used the SC for the SOP module yet...

  • Community Member Profile Picture
    Community Member on at

    Deanne,

    In Smart Connect on the Create Sales Transaction node you can set the value of Calculate Subtotal From Lines and it will do that calculation for you.  Usually when this error occurs it's due to rounding issues in the subtotal provided and the line item calculations.

    Lorren

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 Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans