Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Calculate Return taxes with eConnect

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

eConnect is not calculating taxes on my SOP Line, please advise. If I use the values on the SOP Entry screen tax is calculated. Here's my SQL code:

 

declare @p4 nvarchar(20) set @p4=N'' declare @p5 int set @p5=0 exec taGetSopNumber @I_tSOPTYPE=N'4',@I_cDOCID=N'RET',@I_tInc_Dec=1,@O_vSopNumber=@p4 output,@O_iErrorState=@p5 output select @p4, @p5

declare @p8 int set @p8=0 declare @p9 nvarchar(1) set @p9=N'' exec taSopLineIvcInsert @I_vSOPTYPE=4,@I_vSOPNUMBE=@p4,@I_vCUSTNMBR=N'0186', @I_vDOCDATE='2013-07-23 00:00:00',@I_vITEMNMBR=N'HG-910',@I_vQUANTITY=1,@I_vQTYONHND=1,@O_iErrorState=@p8 output,@oErrString=@p9 output,@I_vUNITPRCE=1110 select @p8, @p9

SELECT TAXAMNT, * FROM SOP10200 WHERE SOPNUMBE  = @p4

*This post is locked for comments

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans