I have come to the conclusion that at least in ITSM 7.0.3 there can be only one record in AST:InventoryQuantity for a specific product catalog entry. There is a filter (ASI:ALK:UpdateInventoryQty_500) which pushes to that form using this push field if qual:
( 'StorageInstanceID' = $zTmpStorageInstanceID$) AND (( 'Category' = $Category$) OR ( $Category$ = " " )) AND (( 'Type' = $Type$) OR ( $Type$ = " " )) AND (( 'Item' = $Item$) OR ( $Item$ = " " )) AND (( 'Product Name' = $Model$) OR ( $Model$ = " " )) AND (( 'Product Model/Version' = $Version Number$) OR ( $Version Number$ = " " )) AND (( 'Manufacturer' = $Manufacturer Name+ $) OR ( $Manufacturer Name+ $ = " " )) It appears that my problem is a combination of the business requirement to track bulk inventory items by PO/cost and the way our custom shipping module was built as far as selecting a CI to fulfill against. I am going to tweak the custom CI selection code in our app as I think I have a workaround for the bulk inventory problem. I know that having multiple CIs for a specific bulk inventory product is probably not best practice but the business requires it so I am going to try to make it work. -Rick _________________________ Rick Westbrock Remedy Administrator | IT Department 24 Hour Fitness USA, Inc. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Westbrock Sent: Wednesday, May 28, 2014 11:05 AM To: [email protected] Subject: Can you have multiple bulk inventory CI records for a single product? ** 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. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
