Quantities into Excel from Sage Pastel 17

[Colin1990]

Good day

I linked our database in pastel with Excel but I cant seem to get it to display the inventory quantity on hand. I made a odbc link and can query all other information as far as I know. Any help would be great!

Thanks in advance

[Kevin Smith]

Nothing pretty about that formula.
You need to access the multistoretrn table.
Add openingqty plus qtybuythis01-13 less qtysellthis01-13 add qtyadjustthis01-13 add qtybuylast add qtyadjustlast less qtyselllast together to get qty on hand, per storecode.
If you also want to take the unposted quantities into account, or reflect qty on sales and purchase orders - link the unposted file to your query