Good Morning,
I am not sure where to post this but I am working on a project for a screen printing company and am trying to add two additional drop down fields in the items subsection for color and size without having to add variants to each of the 200+ products that they use. I would like to add those two drop down lists right after Item Code. I understand that this might be a simple simple process for many of you but as I am a new programming student I have been beating my head against this for a couple days now. Any help would be appreciated.
Thank You
John May
I would recommend creating one that is correct/working, then export it to an XLS file (with sample data so you can see the layout etc). From there you should be able to easily copy/paste and create the data in tabular format, and then import it back in.
Data Import can be found in the Magic Search box or on Desk
Can anyone tell me where I can edit the layout for that particular table?
Hi @mayday1775,
open the DocType Sales Order Item (this is the item subtable) and add the two additional fields, check option “in grid view” to have them displayed in the grid. If you want this to be populated through from Sales Order to Delivery Note and Sales Invoice, apply the same changes to the latter.
Hope this helps.