Sage 100

In the past two months I've had two clients experience this so I want to run it up the flagpole and see if anyone else has seen it. Both clients using Premium (one is 2020 and the other is 2021) and they do a "normal" AP check run for a mix of printed check and ACH vendors using Invoice Payment Selection but when they post the batch one of the checks is for a completely different amount. Neither of the clients caught it before everything was posted but if you look at payment history inquiry, you can see invoice lines that add up to one amount and the check amount is for a wildly different amount.  I've tried to duplicate the issue but have been unsuccessful. For one client it has happened 2x but they have had successful check runs in between the errors and it didn't happen for the same vendors. With three separate examples of this happening all in Premium I'm concerned it is a pattern. Has anyone else seen something like this? Thank you!

------------------------------
Kate Krueger
Business Applications Manager
Eide Bailly, Inc.
Denver CO
970-692-5113
------------------------------

I have someone in 2020 Premium where one ACH came through with the wrong amount. I think it was something like the ACH total was doubled. We couldn’t figure out what happened and the person who did the transaction was a temp so the customer didn’t think much more about it. We took a Sage case on it and Sage didn’t really have much to say other than user error.

---------------------------------
Wayne Schulz
Schulz Consulting
860-516-8990
---------------------------------

I opened a case ( # 8008733676 ) with Sage and spoke to their support tech on this issue.



Sage doesn’t have any other reports of this and suggest that the only “odd” thing they could see is the Invoice Payment Selection listing shows a $10,000 invoice with only $5,000 being selected for payment although the payment history seems to show a $10,000 check.



---------------------------------
Wayne Schulz
Schulz Consulting
860-516-8990
---------------------------------



Original Message:
Sent: 10-15-2021
From: Wayne Schulz
Subject: RE: AP Check Issued for Wrong Amount

I have someone in 2020 Premium where one ACH came through with the wrong amount. I think it was something like the ACH total was doubled. We couldn’t figure out what happened and the person who did the transaction was a temp so the customer didn’t think much more about it. We took a Sage case on it and Sage didn’t really have much to say other than user error.

---------------------------------
Wayne Schulz
Schulz Consulting
860-516-8990
---------------------------------

Thanks for providing this information @Wayne Schulz. This feels like one of those issues that will slowly gain momentum and eventually be duplicate-able and then fixed. Strange that they all are premium installations. I will add my two examples and reference your support case!​

------------------------------
Kate Krueger
Business Applications Manager
Eide Bailly, Inc.
Denver CO
970-692-5113
------------------------------

Original Message:
Sent: 10-15-2021 07:47
From: Wayne Schulz
Subject: AP Check Issued for Wrong Amount

I opened a case ( # 8008733676 ) with Sage and spoke to their support tech on this issue.



Sage doesn't have any other reports of this and suggest that the only "odd" thing they could see is the Invoice Payment Selection listing shows a $10,000 invoice with only $5,000 being selected for payment although the payment history seems to show a $10,000 check.



---------------------------------
Wayne Schulz
Schulz Consulting
860-516-8990
---------------------------------




Original Message:
Sent: 10-15-2021
From: Wayne Schulz
Subject: RE: AP Check Issued for Wrong Amount

I have someone in 2020 Premium where one ACH came through with the wrong amount. I think it was something like the ACH total was doubled. We couldn't figure out what happened and the person who did the transaction was a temp so the customer didn't think much more about it. We took a Sage case on it and Sage didn't really have much to say other than user error.

---------------------------------
Wayne Schulz
Schulz Consulting
860-516-8990
---------------------------------

(73,281.84 x 3) + (2,741.85 x 2) = 225,329.22
The first invoice was tripled and the second invoice was doubled.  Did something happen during the ACH update that required a restart?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Thanks for finding the pattern @Doug Higgs! That had eluded me. I will definitely ask about any restart. ​

------------------------------
Kate Krueger
Business Applications Manager
Eide Bailly, Inc.
Denver CO
970-692-5113
------------------------------

Original Message:
Sent: 10-15-2021 08:08
From: Doug Higgs
Subject: AP Check Issued for Wrong Amount

(73,281.84 x 3) + (2,741.85 x 2) = 225,329.22
The first invoice was tripled and the second invoice was doubled.  Did something happen during the ACH update that required a restart?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

@Kate Krueger  If this happens again, you might try re-initializing the AP_CheckStubWrk file.  I have seen something similar when printing checks.  The check amount is an exact multiple of the invoice.  It was fixed by re-initializing the work file that is used when printing. ​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Original Message:
Sent: 10-18-2021 12:28
From: Kate Krueger
Subject: AP Check Issued for Wrong Amount

Thanks for finding the pattern @Doug Higgs! That had eluded me. I will definitely ask about any restart. ​

------------------------------
Kate Krueger
Business Applications Manager
Eide Bailly, Inc.
Denver CO
970-692-5113
------------------------------


Original Message:
Sent: 10-15-2021 08:08
From: Doug Higgs
Subject: AP Check Issued for Wrong Amount

(73,281.84 x 3) + (2,741.85 x 2) = 225,329.22
The first invoice was tripled and the second invoice was doubled.  Did something happen during the ACH update that required a restart?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

The client has had four more check runs where this issue didn't show up so now we are in the "wait and see" mode. I appreciate everyone's help and will follow up if we see this again!

------------------------------
Kate Krueger
Business Applications Manager
Eide Bailly, Inc.
Denver CO
970-692-5113
------------------------------

Original Message:
Sent: 10-18-2021 12:45
From: Doug Higgs
Subject: AP Check Issued for Wrong Amount

@Kate Krueger  If this happens again, you might try re-initializing the AP_CheckStubWrk file.  I have seen something similar when printing checks.  The check amount is an exact multiple of the invoice.  It was fixed by re-initializing the work file that is used when printing. ​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------


Original Message:
Sent: 10-18-2021 12:28
From: Kate Krueger
Subject: AP Check Issued for Wrong Amount

Thanks for finding the pattern @Doug Higgs! That had eluded me. I will definitely ask about any restart. ​

------------------------------
Kate Krueger
Business Applications Manager
Eide Bailly, Inc.
Denver CO
970-692-5113


Original Message:
Sent: 10-15-2021 08:08
From: Doug Higgs
Subject: AP Check Issued for Wrong Amount

(73,281.84 x 3) + (2,741.85 x 2) = 225,329.22
The first invoice was tripled and the second invoice was doubled.  Did something happen during the ACH update that required a restart?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles

I had a client on Sage 100 Advanced have this happen for the second time yesterday.  Can't discover any pattern.  In this case the check stub had 5 invoices being paid.  4 invoices had a discount amount.  The one invoice without a discount amount was doubled on the check but not on the stub.  Running 2021 PU2.

------------------------------
Steve Engmann, MBA, CMA
DSD Business Systems
Appleton, WI
o: 800-627-9032 x-126
m: 920-428-2806
------------------------------

It's interesting to read that others have experienced this issue.

Interesting because Sage - and just about any other ISV - have the attitude that "it couldn't be our code/problem" and that the consultant or customer should just put up with it and go away unless they are willing to put in 20 hours of their own unpaid time ( often many more hours ) to research how to duplicate the bug.

I've had this type of experience more than once. With Sage, it's generally a "log in, search the KB, try the obvious, advise call back if it recurs, let me give you a case number". With ISVs, it's a cursory look if anyone has reported a similar issue then "deny, deny, deny" unless the consultant/customer goes and researches for 20+ hours and comes back with findings.

In my experience with ISVs there isn't too much difference between endorsed and non-endorsed in terms of how much effort they expend. In some cases the endorsed don't even know what Sage 100 is.

------------------------------
Wayne Schulz
Schulz Consulting
860-516-8990
------------------------------

For those experiencing the check issue.  Is the DTR getting updated OOB too?
I've now had this happen 2x in a week after a 2018 to 2021.2 upgrade.  Both happened in the same company (1 company out of 25 companies in a single installation).  Today way 5 invoices, all with discounts.  Found 1 invoice had discount show correctly but actually subtracted it 7 times and what should have been paid is actually the OOB on the DTR and the difference in what the check should have been written for and was written for.  I'll reinitialize the AP Check Stub Wrk File as suggest above.  
Another factor in this situation is that user selected 2 invoices for the vendor, then deleted 1 invoice and added 4 others.  On the Invoice Payment Selection, the troublesome invoice shows correctly and discount & net are correct.  It appears to have then changed in check maintenance
I'm thinking it's more in the check maintenance section of check processing rather than the stub as when I reversed the check, the 'amount paid' for each invoice came in it was on the check.  
I reversed the check, putting the OOB to a GL Account which I'll offset with a 1 sided GJ for the DTR
I then did invoice payment selection again for just this vendor, all came in correctly and I even removed a few invoices (but didn't add any).
Any ideas of how to resolve going forward?

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Original Message:
Sent: 10-19-2021 08:51
From: Wayne Schulz
Subject: AP Check Issued for Wrong Amount

It's interesting to read that others have experienced this issue.

Interesting because Sage - and just about any other ISV - have the attitude that "it couldn't be our code/problem" and that the consultant or customer should just put up with it and go away unless they are willing to put in 20 hours of their own unpaid time ( often many more hours ) to research how to duplicate the bug.

I've had this type of experience more than once. With Sage, it's generally a "log in, search the KB, try the obvious, advise call back if it recurs, let me give you a case number". With ISVs, it's a cursory look if anyone has reported a similar issue then "deny, deny, deny" unless the consultant/customer goes and researches for 20+ hours and comes back with findings.

In my experience with ISVs there isn't too much difference between endorsed and non-endorsed in terms of how much effort they expend. In some cases the endorsed don't even know what Sage 100 is.

------------------------------
Wayne Schulz
Schulz Consulting
860-516-8990
------------------------------

Add my name to the list - my Advanced client experienced it once about a month ago; hasn't reoccurred.

------------------------------
Susan Pawlowic
Sage 100 Solutions Architect
RKL eSolutions, LLC
spawlowic@rklesolutions.com
(717) 735-9109 Ext. 4352
------------------------------

Original Message:
Sent: 12-29-2021 14:21
From: Nancy Hanson
Subject: AP Check Issued for Wrong Amount

For those experiencing the check issue.  Is the DTR getting updated OOB too?
I've now had this happen 2x in a week after a 2018 to 2021.2 upgrade.  Both happened in the same company (1 company out of 25 companies in a single installation).  Today way 5 invoices, all with discounts.  Found 1 invoice had discount show correctly but actually subtracted it 7 times and what should have been paid is actually the OOB on the DTR and the difference in what the check should have been written for and was written for.  I'll reinitialize the AP Check Stub Wrk File as suggest above.
Another factor in this situation is that user selected 2 invoices for the vendor, then deleted 1 invoice and added 4 others.  On the Invoice Payment Selection, the troublesome invoice shows correctly and discount & net are correct.  It appears to have then changed in check maintenance
I'm thinking it's more in the check maintenance section of check processing rather than the stub as when I reversed the check, the 'amount paid' for each invoice came in it was on the check.
I reversed the check, putting the OOB to a GL Account which I'll offset with a 1 sided GJ for the DTR
I then did invoice payment selection again for just this vendor, all came in correctly and I even removed a few invoices (but didn't add any).
Any ideas of how to resolve going forward?

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------


Original Message:
Sent: 10-19-2021 08:51
From: Wayne Schulz
Subject: AP Check Issued for Wrong Amount

It's interesting to read that others have experienced this issue.

Interesting because Sage - and just about any other ISV - have the attitude that "it couldn't be our code/problem" and that the consultant or customer should just put up with it and go away unless they are willing to put in 20 hours of their own unpaid time ( often many more hours ) to research how to duplicate the bug.

I've had this type of experience more than once. With Sage, it's generally a "log in, search the KB, try the obvious, advise call back if it recurs, let me give you a case number". With ISVs, it's a cursory look if anyone has reported a similar issue then "deny, deny, deny" unless the consultant/customer goes and researches for 20+ hours and comes back with findings.

In my experience with ISVs there isn't too much difference between endorsed and non-endorsed in terms of how much effort they expend. In some cases the endorsed don't even know what Sage 100 is.

------------------------------
Wayne Schulz
Schulz Consulting
860-516-8990