Sage 100

The direct deposit section of the direct deposit section that prints bank name/bank account number/current direct deposit amt./YTD direct deposit amt. for the one or more employee bank accounts is not printing any data except zeros in the amount fields after installing the new release.

The total direct deposit amount still prints at the bottom of the direct deposit stub.

The role being used has all fields including Security/General Ledger/PII marked.

I've reported it to Sage.

------------------------------
Shari Eckersley
ICS Support
------------------------------

I think I read that the new version is now encrypting bank account information in the same way it encrypts SSN's and other information.  How you fix it,  I don't know.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------

Just had the same issue reported by a client this morning with 2018.7 and 2.19.3 installed last night.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------

In Role Maintenance, under Payroll/Security Events tab, do they have access to "allow viewing, printing and editing of highly sensitive personally identifiable information"?  Is ODBC security turned on?  If so, I think they need access to all of payroll AND bank rec there.

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------

Original Message:
Sent: 07-01-2019 18:12
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Just had the same issue reported by a client this morning with 2018.7 and 2.19.3 installed last night.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------

My original post indicates that this occurs when all options for all tabs including ODBC in role maintenance are marked.  I reported it on Thursday and called back on Friday for a status and it seems like nothing had been done and I've heard nothing today.

------------------------------
Shari Eckersley
ICS Support
------------------------------

Worked with my client today and I figured out where the problem is an managed to correct it.

The data for printing the direct deposit information in the past had a line type of 4.  After the update, the data in the work file is now showing as a 5!

The crystal report pulls the information to print using formulas with a switch/case statement which is set to get the information for a line type of 4.  There is no case for 5.

I adjusted the formulas to add a case 5 with the same information as case 4 and problem solved.

I don't know if this was a programmers oops or whether they intended to change it.  If the did intend to change it, they forgot about the impact on the crystal report.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------

Original Message:
Sent: 07-01-2019 18:52
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

My original post indicates that this occurs when all options for all tabs including ODBC in role maintenance are marked.  I reported it on Thursday and called back on Friday for a status and it seems like nothing had been done and I've heard nothing today.

------------------------------
Shari Eckersley
ICS Support
------------------------------

Creating a NEW form AFTER installation of 2.19.3 already has the case "5" in it.  I printed a test and do see Bank Name and Amount and YTD Amount.  Does the formula look correct?

This is the @LineDetailDesc formula
select case {PR_CheckPrintingWrk.LineType}
case "1" ' Earnings code description
formula = {PR_CheckPrintingWrk.EarningsDesc}
case "2" ' Tax description
formula = {PR_CheckPrintingWrk.LineTaxDesc}
case "3" ' Deduction code description
formula = {PR_CheckPrintingWrk.DeductionDesc}
case "4" ' Employer Contribution description
formula = {PR_CheckPrintingWrk.EmployerContributionDesc}
case "5" ' Direct Deposit Bank description
formula = {PR_CheckPrintingWrk.DirectDepositBankDesc}
end select​

------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
KS
------------------------------

Original Message:
Sent: 07-03-2019 17:52
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Worked with my client today and I figured out where the problem is an managed to correct it.

The data for printing the direct deposit information in the past had a line type of 4.  After the update, the data in the work file is now showing as a 5!

The crystal report pulls the information to print using formulas with a switch/case statement which is set to get the information for a line type of 4.  There is no case for 5.

I adjusted the formulas to add a case 5 with the same information as case 4 and problem solved.

I don't know if this was a programmers oops or whether they intended to change it.  If the did intend to change it, they forgot about the impact on the crystal report.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------


Original Message:
Sent: 07-01-2019 18:52
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

My original post indicates that this occurs when all options for all tabs including ODBC in role maintenance are marked.  I reported it on Thursday and called back on Friday for a status and it seems like nothing had been done and I've heard nothing today.

------------------------------
Shari Eckersley
ICS Support

All three formulas in the Direct Deposit section have changed.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

Original Message:
Sent: 07-10-2019 12:20
From: Mary Mays
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Creating a NEW form AFTER installation of 2.19.3 already has the case "5" in it.  I printed a test and do see Bank Name and Amount and YTD Amount.  Does the formula look correct?

