Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Combining Creation of new items using SQL taUpdateCreateItemRcd and ensuring Pricing Record Creation IV00108

Posted on by 88

We've written procedures to leverage the built-in GP procedure taUpdateCreateItemRcd to create new items dynamically.  I'm trying to understand if there is a way to ensure that a corresponding record gets created in IV00108 (Item Price List) using existing currency, etc..  We can do it by pulling the new items from IV00101 and forcing the creating in the IV00107 andIV00108 tables, but I think it would be better to leverage the GP procedures for doing this.  Thank you.

- Nick

  • NCOPP Profile Picture
    NCOPP 88 on at
    Combining Creation of new items using SQL taUpdateCreateItemRcd and ensuring Pricing Record Creation IV00108
    I am following up on this post. I am now back in a position where I would like to call both the taUpdateCreateItemRcd and both

    taIVCreateItemPriceListHeader and taIVCreateItemPriceListLine. I've created a script that will call all three and I've placed it into a transaction. Before rolling back, I'm looking at the tables to see if my new test item has been added and it has not.

    So, I've commented the Price List proc calls and am looking only at taUpdateCreateItemRcd. I notice that it does not throw an error but the @O_iErrorState and @oErrString outputs have the following values, respectively, 505 and 2234 505. I'm trying to understand why I'm not seeing the item in the table prior to rollback and wondering what the error state and error string means.

    *** UPDATE ***

    I was able to determine that I made a typographical error in the Class ID that I was using. Fixing that resolved my issue.  It is possible to construct a script where you create items, based upon a class, and then assign a price list to the newly created item, using the procs mentioned here.

    I've been trying to mark Josh's comment as the answer (or at least part of it), but it is not allowing me to do so.

    Thanks,

    - Nick

  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at
    RE: Combining Creation of new items using SQL taUpdateCreateItemRcd and ensuring Pricing Record Creation IV00108

    The two EConnect procs that you need to create the item price list are below.

    taIVCreateItemPriceListHeader

    taIVCreateItemPriceListLine

    You would need to import the item with EConnect and then you would use the two above to create the pricelist for the item.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans