Syntax Error when Linking Doctypes Via Server Script

ERPNext
1

Hello,
I hope you’re well.
I am trying to achieve an automatic creation of delivery note from sales order upon submission.
I have written this script but in order to link the docs, I need to populate the ‘items_to_load’ against the sales order.
The Script

image
image853×486 17 KB

`items_to_load = [“against_sales_order”:doc.name, “sales_order_item”: doc.item]
for item in doc.items:
items_to_load.append({‘item_code’:item.item_code,‘rate’:item.rate, ‘qty’:item.qty, ‘uom’:item.uom})

#Create the Delivery Note
frappe.get_doc(dict(
doctype = ‘Delivery Note’,
title = doc.customer,
customer = doc.customer,
company = doc.company,
docstatus = 0,
items = items_to_load,
)).insert()

frappe.msgprint(msg=(f’Delivery Not for {doc.customer} has been created’),title=(‘Automation’), indicator=‘green’)`

Error I get upon Sales Order Submit

SyntaxError: ('Line 1: SyntaxError: invalid syntax at statement: \'items_to_load = ["against_sales_order":doc.name, "sales_order_item": doc.item]\'',)

I’d really appreciate some assistance.

2

hello, you may want to use {} with key value pairs like:
items_to_load = [{“against_sales_order”:doc.name, “sales_order_item”: doc.item}]

1 Like
3

Thank you for the response.
That solved the problem but now I’m facing another error unfortunately.

image
image879×461 16.3 KB

The script includes the quantity field so why is it showing this error message?

image
image971×301 10.4 KB

4

@Rashid_Salim delivery notes can’t have items with 0 quantity

5

Hi,
There is a quantity set on the item in the sales order. See below

image
image862×521 19.8 KB

I have also selected the source warehouse and still the issue persists.

6

Hi PyJumber,

I posted a secondary problem. Could you have any idea why it’s causing an error?

Thank you

7

Hello Rashid, can you post the whole server script code, i will try to look into

8

Here’s the code below:

items_to_load = [{“against_sales_order”:doc.name, “sales_order_item”:doc.items}]
for item in doc.items:
items_to_load.append({‘item_code’:item.item_code,‘rate’:item.rate,‘qty’:item.qty,‘uom’:item.uom})

#Create the Delivery Note
frappe.get_doc(dict(
doctype = ‘Delivery Note’,
title = doc.customer,
customer = doc.customer,
company = doc.company,
docstatus = 0,
items = items_to_load,
)).insert(ignore_permissions=True)

frappe.msgprint(msg=(f’Delivery Not for {doc.customer} has been created’),title=(‘Automation’), indicator=‘green’)