This is the @LineDetailDesc formula
select case {PR_CheckPrintingWrk.LineType}
case "1" ' Earnings code description
formula = {PR_CheckPrintingWrk.EarningsDesc}
case "2" ' Tax description
formula = {PR_CheckPrintingWrk.LineTaxDesc}
case "3" ' Deduction code description
formula = {PR_CheckPrintingWrk.DeductionDesc}
case "4" ' Employer Contribution description
formula = {PR_CheckPrintingWrk.EmployerContributionDesc}
case "5" ' Direct Deposit Bank description
formula = {PR_CheckPrintingWrk.DirectDepositBankDesc}
end select​

------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
KS
------------------------------


Original Message:
Sent: 07-03-2019 17:52
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Worked with my client today and I figured out where the problem is an managed to correct it.

The data for printing the direct deposit information in the past had a line type of 4.  After the update, the data in the work file is now showing as a 5!

The crystal report pulls the information to print using formulas with a switch/case statement which is set to get the information for a line type of 4.  There is no case for 5.

I adjusted the formulas to add a case 5 with the same information as case 4 and problem solved.

I don't know if this was a programmers oops or whether they intended to change it.  If the did intend to change it, they forgot about the impact on the crystal report.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA


Original Message:
Sent: 07-01-2019 18:52
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

My original post indicates that this occurs when all options for all tabs including ODBC in role maintenance are marked.  I reported it on Thursday and called back on Friday for a status and it seems like nothing had been done and I've heard nothing today.

------------------------------
Shari Eckersley
ICS Support

It was added to accommodate the Employer Contribution fields that have been added to 2.19.3 check & dd stub work file. I will be creating entire new DD stub after I take anyone to 2.19.3 in case they want to take advantage of that.

------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
KS
------------------------------

Original Message:
Sent: 07-10-2019 13:48
From: Barbara Goldstein
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

All three formulas in the Direct Deposit section have changed.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------


Original Message:
Sent: 07-10-2019 12:20
From: Mary Mays
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Creating a NEW form AFTER installation of 2.19.3 already has the case "5" in it.  I printed a test and do see Bank Name and Amount and YTD Amount.  Does the formula look correct?

This is the @LineDetailDesc formula
select case {PR_CheckPrintingWrk.LineType}
case "1" ' Earnings code description
formula = {PR_CheckPrintingWrk.EarningsDesc}
case "2" ' Tax description
formula = {PR_CheckPrintingWrk.LineTaxDesc}
case "3" ' Deduction code description
formula = {PR_CheckPrintingWrk.DeductionDesc}
case "4" ' Employer Contribution description
formula = {PR_CheckPrintingWrk.EmployerContributionDesc}
case "5" ' Direct Deposit Bank description
formula = {PR_CheckPrintingWrk.DirectDepositBankDesc}
end select​

------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
KS


Original Message:
Sent: 07-03-2019 17:52
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Worked with my client today and I figured out where the problem is an managed to correct it.

The data for printing the direct deposit information in the past had a line type of 4.  After the update, the data in the work file is now showing as a 5!

The crystal report pulls the information to print using formulas with a switch/case statement which is set to get the information for a line type of 4.  There is no case for 5.

I adjusted the formulas to add a case 5 with the same information as case 4 and problem solved.

I don't know if this was a programmers oops or whether they intended to change it.  If the did intend to change it, they forgot about the impact on the crystal report.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA


Original Message:
Sent: 07-01-2019 18:52
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

My original post indicates that this occurs when all options for all tabs including ODBC in role maintenance are marked.  I reported it on Thursday and called back on Friday for a status and it seems like nothing had been done and I've heard nothing today.

------------------------------
Shari Eckersley
ICS Support

That was certainly poor planning.  You would think they would have made the employer contribution be case 5 so as not to disturb existing formats.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------

Original Message:
Sent: 07-10-2019 13:48
From: Barbara Goldstein
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

All three formulas in the Direct Deposit section have changed.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------


Original Message:
Sent: 07-10-2019 12:20
From: Mary Mays
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Creating a NEW form AFTER installation of 2.19.3 already has the case "5" in it.  I printed a test and do see Bank Name and Amount and YTD Amount.  Does the formula look correct?

