STD pricing items

[uff555]

I am trying to create a report to show sales by item, unit price, and price list used. Then I want to compare the used price list price to the STD price on the price list.

I cannot seem to find the STD price objects. I am checking the ICPRIC table for matching items. No dice

 

[DjangMan]

ICPRIC will have the unformatted item number and the OE tables will have the formatted item number.

 

[ettienne]

Accpac version?

 

[uff555]

5.4a

 

[ettienne]

ICPRICP.UNITPRICE

 

[uff555]

Now I see what you are saying. How might I convert the formatted item name to a formatted item name.

 

[ettienne]

Link ICITEM, this table has both the unformatted and formatted item no.

 

[uff555]

It was way too hard to get the STD prices via Crystal.

I decided to create a view in my database to show all items and their STD pricing. I was able to include this in my report and get the result I was looking for. Thanks for all the help.