My guess is that the Makeup Qty is something to do with BoM therefore a lot of products wont have a BoM therefore you get 0

The product I'm currently focusing on is AE-CALIPER and has a BOM, it states "Available to make up 7.00"

print screen of my report in editor

When I run the report, I get this though.

And I assume you've added the Stock file to the joins?

Sorry, I'm stumbling my way through Sage reports, learning as I go, so I don't know what you mean, can you explain?

I could upload my report here if that would be any use.

In Report Writer Go to Report - Joins - see if the Stock file is there if not add the Stock file and join it to the SOP_Item file by STOCK_CODE

Thank you but its already there and linked, anything else that could be causing the issue?...unless I'm mis-understanding my join editor and it isn't right.

We need Ian Cairns to answer this one - it maybe that the join isn't getting the stock record for the line item. You may end up using the raw text editor and changing the join type. 

The report successfully pulls through free stock numbers correctly and other similar information so some my with my limited knowledge, it seems strange its pulling through some information but everything.

You mentioned Ian Cairns will need to answer this, is he likely to come across this or do I need to find/contact him?

Is it worth me adding a copy of the report here?

Hi Ross - Ian should be monitoring this chat and should respond at some point today. Is there anything company confidential that would need removing from your report before you upload it ? It would be useful to see your report and try it out myself.

Link for a copy of the report, 

https://drive.google.com/file/d/1TRL9H4yxonoXgAoXP2EswU6LJxkNriGs/view?usp=sharing

I've removed a couple of things from it, just images and text, nothing which should impact the report.

Hopefully you can figure out the issue, thank you.