We have started using Consignment Stock for Supplier-owned stock. We want to be able to identify such stock within the “Inventory Part In Stock” data. I could join to Inv Trans Hist using the Part_no/contract/Lot_batch_no to get the CO-ARRIVAL record, but at 75 million Inv Trans Hist rows, even forcing an index takes a very long time in an SQL statement. Any ideas as to how I can include/exclude within some of our Inventory Part In Stock reports? We are running IFS2003!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.