Suppose a company is receiving cotton bales from vendor having production lot number and date of production. Company orders bales to vendor in pcs/units and weight is not known at initial. For each cotton bale being received company wants to maintain following data:
- Number of cotton bales received
- Production lot number, production and expiry date
- Weight (kg) of each unit of cotton bale
- and assign a serial number to each bale having certain weight
This is required to track weight of each bale unit stored in warehouse against its serial and production lot number.
To do this in AX, we created an item with following properties:
- Production type: BOM
- Item model group: FEFO
- Storage dimension: Site-warehouse
- Tracking dimension: Batch-Serial
Purchase unit: Each,
Sales unit: Kg
Now when we created a PO of 100 Units where each bale have a weight approx. b/w 10~20 Kg. And register it with actual weight, here we are able to manually assign a lot number, serial number and a weight (kg) for each unit of cotton bale received. But AX does not allow us to record weight more than 1 Kg against each serial number and gives error that “A quantity more than one can’t be updated against a serial number”. So we are not able to register exact weight of cotton bale against a serial number.
Is there any way in AX that we may able to record weight of each cotton bale and assign a tracking dimension of batch and serial number with it?
Any help/suggestion is highly appreciated.