by COBS Tech Support » Thu May 15, 2008 10:33 am
Using the Report Wizard, "Purchase Orders Pending" would probably be the one you require.
Sostock->Delivery = expected delivery date
Sostock->Qty = quantity ordered
Stostock->Qtyd = quantity delivered
So you need to check:
Val(Sotock->Qty) > Val(Sostock->Qtyd)
for all undelivered items.
Also confirm that the order has not been closed or cancelled by checking for the status:
Sorders->Status = (status code)
The product code is Stock->Name
Are you querying STALTPC because you want to display your supplier's product code and not the system default code? (If so, you need to know a little bit more about the structure of that table, which we can help you with.)