We are having some trouble with our Salesperson Commission Reports. I have done some testing and believe that it may have something to do with creating an invoice and a corresponding credit note without having processed the invoice through Day-End procedures.

When an invoice is created, and a credit note created for that invoice, without having run day end, a warning comes up, which advises "this invoice has not been processed by Dayend. The credit note will use most recent or standard cost for inventory items."

The problem comes into play when the Salesperson Commission Report is then run, after Day End. Sometimes the credit note shows as the correct amount on the report, but sometimes it shows as a zero, in effect making the report incorrect. IE the invoice shows on the report, but the corresponding credit note is showing as zero, making the total sales wrong. Both our standard cost, and our recent cost have amounts shown in inventory, so it is obviously not using those costs.

If I knew where the Sales Person Commission Report is actually drawing the amount of zero from, I could amend that, or look into this further, but right now, am not sure where the cost is coming from. Thank you for any help provided.

I am sorry that this reply does not answer your question, because I prefer not to be the first response when it is not directly on point, since others may then skip the thread, but here goes...

I hate the canned Salesperson Commission Report. It is too limiting, and once you run and clear it you can't reprint it. For all of my clients who do commission tracking, I have created a report in Crystal Reports or Quik Reports using Sales Analysis data (or Order Entry data but it is not my first choice). The report is actually presentable to salespeople, unlike the canned report.

Steve