By Kevin, Senior Application DeveloperThursday, December 8, 2011
When bringing in SOP transactions using SmartConnect, receiving an error that says “Error Number = 799 Stored Procedure taSopHdrIvcInsert Error Description = Tax table detail does not equal the tax amount. All the required fields are populated and the tax amount matches.”
To resolve this problem, make sure that the Sales Tax field in the Add line tax detail node contains the tax amount. When the Sales Tax field contains the correct value, the document is imported without errors. If the value in the Sequence Number field in the Add line tax detail node is 0, header level taxes are being used. When the value in the Sequence Number field is 0, you must set the value in the Header level taxes field in the Create sales transaction node to 1.