Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by NCOPP

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

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Josh Page Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NCOPP 92 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No