One of my customers requirements on their Sales Invoices is to have their SKU number listed along with our part/item number in the item table. I saw in the item doctype there is “customer Items Detail”. One of my developers states “but for fetching a table(Customer Item Codes) from item inside another table in the sales invoice will create a conflict” Would that cause issues to reference?
Firstly you have to create a custom print format for sales_invoice in that you can add your custom fields as per your requirements. And after that, you can fetch the Customer_SKU number on the following item table in sales_invoice.