Commissions report on paid invoices.

(0) Share

Report

Posted on by Rosemary Roopnarine

455

I would like a report which can be used to pay commissions on invoices which have been paid, not on sales. This is a repquest from our Credit Manager.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Rosemary, you'll need a custom report for this. It could be created in Report Writer, Crystal, or SSRS.

Was this reply helpful? Yes No
Rosemary Roopnarine 455 on at

Like (0)

Report

Which RM tables would be the most appropriate to use?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Do you use Sales Transactions, Invoicing Transactions or Receivables Transactions to do your invoicing?

Was this reply helpful? Yes No
Rosemary Roopnarine 455 on at

Like (0)

Report

Sales Transactions

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Then you'll likely want to use SOP30200, SOP30300, RM20101, RM20201, RM30201.

Hope this helps,

Was this reply helpful? Yes No
Rosemary Roopnarine 455 on at

Like (0)

Report

Yes, it does, thanks much

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Rosemary, just adding my two cents worth...

You will want to select transactions where the amount remaining (CURTRXAM) = '0'. These are fully paid documents. You will also probably want to select those documents where the latest payment date is in the last month - otherwise you will be paying commissions repeatedly on fully paid documents!! - to get this data you will want to look at the Apply tables.

Your other option is to use the GP commissions functionality. There is an option in Tools >> Setup >> Sales >> Receivables... 'Pay Commissions after Invoice is paid', which may be of interest.

Best regards,

Ian.

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

What we typically do when commissions are tied to customer payments is create the report starting with payments. In other words, first find all the payments in your date range, then see what invoices they were applied to. Some views that might help:

All posted AR transactions:

victoriayudin.com/.../sql-view-with-all-posted-receivables-transactions

AR apply detail:

victoriayudin.com/.../sql-view-with-ar-apply-detail

Was this reply helpful? Yes No
Rosemary Roopnarine 455 on at

Like (0)

Report

Thanks Ian and Victoria, the option to 'pay commission after invoice has been paid' was taken at the initial setup. Because we may have different rates as per product type or salesperson I just want to pull the data for the Finance people. I am looking at the files Frank mentioned.

How does the 'remove paid transactions' affect a report as this?

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

Rosemary,

'Remove paid transactions' simply moves fully applied transactions from open to history tables...so from RM20101 to RM30101. If you include both of these tables in your report, you should be safe.

If you take a look at the first SQL view link from my previous post you will see that it is a union of the records in RM20101 and RM30101.

Was this reply helpful? Yes No