Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formatted Search - Invoice & Credit Memo

I am trying to create a formatted search that calculates commission when an invoice or credit memo is added. We have a UDF where commission is entered when creating the Sales Order (U_CommPct).

Essentially, I need the following calculation to occur when the invoice or credit memo is added    

(Total Before Discount * U_CommPct)/100

Tags:
Former Member
replied

Hiiii  

i wrote this SQL query which satisfies your requirement ,  u will have to do little manual work like first add the invoice and then update udf to get the desired result . i would like some SQL EXPERTS to convert this SQL query into fms .

SELECT ( (((T0.DocTotal - T0.VatSum) - T0.TotalExpns )  * $[oinv.u_comm] ) / 100 )   FROM oinv t0  WHERE T0.Docnum = $[oinv.docnum.number]

Regards,

Ranu

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question