SageForum for UK versions of Sage 50- Help and support.

Hello,

I was wondering if there was a expression i could right that would allow me to pull the Quantity in Stock from a particular date because i am trying ot run a monthly report that has the opening stock from the start of the month. I am very new to this and i have exhausted my code/expression writing skills so any help would be much appreciated.

There is no stock level at a date expression, you have to work it out.

Either write the report so that you have all the items listed but hidden from printing using the date flag and a conditional expression on the section.
You then have a footer section on the date flag that prints the total (brought forward)

The alternative is to work backwards from now, so add up the quantities in the period and then take that from the current stock level.

Have a look at the product movement reports and the retrospective stock valuation and you will get some ideas.