Hello
I'm trying to create a data base to my club were we recieved things for charity like food, clothes, furniture and other stuff
So I've created something basic to control the stock we have, were and the movements when it goes out.
It happends that on the report If I have just entry de products they don't list on the report.
on this example just shows bananas but I also have Orange and Chocolat but just entry no exit on the product.
And when I chekout a product it takes the product from all stores I have.
What I want to do is for example:
IN
10 BANANA TO STORE1
6 BANANA TO STORE2
4 BANANA TO STORE3
OUT 11 BANANA were
5 from STRORE1
2 from STORE2
4 from STORE3
The Report shows in the end
5 BANANA STORE1
4 BANANA STORE2
Any help on this?
Thank you