How to avoid consumables from merging while creating assets in stockroom

[Asmita7]

Hello Friends,

I am onboarding consumables in bulk. I am facing an issue :

I am using a transform map to upload consumables to alm_asset table. This data includes PO number and PO Line Item number. The scenario is :

1. I have one PO : PO258

2. This PO has PO Line Item POL101  with "HP Backpack"

3. This PO has one more PO Line Item POL102  with "HP Backpack"

In both the PO Line Items, the consumable model is same.

When the record is created in alm_asset table, due to some OOTB functionality, it is creating only 1 consumable record with quantity 2.

My requirement is that it should create separate consumable record for each PO Line Item Number irrespective of model.

Please suggest.  

[Its_Azar]

Hey there @Asmita7 

First, review the out-of-the-box functionality that is causing consumables to merge. This could be due to default setting.

Since you are using a transform map to upload consumables to the alm_asset table, you can customize the mapping to ensure that separate consumable records are created for each PO Line Item Number.

In transform map, adjust the transformation logic to handle each PO Line Item Number separately. You can modify the script or mapping rules to ensure that a new consumable record is created for each unique PO Line Item Number, regardless of the model.

If the OOTB functionality does not allow for the desired behavior, consider using scripting to customize the creation process. You can write scripts to parse the incoming data and create separate consumable records based on the PO Line Item Number.

If  this helps kindly accept the answer thanks much.