When processing suppliers deliveries to fulfil orders we have to match items to orders awaiting dispatch. We use a query in the backend like this,
SELECT [IR_OrderNumberID],[IR_VersionCode],[IR_VersionName],[IR_Quantity]
FROM [DB_NAME].[dbo].[tblKartrisInvoiceRows]
WHERE [IR_VersionCode] like '%VERSION_CODE%'
ORDER BY [IR_OrderNumberID]
This returns a list of all orders placed that include the specified version. This means we can easily match deliveries and orders up if no other references have been used with the supplier.
A 'built in' system would be great (with a hyperlinked results table), with the ability to search open/closed orders, between specified dates etc.