Formula to populate a field on Sales Order with total quantity of products orered

[jeffreysgrossman]

I am trying to come up with a formula to sum the quantity of products ordered on a sales order. I have tried several different approaches but so far nothing works. I have asked AI models but everything suggested also does not work. Is it possible to have a formula to populate a field on a sales order with the number of products ordered?

The Total Product Quantity field is the one I am not able to populate. The Total Unit Count is just the weight feild relabled. So that is why that is working.. However I am not able to come up with any formula to try and do the same type of thing and sum the quantity per line of items on the sales order..

So for this screen shot. I would want the formula to produce the number 5 in that field
This was a suggestion for a formula from an AI mode: totalProductQuantity = SUM(entity\getLinkMultiple('items'), 'quantity');

However that does not work either..

Thank You,

[lazovic]

Hi jeffreysgrossman,

Please try to use the following formula script:

totalProductQuantity = entity\sumRelated('items', 'quantity');

[jeffreysgrossman]

@Iazovic I just tried that again.. So far it does not populate the field with any results for me?

I have also tried several other variations with no results populating the field. I have other scripst working but this one just seems to elude me?

[lazovic]

jeffreysgrossman,

There are several reasons why this formula script might not work for you:

1. You haven't updated the record (for the formula script to work, you either need to create the record or update some value of its attribute).
2. Your attribute for calculating the total number of products is specified incorrectly. You can check this if you go to Administration > Entity Manager > Sales Order > Fields and check what exact Name is specified for the Total Product Quantity field.

Also, please note that to update the value of this field for all Sales Orders in the system, you should go to the Sales Orders list view, select all the results, click on the Actions button, and select the Recalculate Formula action:

[jeffreysgrossman]

This worked. Looks like i had a bad name.. System added a c in front of the actual name. Thank you so much!

[lazovic]

jeffreysgrossman,

Glad I could help you.

It's normal for the system to add a prefix to your field name. You can find out more here: https://github.com/espocrm/espocrm/issues/2988.