hi
to record both carton quantity and weight quantity for an item in Business Central, you can use the Item Card to set up two additional fields: one for the carton quantity and one for the weight quantity.
To create a custom field for carton quantity, go to the Item Card, click on "Fields", and then click on "New". Select the data type as "Decimal" and give the field a name such as "Carton Quantity". Save the field.
To create a custom field for weight quantity, repeat the above steps, but this time name the field "Weight Quantity".
Once the fields are set up, you can input both quantities when creating an invoice or purchase order. Simply add both the carton and weight quantities in the appropriate fields on the invoice or purchase order line.
For items that have a set weight per carton, you can input the weight quantity as a fixed value in the Item Card.
For items that fluctuate in weight, you can input an estimated weight in the Item Card, but also leave some room for variance. When creating the invoice or purchase order, you can adjust the weight quantity as needed to account for any differences in weight.
To produce invoice lines as per your requirement, you can create a custom report using the Report Designer in Business Central. The report can be customized to include the carton quantity, weight quantity, and any other relevant information.
DAniele
