Include Purchase Price in Items Report

  • Thread starter Randy Davis, CPA, MBA, MSIT
  • Start date


Randy Davis, CPA, MBA, MSIT

I have tried multiple ways, using Office Accounting's reports and using
Access to try and build a custom Items report that shows both the "Sales
Price" and "Purchase Price" of inventoried items. Where (what table) are the
"Purchase Price" values stored for inventoried items?



Lance [MSFT]

Look in InventoryItemAccountEntityView for the data for inventory items. The
column that holds the purchase price setting is 'PurchasePrice'

This posting is provided "AS IS" with no warranties, and confers no rights.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question