I need a simple Inventory Report for one group of inventory items.
This report needs to show the item name, Qty on Hand and SELLING Price.
Is there a way to add the selling price to a report under theSmart List Inventory Reports, or is this
crossing modules (inventory vs. sales) ?
TY
Mguyder
*This post is locked for comments
I do have a system report (thru reports List) that shows the 5 price levels but this is not exportable
and it is a bear to work with. (tiny print)
TY for your assistance
GP does not have anything that will show you price levels...so this would have to be a custom report. I have a blog post with code to show all price levels for all items:
victoriayudin.com/.../sql-view-for-inventory-price-levels-in-dynamics-gp. This could be used as a start, then you could restrict on the price levels you want to see and add the quantity on hand.
Our system uses 5 selling pricing levels, so I guess I would need the #1 and #5 selling price level
Can you please define what you mean by selling price? What you sold it for last time? What you sold it for every single time? What is on the Item Price Card in Item setup? Something else?
Most likely you're not going to be able to get this out of the box, but it would help to understand exactly what you're looking for.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
