Sage 100

Just went live on the new payroll 2.xx.  Why are there asterisks in the first column of the direct deposit file?  Can this be changed?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Found the answer on the KB.  Well this certainly is a hassle.  Reverse the payroll and re-enter it is the solution.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

I don't have good news for you.  If the role for the person/persons processing the payroll under security events/payroll doesn't have the option for view, print, edit PII data checked then all PII data in the direct deposit file will only have ***.  The payroll will have to be redone either by reversing the checks or restoring from back up prior to check processing being done.

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

What about modifying the DD file?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 05-09-2019 15:26
From: Shari Eckersley
Subject: Asterisks in the Direct Deposit File

I don't have good news for you.  If the role for the person/persons processing the payroll under security events/payroll doesn't have the option for view, print, edit PII data checked then all PII data in the direct deposit file will only have ***.  The payroll will have to be redone either by reversing the checks or restoring from back up prior to check processing being done.

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

We ran in to this with a client and they were able to log in to the bank web site, copy the submission from the previous payroll to a new "batch", modify the amounts and submit it for processing.  Saved a lot of hassle in Sage.

------------------------------
Bernie Lehman
Lehman Wesley & Associates
------------------------------

Original Message:
Sent: 05-09-2019 15:27
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

What about modifying the DD file?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------


Original Message:
Sent: 05-09-2019 15:26
From: Shari Eckersley
Subject: Asterisks in the Direct Deposit File

I don't have good news for you.  If the role for the person/persons processing the payroll under security events/payroll doesn't have the option for view, print, edit PII data checked then all PII data in the direct deposit file will only have ***.  The payroll will have to be redone either by reversing the checks or restoring from back up prior to check processing being done.

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

Thanks @Bernie Lehman  They ended up modifying the direct deposit file by copying and pasting from the DD file from last weeks payroll.  I gave them the option of reversing the payroll and re-entering it or "being vary careful" and modifying the file.  They elected to modify the file.  I emphasized if they were going to edit the file then "to treat it like you are planning the moon landing – very precise!". 

​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 05-10-2019 08:37
From: Bernie Lehman
Subject: Asterisks in the Direct Deposit File

We ran in to this with a client and they were able to log in to the bank web site, copy the submission from the previous payroll to a new "batch", modify the amounts and submit it for processing.  Saved a lot of hassle in Sage.

------------------------------
Bernie Lehman
Lehman Wesley & Associates
------------------------------


Original Message:
Sent: 05-09-2019 15:27
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

What about modifying the DD file?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 05-09-2019 15:26
From: Shari Eckersley
Subject: Asterisks in the Direct Deposit File

I don't have good news for you.  If the role for the person/persons processing the payroll under security events/payroll doesn't have the option for view, print, edit PII data checked then all PII data in the direct deposit file will only have ***.  The payroll will have to be redone either by reversing the checks or restoring from back up prior to check processing being done.

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

All the updates look OK.  Checks printed fine.  The only issue looks to be the format of the direct deposit file.  If we copied and pasted the info from a copy from last weeks payroll run by a person with the "good security" I would think they should be OK.  Thoughts?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 05-09-2019 15:26
From: Shari Eckersley
Subject: Asterisks in the Direct Deposit File

I don't have good news for you.  If the role for the person/persons processing the payroll under security events/payroll doesn't have the option for view, print, edit PII data checked then all PII data in the direct deposit file will only have ***.  The payroll will have to be redone either by reversing the checks or restoring from back up prior to check processing being done.

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

It should work as long as everything is correct in making sure the correct bank accounts are associated with the correct employees. The exact employees were paid in both check runs and no employee has had any bank changes.  The data will need to be double checked since there's no room for error.  It's more risk than I'd want to take on.

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

Thank you @Shari Eckersley  !!​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 05-09-2019 15:49
From: Shari Eckersley
Subject: Asterisks in the Direct Deposit File

It should work as long as everything is correct in making sure the correct bank accounts are associated with the correct employees. The exact employees were paid in both check runs and no employee has had any bank changes.  The data will need to be double checked since there's no room for error.  It's more risk than I'd want to take on.

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

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll" 



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

Post that idea on Sage City, and they might pick up on it... Elliot sometimes takes bug fix suggestions from there, jumping the development queue.

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

Original Message:
Sent: 05-10-2019 09:57
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll"



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

@Wayne Schulz  You would think so.   Accidentally creating the DD file with asterisks is a huge inconvenience, particularly when there are a lot of DD employees.  Also, payroll usually needs to go to the bank today so users are on a tight schedule.  Any missteps create a lot of anxiety.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 05-10-2019 09:57
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll"



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

Ideally, a user with permissions to the PII would be able to re-create the direct deposit file without asterisks.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 05-10-2019 09:57
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll"



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

Created suggestion on the idea site - https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/39866

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

Original Message:
Sent: 05-10-2019 10:16
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

