You’re offline. This is a read only version of the page.
100
*This post is locked for comments
GP v. 10 SP3 (and whatever eConnect stored procs installed with that)
Here is the t-sql code I run. mssql query editor returns "(3 row(s) affected)"
even though the result set shows no update. What do you think?
Again thanks!
Cheers,
Matt
SET
@I_vITEMNMBR='MEETINGS &-50950-DM-DMA 'SET
@I_vVENDORID='TARG001'SET
@I_vUpdateIfExists=1EXECUTE @RC = [UNI].[dbo].[taCreateItemVendors]@I_vITEMNMBR
,@I_vVENDORID ,@I_vVNDITNUM,@I_vQTYRQSTN ,@I_vAVRGLDTM,@I_vNORCTITM ,@I_vMINORQTY,@I_vMAXORDQTY ,@I_vECORDQTY,@I_vVNDITDSC ,@I_vLast_Originating_Cost,@I_vLast_Currency_ID ,@I_vFREEONBOARD,@I_vPRCHSUOM ,@I_vPLANNINGLEADTIME,@I_vORDERMULTIPLE ,@I_vMNFCTRITMNMBR,@I_vUpdateIfExists ,@I_vRequesterTrx,@I_vUSRDEFND1 ,@I_vUSRDEFND2,@I_vUSRDEFND3 ,@I_vUSRDEFND4,@I_vUSRDEFND5 ,@O_iErrorState OUTPUT ,@oErrString OUTPUT
Thanks for the info. Wonder why they weren't inserting? Did you ever find out?
Could you send me an example of your data? What version eConnect, GP? This stuff should work...so its worth investigating.
Best regards,
Thanks Ian. This got me on the right track. I found the "taCreateItemVendors" eConnect stored proc. However when passing proper parameters it completed successfully but the records were not inserting/updating (UpdateIfExists = 1) in the IV00103 table.
I finally just wrote some t-sql (pasted below) to mimic the desired result of the stored proc.
--now find out if there is an item vendor master record--if not create it
select ITEMNMBR from UNI.dbo.iv00103 whereITEMNMBR
= @ITEMNMBRAND
VENDORID=@VENDORIDif @@ROWCOUNT=0 --insert recordbegin
INSERT INTO UNI.dbo.IV00103 (ITEMNMBR, VENDORID , ITMVNDTY , VNDITNUM) VALUES(@ITEMNMBR , @VENDORID, 2 , @ITEMNMBR)end
Have a look at the IV Vendor Item schema in the Inventory incoming schemas. This creates the vendor item number.
Best regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (