We sell item in units, however for ease of customers we have to show the number of carton for each item.
For this, I created a custom field “Units in Ctn” in Items doctype. Now while making sales invoices, as soon as the user select a product I want fetch the “Units in Ctn” from Items table as readonly field.
Also after user enter the Qty, I want to show Total ctns in another readonly field
Please guide on how this can be achieved.
Once this is done then I can update my Sales Invoice print format to show Ctns as well as Units.
@anand I tried this. A new field is showing up in “sales invoice item” but now fetching the units_in_ctn whenever an item is selected? An idea why?
If it is fetching isn’t that what you wanted?
sorry typo. Its NOT fetching the units_in_ctn whenver an item is selected.
This is an interesting feature and we ate struggling to put a count on units in a carton. If you could look at adding it as a base feature that would be great. At least please add this on your list of potential features.
Its not fetching the data. I have added a new custom field “units_in_ctn” in “Sales invoice item” and written following code “item_code.units_in_ctn” in options. But nothing happens. An other idea?