This is the @LineDetailDesc formula
select case {PR_CheckPrintingWrk.LineType}
case "1" ' Earnings code description
formula = {PR_CheckPrintingWrk.EarningsDesc}
case "2" ' Tax description
formula = {PR_CheckPrintingWrk.LineTaxDesc}
case "3" ' Deduction code description
formula = {PR_CheckPrintingWrk.DeductionDesc}
case "4" ' Employer Contribution description
formula = {PR_CheckPrintingWrk.EmployerContributionDesc}
case "5" ' Direct Deposit Bank description
formula = {PR_CheckPrintingWrk.DirectDepositBankDesc}
end select​

------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
KS


Original Message:
Sent: 07-03-2019 17:52
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Worked with my client today and I figured out where the problem is an managed to correct it.

The data for printing the direct deposit information in the past had a line type of 4.  After the update, the data in the work file is now showing as a 5!

The crystal report pulls the information to print using formulas with a switch/case statement which is set to get the information for a line type of 4.  There is no case for 5.

I adjusted the formulas to add a case 5 with the same information as case 4 and problem solved.

I don't know if this was a programmers oops or whether they intended to change it.  If the did intend to change it, they forgot about the impact on the crystal report.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA


Original Message:
Sent: 07-01-2019 18:52
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

My original post indicates that this occurs when all options for all tabs including ODBC in role maintenance are marked.  I reported it on Thursday and called back on Friday for a status and it seems like nothing had been done and I've heard nothing today.

------------------------------
Shari Eckersley
ICS Support

Seems to me there should be a report conversion warning... but how many years did it take Sage to fix mascrcw.exe to show errors with those discontinued check printing functions (StoreStringVar / FetchStringVar)?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 07-10-2019 17:35
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

That was certainly poor planning.  You would think they would have made the employer contribution be case 5 so as not to disturb existing formats.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------


Original Message:
Sent: 07-10-2019 13:48
From: Barbara Goldstein
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

All three formulas in the Direct Deposit section have changed.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221


Original Message:
Sent: 07-10-2019 12:20
From: Mary Mays
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Creating a NEW form AFTER installation of 2.19.3 already has the case "5" in it.  I printed a test and do see Bank Name and Amount and YTD Amount.  Does the formula look correct?

This is the @LineDetailDesc formula
select case {PR_CheckPrintingWrk.LineType}
case "1" ' Earnings code description
formula = {PR_CheckPrintingWrk.EarningsDesc}
case "2" ' Tax description
formula = {PR_CheckPrintingWrk.LineTaxDesc}
case "3" ' Deduction code description
formula = {PR_CheckPrintingWrk.DeductionDesc}
case "4" ' Employer Contribution description
formula = {PR_CheckPrintingWrk.EmployerContributionDesc}
case "5" ' Direct Deposit Bank description
formula = {PR_CheckPrintingWrk.DirectDepositBankDesc}
end select​

------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
KS


Original Message:
Sent: 07-03-2019 17:52
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Worked with my client today and I figured out where the problem is an managed to correct it.

The data for printing the direct deposit information in the past had a line type of 4.  After the update, the data in the work file is now showing as a 5!

The crystal report pulls the information to print using formulas with a switch/case statement which is set to get the information for a line type of 4.  There is no case for 5.

I adjusted the formulas to add a case 5 with the same information as case 4 and problem solved.

I don't know if this was a programmers oops or whether they intended to change it.  If the did intend to change it, they forgot about the impact on the crystal report.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA


Original Message:
Sent: 07-01-2019 18:52
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

My original post indicates that this occurs when all options for all tabs including ODBC in role maintenance are marked.  I reported it on Thursday and called back on Friday for a status and it seems like nothing had been done and I've heard nothing today.

------------------------------
Shari Eckersley
ICS Support

