Hi,

I need to create a spreadsheet that lists all the Inventory items in a range with Jan - current (i.e. YTD) sales, current Qty on Hand, Qty on Sales Order, and Qty on PO. Modules currently installed include current versions of Inventory, Sales Anal. OE, and PO.

What is the best way to do this? (ie. Gridview??)

I can print a sales report from SA to Excel, but the item number and item desc data are merged into one column which is no good.

Thanks for any ideas.