econnect procedures PRE vs POST

(0) Share

Report

Posted on by DominicBeland

332

I have altered the taSOPLinIvcInsertPre procedure in which another procedure fetches a unit price.

when I run the PRE procedure, I can see that it works, I have the good unit price. BUt when I run the integration (from sartconnect) it doesn't get the UNitprice found in the PRE procecdure.

Is it possible that the taSOPLineivcinsertPRE procedure doesn't get triggered?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Tim Wappat 5,713 on at

Like (0)

Report
Copy link

Link copied!

It will be getting triggered, can you post your pre stored procedure SQL so we can diagnose.

I'm guessing you may not have assigned the unit price to the unit price variable?

Also what are you setting the DEFPRICING field to? (Default pricing)

Tim.

Was this reply helpful? Yes No
DominicBeland 332 on at

Like (0)

Report
Copy link

Link copied!

When I run the PRE procedure, the variable is good:

Notice I haven't provided any values for @I_vUNITPRICE.    so the PRE procedures does work and gives us the proper unitprice.

here's what we added to the PRE:

declare @oOrigUnitPrice numeric(19,5) ,
       @oOrigUnitPriceRND numeric(19,5)

select @O_iErrorState = 0

-- if @I_vUNITPRCE = 0.00
   begin
   EXECUTE [dbo].[JOV_Find_Price_sp]
       @I_vITEMNMBR
      ,@I_vUOFM
      ,@I_vCUSTNMBR
      ,@I_vDOCDATE
      ,@oOrigUnitPrice OUTPUT
      ,@oOrigUnitPriceRnd OUTPUT
      ,@I_vMRKDNPCT OUTPUT
      ,@O_iErrorState OUTPUT

   SET @I_vUNITPRCE = @oOrigUnitPriceRnd

   end

return (@O_iErrorState)
GO

Looking at the SQL Profiler when running the smartconnect map (and looking at resulting documents in GP), the unit price is 0. it looks like it's simply getting the "default" value instead of what the PRE procedure should have given it.

Was this reply helpful? Yes No
DominicBeland 332 on at

Like (1)

Report
Copy link

Link copied!

oh wait... I have to check about the DEFPRICING. indeed, looks like the solution.

Was this reply helpful? Yes No
DominicBeland 332 on at

Like (1)

Report
Copy link

Link copied!

Yes, I had the DEFPRICING switch ON.

switched it to OFF.

thanks!

Was this reply helpful? Yes No