Help With UDF & FMS

31 Views

Hi All,

I am having a little trouble with a UDF and a FMS search at the moment and am hoping somebody can help me.

The UDF created on the OCRD is a Service Fee that gets applied when a customer purchases a few selected items. There are three service fees namely 6.38, 11.28, and 0.00 that I have created.

I have created the same UDF on Marketing Document Rows and with a FMS that field gets populated without any problems. I have created another UDF on Marketing Document Rows called Service Fee Total. This field times the quantity by the Service Fee UDF without any problems.

Here comes the problem.

If I create a document with more than one line item and both line items have a Service Fee Total I want them to be added together and then the total inserted into the discount field so that the amount can come off the total of the document.

A FMS that I use has a query attached to it that looks like this

SELECT SUM($[$38.U_ServiceFeeTotal.Number])

however this does not work as it only sums the first line.

If anybody understands what I am trying to do here could you please give me some advice on how to get this working.

Any help appreciated.

Regards,

Quinn