Just went hunting around through all the release notes for 2.19.3.  Absolutely no mention/warning that I can find about this.  :(

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------

Original Message:
Sent: 07-10-2019 17:46
From: Kevin Moyes
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Seems to me there should be a report conversion warning... but how many years did it take Sage to fix mascrcw.exe to show errors with those discontinued check printing functions (StoreStringVar / FetchStringVar)?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 07-10-2019 17:35
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

That was certainly poor planning.  You would think they would have made the employer contribution be case 5 so as not to disturb existing formats.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA


Original Message:
Sent: 07-10-2019 13:48
From: Barbara Goldstein
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

All three formulas in the Direct Deposit section have changed.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221


Original Message:
Sent: 07-10-2019 12:20
From: Mary Mays
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Creating a NEW form AFTER installation of 2.19.3 already has the case "5" in it.  I printed a test and do see Bank Name and Amount and YTD Amount.  Does the formula look correct?

This is the @LineDetailDesc formula
select case {PR_CheckPrintingWrk.LineType}
case "1" ' Earnings code description
formula = {PR_CheckPrintingWrk.EarningsDesc}
case "2" ' Tax description
formula = {PR_CheckPrintingWrk.LineTaxDesc}
case "3" ' Deduction code description
formula = {PR_CheckPrintingWrk.DeductionDesc}
case "4" ' Employer Contribution description
formula = {PR_CheckPrintingWrk.EmployerContributionDesc}
case "5" ' Direct Deposit Bank description
formula = {PR_CheckPrintingWrk.DirectDepositBankDesc}
end select​

------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
KS


Original Message:
Sent: 07-03-2019 17:52
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Worked with my client today and I figured out where the problem is an managed to correct it.

The data for printing the direct deposit information in the past had a line type of 4.  After the update, the data in the work file is now showing as a 5!

The crystal report pulls the information to print using formulas with a switch/case statement which is set to get the information for a line type of 4.  There is no case for 5.

I adjusted the formulas to add a case 5 with the same information as case 4 and problem solved.

I don't know if this was a programmers oops or whether they intended to change it.  If the did intend to change it, they forgot about the impact on the crystal report.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA


Original Message:
Sent: 07-01-2019 18:52
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

My original post indicates that this occurs when all options for all tabs including ODBC in role maintenance are marked.  I reported it on Thursday and called back on Friday for a status and it seems like nothing had been done and I've heard nothing today.

------------------------------
Shari Eckersley
ICS Support

Thanks for discovering the issue and finding a workaround.  I have added your information to my Sage support ticket since there has still been no response from Sage.

------------------------------
Shari Eckersley
ICS Support
------------------------------

I reported that info to tech support as well.  Got an e-mail a day later saying they could not duplicate it and asked for more info.  Batched them up a bunch of screen shots and haven't heard anything since.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------

Original Message:
Sent: 07-03-2019 20:26
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Thanks for discovering the issue and finding a workaround.  I have added your information to my Sage support ticket since there has still been no response from Sage.

------------------------------
Shari Eckersley
ICS Support
------------------------------

Do we have to modify existing checks forms as well with the 2019.3 modfications?

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 07-09-2019 17:18
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

I reported that info to tech support as well.  Got an e-mail a day later saying they could not duplicate it and asked for more info.  Batched them up a bunch of screen shots and haven't heard anything since.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA
------------------------------


Original Message:
Sent: 07-03-2019 20:26
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Thanks for discovering the issue and finding a workaround.  I have added your information to my Sage support ticket since there has still been no response from Sage.

------------------------------
Shari Eckersley
ICS Support

The check formulas are different.  Looks like the new form just adds the employerContributionDesc and EmployerContributionPayAmt fields directly to the Details b on the stub and not inside a formula.

------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
KS
------------------------------

Original Message:
Sent: 07-10-2019 15:03
From: Jeff Schwenk
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Do we have to modify existing checks forms as well with the 2019.3 modfications?

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 07-09-2019 17:18
From: Thomas Rogers
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

I reported that info to tech support as well.  Got an e-mail a day later saying they could not duplicate it and asked for more info.  Batched them up a bunch of screen shots and haven't heard anything since.

------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
Spokane Valley WA


Original Message:
Sent: 07-03-2019 20:26
From: Shari Eckersley
Subject: Direct deposit stub issue when 2018.7 or 2019.1 and payroll 2.19.3 installed

Thanks for discovering the issue and finding a workaround.  I have added your information to my Sage support ticket since there has still been no response from Sage.

------------------------------
Shari Eckersley
ICS Support