How to include Stock Entry Item Table in Notifications?

[Sujay]

Hello,

I want to create an notification for stock entry.

In the message I would like to include the stock entry table where it should display Item Code, Item Name, Quantity, Basic Rate, Amount, Serial No, Warehouse(Target Warehouse)

Can anyone tell me how can I include that in the notifications?

Thanks & Regards,
Sujay

[ROHAN_JAIN1]

@Sujay you can do this by searching Notification List and you can enter the details as shown below in the image

in Message Field Area you can include desirable columns or fields Item Code, Item Name, Quantity, Basic Rate, Amount, Serial No, Warehouse(Target Warehouse)

Example for Message Field:-

<h3>Stock Entry Item </h3>

<p>Stock Entry{{ doc.name }} has been Created .</p>

<h4>Stock Entry Item Details</h4>

<ul>
{% for item in doc.stock_entry_item.length %}
    <li>{{ doc.stock_entry_item[item].item_code }}</li>
    <li>{{ doc.stock_entry_item[item].item_name }}</li>
    <li>{{ doc.stock_entry_item[item].quantity }}</li>
    <li>{{ doc.stock_entry_item[item].basic_rate }}</li>
    <li>{{ doc.stock_entry_item[item].amount }}</li>
    <li>{{ doc.stock_entry_item[item].serial_no }}</li>
    <li>{{ doc.stock_entry_item[item].warehouse }}</li>
{% endfor %}
</ul>

Note: For this, you should have knowledge of Jinja Template

Hope you find it useful

[Sujay]

Hello,@ROHAN_JAIN1

I have used your message code, but I got some error.

Attached the screenshots below;

Please help.

[ROHAN_JAIN1]

Suppose stock_entry_detal list contains:-

my_list=[{'item_code':'Item CODE 1','item_name':'Item Name 1'}{'item_code':'Item CODE 2','item_name':'Item Name 2'}])

So by the help of jinja Template, us can access those variable like this

<ul>
        {% for n in my_list %}
        <li>{{n.item_code}}</li>
        {% endfor %}
</ul>

[Sujay]

Hello, @ROHAN_JAIN1

I don’t have much knowledge about jinja template.

I just edited some field names in it and copied to my notification message.

I didn’t understand it.