Importing Consumable Assets into the alm_consumble table.

[AGibbs]

Hello Community.

I'm hoping I can get some help with this. I've crated 2 imports for consumable data. the first creates the consumable models with the following fields. Model Category, Manufacturer, Name, Short Description, Model No, and Cost which works fine. The 2nd imports the Consumable data with the following fields, Model Category, Model, Quantity, State, Substate and Stockroom. Problem is, the Cost in the Consumable form doesn't calculate to show the Amount from the import multiplied by the Cost from the Consumable Model it just shows Zero, but, when I create the Consumable manually it calculates the cost with no issues. Can you please help? 🙂

Regards

Al

[Ashok Sasidhara]

The following conditions are required for consumable records to merge:

1. The consumable cannot be listed on an active transfer order

2. The Model, Location, Model Category, Stockroom, Status, and Substatus fields on the record must match

Please check whether these criteria are met.

[Gibbs]

Thanks but i am not trying to merge records, I'm trying to import consumable data into the the consumable data table.