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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PO/Purchasing Batc...
Microsoft Dynamics GP (Archived)

PO/Purchasing Batch Posting Error

(0) ShareShare
ReportReport
Posted on by Matthew Snyder 100
When I post a purchasing batch I get the error "Item's vendor record doesn't exist." The origin of these transactions are from a purchase order created via eConnect. After some research I found that once I update the record in table IV00103 (IV_Item_MSTR_VNDR) associating the item with a vendor with the correct vendor I'm able to post. So my question is: Is there a eConnect object/stored proc I can use to update/create this record?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    Re: PO/Purchasing Batch Posting Error

    Have a look at the IV Vendor Item schema in the Inventory incoming schemas. This creates the vendor item number.

    Best regards,

  • Matthew Snyder Profile Picture
    Matthew Snyder 100 on at
    Re: Re: PO/Purchasing Batch Posting Error

    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 where

    ITEMNMBR = @ITEMNMBR

    AND VENDORID=@VENDORID

    if @@ROWCOUNT=0

    --insert record

    begin

    INSERT INTO UNI.dbo.IV00103

    (ITEMNMBR

    , VENDORID

    , ITMVNDTY

    , VNDITNUM)

    VALUES

    (@ITEMNMBR

    , @VENDORID

    , 2

    , @ITEMNMBR)

    end
  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: PO/Purchasing Batch Posting Error

    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,

  • Matthew Snyder Profile Picture
    Matthew Snyder 100 on at
    Re: Re: Re: Re: PO/Purchasing Batch Posting Error

    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=1

    EXECUTE @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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans