Skip to Content
Former Member
Jul 23, 2012 at 03:53 PM

How is the Item Price Linked to an Item in Item Master?



I know that prices are stored in rows in the ITM1 table along with a PriceList ItemCode fields.

I have one populated price list in my B1 db which is list #1 and I named it Master. The name shows up in OPLN.

In the ITM1 table, however, at present there are 10 rows for each OITM row, keyed by ItemCode and PriceList fields. 2-10 are currently unused.

OK, so my question is this: How is the underlying association formed between the price in the ITM1 table and the Item in the OITM table? I cannot see any foreign key that would associate the OITM row with a particular ITM1 row, yet the Item Master form in B1 knows to show me "Master" as the Price List.

I am looking for the sql to get the price of an Item given a designated OITM row.

What it really boils down to is how do I get the PriceList key for the OITM table select given an OITM row?

Thanks in advance,