Referencing Customer Item Codes in the Item Doctype to the Sales Invoice

[pokermagic]

Hi,

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?

Thank you.

JR

[Vaibhav_Parmar]

can you provide ss so it would be great to see what exact problem you’re facing?

[pokermagic]

Vaibhav,

Thanks for responding, but sorry what is ss?

Thanks.

JR

[Vaibhav_Parmar]

ScreenShots…!!

[pokermagic]

Dear Vaibhav,

Yes. So here’s the Sales Invoice “Print Format”

And i want to add a column for “Customer SKU”

In the Item Doctype there is …

Does it cause a problem if trying to access the Customer Item Codes from within the Sales Invoice Item table?

Thanks.

JR

[Vaibhav_Parmar]

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.

like using these 2 links,

Print Company and Customer Tax ID in sales invoice

Hey Guys, I am traying now for 2 hours to add hte customers tax id to my invoices, with no success. Can anybody explain just step by step how to do it? I tried to create a custom field as in the description above. The field showed up in my invoice from customization panel but has no effect, what did I do wrong? see the screenshot [image] I also tried to add the script as described here: https://frappe.github.io/erpnext/user/manual/en/customize-erpnext/custom-scripts/custom-script-examples/c…

.
.

How to print custom fields in custom print formats using print format builder?

We want to print transport details and other Custom Document fields like VAT ID from doc type Customer in Sales Invoice and other print documents but are unable to add it from the field list in the left bar. Can these be added using custom html field, What code would we have to write in custom html to fetch these fields.

refer to this link to create a new custom print format.
https://docs.erpnext.com/docs/user/manual/en/customize-erpnext/print-format

[pokermagic]

Vaibhav,

Thanks for the direction. I have made the custom print format so i’ll look at the other post and see if i can make it work. Thanks for you help.

Regards,

JR

[kennethsequeira]

@pokermagic after the setup done as shown in the item, open a sales transaction like Sales Order or invoice.

Now select the customer Tesco Techonologies Inc. and this particular Item and save the order.

Open/expand the item table’s row. There you should see the customer’s item code fetched automatically. What you’re requesting should be the default behaviour in the system already.

All you have to do now is customize the print format as suggested to add the column.