Fix Acumatica Kit Assembly Issue
Budget: $30 – $250 USD
Acumatica Experience is a must, will not work with anyone without prior Acumatica customization experience.
Issue is that when kits are being created they are taking the appropriate components ratio properly, however when we change an underlying component UOM from say a DRUM to GALLONS the cost correctly will change based on the unit conversion but the qty on hand and qty available do not.
This is causing us to be unable to release kits because while we may have plenty of of gallons in a Drum we do not have enough drums and because the line level of the kit is not changing to account for the inventory of the new UOM is keeps the inventory count for the original UOM, in this case DRUMS
Example:
1 Drum = 50 Gallons
We only have 1 drum available
Our kit says we need 30 gallons, but the base unit of the product is drum so it shows we have 1 available, when we go to change the UOM to gallons and enter the 30 it still says you do not have enough because it's still looking at the 1 qty available, even though 1 Drum equals 50 gallons so we have plenty.
Attached the red arrow shows the volume of drums (the base UOM) the bottom green arrow shows how many gallons we actually have because of the ratio
Issue is that when kits are being created they are taking the appropriate components ratio properly, however when we change an underlying component UOM from say a DRUM to GALLONS the cost correctly will change based on the unit conversion but the qty on hand and qty available do not.
This is causing us to be unable to release kits because while we may have plenty of of gallons in a Drum we do not have enough drums and because the line level of the kit is not changing to account for the inventory of the new UOM is keeps the inventory count for the original UOM, in this case DRUMS
Example:
1 Drum = 50 Gallons
We only have 1 drum available
Our kit says we need 30 gallons, but the base unit of the product is drum so it shows we have 1 available, when we go to change the UOM to gallons and enter the 30 it still says you do not have enough because it's still looking at the 1 qty available, even though 1 Drum equals 50 gallons so we have plenty.
Attached the red arrow shows the volume of drums (the base UOM) the bottom green arrow shows how many gallons we actually have because of the ratio