Skip to Content
0
Former Member
Jun 23, 2008 at 04:04 AM

Automatic Delivery Date Calc with Formatted Search

48 Views

Hi,

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.

Any ideas?

Thanks,

Michael