Report to include all prices from multiple tiers (HELP!)

(0) Share

Report

Posted on by Greg Wartes

1,200

PLEASE HELP:

I need to export 2,000+ inventory items with item number, price level and price. I have had no problem getting the default price level to display - but need the others as well as their prices. I have been through every smart list option and have tried to add columns with no success. Can anyone point me in the right direction? I need this report yesterday. Thank you in advance to any and all help!

*This post is locked for comments

All responses (3)

Answers (0)

Greg Wartes 1,200 on at

Like (0)

Report

Re: Re: Report to include all prices from multiple tiers (HELP!)

Thank you all - I have been able to get all of the items into excel per your suggestions!

Thank you,

GW
Victoria Yudin 22,766 on at

Like (0)

Report

Re: Report to include all prices from multiple tiers (HELP!)

Greg,

This is not exactly what you are looking for, but it may help get you started: http://victoriayudin.com/2009/01/07/sql-view-to-show-customer-pricing/.
Community Member Microsoft Employee on at

Like (0)

Report

Re: Report to include all prices from multiple tiers (HELP!)

Hi, The tables you are interested in, are - Item Master (IV00101) and Item Price List Options (IV00107).

I don't believe there is a smartlist option that will give you this data, but I could be wrong and am prepared to stand corrected!

There is a standard report you can run which gives you this info. Reports >> Inventory >> Item >> Item Price List Options List. You could modify the report to exclude headings etc, and export it to a .csv file and then open it in XL.Or you could use smartlist builder to create a smartlist drawing from the two tables above. Or MSSQL reporting services.

Hope this helps.