Listers- I have run into a funky issue on our ARS 7.1/ITSM 7.0.3 system that seems to be caused by the addition of multiple CI records in the AST:BulkInventory form for the same product. The CI records look correct including relationships to storage location CIs and the Transactions table shows the Add of the received quantity correct. The problem is that when we use our custom app to fulfill a shipping request the only CI that is showing inventory available is the most recently created CI.
I recently refreshed my dev server from the production database so I have two data sets displaying the same behavior for the same product name. The older dev data has two CIs for this product but only the newest one has a record in the AST:InventoryQuantity form. The production data has both of these same CI records but also a newer one; here this third CI record is the only one with an AST:InventoryQuantity record. I say that the "bad" CI records don't have a record in AST:InventoryQuantity based on searching by Product Name as only one record is returned. I did also search by the Asset Instance ID with no matches except for the most recent CI record. The create date on the AST:IQ record matches the create date of the newest CI record as well. I also searched the BMC.CORE:BMC_Dependency form using the CI instance ID values and each CI record has a matching record there so it's just the InventoryQuantity records that seem to be a problem. Has anyone run into this problem before? Do I not understand how the AST:InventoryQuantity records are supposed to work? I am going to try manually creating the missing records on the dev server to see if I can get the older CI records working. -Rick _________________________ Rick Westbrock Remedy Administrator | IT Department 24 Hour Fitness USA, Inc. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
