Inventory forcast report

Mar 12, 2007 1 Replies

Does anyone out there have a item forcast report - ie I want to be able to take a time period (say the last 4 months) and repot on items (brocken down by venodor or linked to vendor) on what was sold for that period of time- Including those things that did not sell (that we have an reorder point and restock level)- I would like to have on that report sku number, desc, qty (in stock), restock and reorder point, last sold, supplier name, and qty sold (for a given amont of time)



Right now I have done some of my own SQL gerry rig stuff... it is ugly but it works. I rely on starting with the Top Item report, but it does not pick up for some reason the items not sold (that I may have a restock and rorder point on)...



Any way this report is soooo important.. every other major POS software has this and more. I have been begging for this report for years... no one seems to listen...



How does crystal report writer work?



Do you think that 2.0 might have this?



Thanks Brent


Hi Brent, Just change the query of Sales Top Items.grp to this then it will show you the items which got sold or not doesn't care: TablesQueried = "FROM TransactionEntry WITH(NOLOCK) INNER JOIN [Transaction] WITH(NOLOCK) ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber RIGHT JOIN

Item WITH (NOLOCK) On TransactionEntry.ItemID = Item.ID LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryID = Category.ID LEFT JOIN Department WITH(NOLOCK) ON

Item.DepartmentIDÞpartment.ID"

And also if this not help you let me know if I can help you to devel> Does anyone out there have a item forcast report - ie I want to be able to

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required