Hello,
I am tracking units by their serial number, their buying price, selling price (B2B company) etc. I have this query:
Problem with this query is that it only shows units that have been bought and sold. I can't find a solution to show all units (for example a unit which has only been bought from a supplier and is, therefore, in stock)...
In that case, the selling price would be either NULL or a zero.
Can anyone give me some advice?
Thank you very much!
Tomas