Target

[Former Member]

Hi Friends,

I Have to Set Sales Target(Annually) for all my Sales employees

where i can set this in SAP B1? or i have to go for UDF Pls tell me

And

I need a Report i should have the following informations

1)Employee Name

2)Target Amount for that Employee

3)Sale target he acheived

If it possible pls write query and send to me

i m waiting for ur reply Friends

Sankar

[former_member187989 · Accepted solution]

hi sankar,

Add a UDF with type Unit and Totals and structure Amount.

Tools>User Defiend Fields>Manage User Defined Fields>Master Data>Sales Employee

Go to Administration>Setup>General-->Sales Employee

You can find UDF at last column.

Enter sales target amount for each employee.

In customer master update sales employee,so that

it flow into AR invoice.

Paste below query in query generator.

Open Query generator >Click Execute>Error message will

show at status bar--> Clcik pencil below orange arrow -->

Delete the query already there --> Paste below query

SELECT T0.[DocNum], T0.[DocDate],T1.[SlpName], T0.[DocTotal]- T0.[VatSum] as 'Sales Value', T1.[U_trgamt] as 'Sales Target Amount'

FROM OINV T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode WHERE T1.[SlpName] ='[%0]'

Hope above answer will solve your problem at least to an extent.

Jeyakanthan

[Former Member]

Dear Sankar,

It would be a much better idea to achieve this functionality through UDF and FMS but it can also be achieved through SDK..

From the GUi there is an option of tracking the sales made by the Sales Person through Commissions.

Regards

Arshdeep