Hi All,
I'm trying to create a field using Studio (hosted server, cannot access Pycharm).
My intention for adding this field, is so that we can see the outstanding order values for our customers. I would then like to re-create this feature for purchased parts too, within the Purchase module.
I've noticed, via Studio, that there is an invisible field called 'To Invoice Quantity'. I'm trying to add a compute field that follows the below:
To Invoice Quantity * Unit Price
I only want this field to show for products where the unit price is above £0 (not FOC)
From this, I will be able to use the reporting module to calculate the outstanding order values, grouped by customer.
Any help will be great, thank you