Ideally, a user with permissions to the PII would be able to re-create the direct deposit file without asterisks.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------


Original Message:
Sent: 05-10-2019 09:57
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll"



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

Up to seven now.  Hopefully, it will get traction.  If only they could feel the pain!

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

Original Message:
Sent: 05-10-2019 10:24
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Created suggestion on the idea site - https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/39866

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


Original Message:
Sent: 05-10-2019 10:16
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

Ideally, a user with permissions to the PII would be able to re-create the direct deposit file without asterisks.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 05-10-2019 09:57
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll"



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

Spoke to Linda Cade and Elliott on this. At first they thought it was fixed but then said it’s not but is scheduled for next payroll update - June?

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



Original Message:
Sent: 05-10-2019
From: Jeff Schwenk
Subject: RE: Asterisks in the Direct Deposit File

Up to seven now.  Hopefully, it will get traction.  If only they could feel the pain!

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


Original Message:
Sent: 05-10-2019 10:24
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Created suggestion on the idea site - https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/39866

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


Original Message:
Sent: 05-10-2019 10:16
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

Ideally, a user with permissions to the PII would be able to re-create the direct deposit file without asterisks.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc

Someone here shared this tool for modifying ACH files - and recalculating the check digit if needed.   I like it for making it clear what position number a character is in. I apologize for forgetting who recommended it!

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Original Message:
Sent: 05-15-2019 06:32
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Spoke to Linda Cade and Elliott on this. At first they thought it was fixed but then said it's not but is scheduled for next payroll update - June?

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




Original Message:
Sent: 05-10-2019
From: Jeff Schwenk
Subject: RE: Asterisks in the Direct Deposit File

Up to seven now.  Hopefully, it will get traction.  If only they could feel the pain!

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


Original Message:
Sent: 05-10-2019 10:24
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Created suggestion on the idea site - https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/39866

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


Original Message:
Sent: 05-10-2019 10:16
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

Ideally, a user with permissions to the PII would be able to re-create the direct deposit file without asterisks.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 05-10-2019 09:57
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll"



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

Thanks @Rhonda McNamara​​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 05-15-2019 08:05
From: Rhonda McNamara
Subject: Asterisks in the Direct Deposit File

Someone here shared this tool for modifying ACH files - and recalculating the check digit if needed.   I like it for making it clear what position number a character is in. I apologize for forgetting who recommended it!

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------


Original Message:
Sent: 05-15-2019 06:32
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Spoke to Linda Cade and Elliott on this. At first they thought it was fixed but then said it's not but is scheduled for next payroll update - June?

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


Original Message:
Sent: 05-10-2019
From: Jeff Schwenk
Subject: RE: Asterisks in the Direct Deposit File

Up to seven now.  Hopefully, it will get traction.  If only they could feel the pain!

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


Original Message:
Sent: 05-10-2019 10:24
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Created suggestion on the idea site - https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/39866

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


Original Message:
Sent: 05-10-2019 10:16
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

Ideally, a user with permissions to the PII would be able to re-create the direct deposit file without asterisks.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 05-10-2019 09:57
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll"



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

Have a client in test mode now.  She has 3 roles.  One of those roles has the Module option enabled.  She produced a file with the asterisks.  Is there another setting involved?  Or do all the roles need to have the setting enabled.  That would be a departure from standard role security where the most permissive settings rule.

Update:  never mind.  My distracted brain didn't realize the problem was with a Positive pay export, not PR.

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

Original Message:
Sent: 05-15-2019 08:13
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

Thanks @Rhonda McNamara​​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------


Original Message:
Sent: 05-15-2019 08:05
From: Rhonda McNamara
Subject: Asterisks in the Direct Deposit File

Someone here shared this tool for modifying ACH files - and recalculating the check digit if needed.   I like it for making it clear what position number a character is in. I apologize for forgetting who recommended it!

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com


Original Message:
Sent: 05-15-2019 06:32
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Spoke to Linda Cade and Elliott on this. At first they thought it was fixed but then said it's not but is scheduled for next payroll update - June?

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


Original Message:
Sent: 05-10-2019
From: Jeff Schwenk
Subject: RE: Asterisks in the Direct Deposit File

Up to seven now.  Hopefully, it will get traction.  If only they could feel the pain!

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


Original Message:
Sent: 05-10-2019 10:24
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Created suggestion on the idea site - https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/39866

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


Original Message:
Sent: 05-10-2019 10:16
From: Doug Higgs
Subject: Asterisks in the Direct Deposit File

Ideally, a user with permissions to the PII would be able to re-create the direct deposit file without asterisks.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 05-10-2019 09:57
From: Wayne Schulz
Subject: Asterisks in the Direct Deposit File

Shouldn't Sage Payroll present a warning "You do not have appropriate rights to generate a full and complete direct deposit file. Certain information will be masked and unsuitable for submission. Please consult your system administrator BEFORE updating payroll"



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