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
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,
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Mansi Soni as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 665 User Group Leader
Martin Dráb 595 Most Valuable Professional
Yng Lih 558
