Sales Person Commission Report

mkpjsr

Hi experts

Some companies like to pay salespeople after the customer has actually paid for the goods & some on invoice. Plz guide e how can i customize sales commission report so that only paid invoices will display.

Chinmoy

There are possibly 2 ways to do this:

On top of the standard filters:

1. In the Cust. Ledger Entry dataitem filter Open = FALSE - this means that the invoice is fully paid and closed
2. In the Cust. Ledger Entry check if Remaining Amount < Amount (these are flowfields, so remember to use CalcFields if you have set any filter on the records) - this means that some amount is paid / adjusted against the invoice.

hope this helps.

Chn

hari_hh

HI!

There could be other scenarios you would like to cover before developing the report.

1.0 For a sales, is there a sales return? If so, is a commission payable?
2.0 When a sales occurs, there is a due date; when was the actual payment collected and if >, is commission payable?
3.0 If part payment is received, is the commission payable?

You can always prepare the report, as suggested by Chinmoy, from the ledger entries.