Sage 100

Sage 100 2018.2 Premium - When running the salesperson commission report and using a pay date the report appears to be doubling any credit memos. I can't tell if there are other variables at play as I just did a simple test to verify what the customer sent to me. I can verify this on their system using STANDARD report setting. Anyone seen or resolved this?

Couple questions - are they paying commission on paid invoices only and are the credit memos applied to an invoice or not associated yet?

Yes to both. It doesn't look like Pay Date was a selection option in their 2014 version so I can't test to see if the issue existed before the upgrade. Probably just rebuild sorts. If that doesn't work I'll hand it off to Sage.

Pretty sure this will be a defect in using the Pay Date as a selection criteria. When I don't have those criteria then the report is fine. When I add a date then the report doubles the credit memos.

On the line with Sage. They are working hard to pitch this as a WAD.... (yeah)

Wayne it does appear to be a Premium specific defect. Looks like since v2017 there is an additional WRITE to the SQL worktable in the Populate Work Table routine. That is fine on non-sql but on SQL the worktable (in TempDB) is always created with no primary key. This means every time you WRITE in the pvx code, it will INSERT a new record instead of UPDATEing the existing record ergo you get duplicate records. There is another reason in Premium dupes can happen on reports that relates to settings in the SY_SQLOptimize.m4t file but that doesn't appear to be related to this issue.

Any workaround or should they just live with it? Also they only see it on the CM not IN items which is odd.

As an added bonus, Sage tech clicked on ""Convert Data"" for an old copy of Sage data (customer had JUST undergone an extensive premium UG and I had not yet re-created test companies). After converting for an hour it stops/errors and now looks like it put down the entire system. I'm showing no modules and getting the prompt to create data for live company code. Anyone wonder why calling Sage is my last resort usually only done at the insistence of the customer.

The no module issue seemed to self-correct when I copied Live => TST. Must have re-updated the system files somehow.