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,
- Nick
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156