I'm trying to have the delivery date on purchase orders automatically calculated by using document date plus a value from the business partner master data (avragelate) which we are using as shipping time.
What I have as my query is the following:
Select $[$46.0.1]+t0.[avragelate] from ocrd t0 where $[$4.0.1]=t0.[cardcode]
This is however returning an internal error when it runs.
I have the formatted search set to run this query when the document date changes.