ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Question on Items table Sales Order Print Format

customization

#1

Hi everyone-
I have a custom print format based on sales order. The print format shows only the supplier name in the items table as this is what I sent to the trucker to let them know where to pick up. Currently, it will list out the supplier for each item. I would like to only list the supplier ONCE on this sheet.

For instance, I am ordering five different items from supplier and it will show that supplier five times. I would like to only show the supplier name once. Any ideas on how to achieve this? I am on ERPNext Cloud.

thanks!
Heather


#2

Hi @charlie-cook,

Here’s a kind of a hacky solution but I think it should work for you.

You can do it by adding a custom HTML with following code

<div class="row">
	<div class="col-xs-5">			
		<label>Supplier</label>
	</div>
	<div class="col-xs-7 value">
				{{doc.items[0].supplier}}
	</div>
</div>

This will only show the Supplier name of first item. But since every item in your Sales Order is from the same supplier, it should not matter.

Your print preview should look something like this

Hope that helps

Best,
Suraj


#3

Thanks, that helps a bit but the problem is that most orders have 10-12 suppliers. I was simply using the one supplier with 5 items as an example of why it would duplicate the supplier. :frowning:

Thanks again!
Heather