+2We 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!
Best answer by ShawnBerk
We made a separate warehouse with separate locations and all Supplier Consignment inventory goes in that Warehouse. Naturally segregated then. Connection Inv Trans Hist will be painful.
We made a separate warehouse with separate locations and all Supplier Consignment inventory goes in that Warehouse. Naturally segregated then. Connection Inv Trans Hist will be painful.
+2We 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 https://snaptube.cam/ Trans Hist using 9apps 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!
thankyou my issue has been solved
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
