jdstuart 1/13/2021 3:18:49 PM

Update item price lists in SQL using eConnect

I've built a stored procedure to create and update inventory items using eConnect, for use in another application. It's working pretty well for the most part, but the total price in the price list is not populating. When I execute taIVCreateItemPriceListLine, the margin percentage shows up on the item price list card, but the total price for the line is still zero. Normally, this field auto-populates after you enter a percentage on the card or import a price list. I'm using option 5, which is %Margin. Is there another field I'm supposed to be populating, or some other way to trigger this?

Version: GP 2015
Section: eConnect, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3