Pastel report

[ChristiLee]

Good day,

My colleague is trying to pull a report in Pastel to compare monthly inventory stock against sales in order to do a purchasing forecast.

Does anyone know if there is a report such as this , as the graph option only allows one item at a time and I cannot find something similar, only sales on their own and inventory items etc. but not a way to integrate them in to Pastel or some such.

tx

[Neville Bailey]

It should be quite an easy exercise to plot such a graph in Excel, by typing in the stock value and the sales value, per month, as data points.

It's also possible to create a custom BI report.

[ChristiLee]

Thanks Mr Bailey,

I ended up pulling an inventory summary to excel and it can be sorted and formulated there.

Thanks.

More questions on the way