web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

HSBC Format and Canadian Payroll

(0) ShareShare
ReportReport
Posted on by 12

We have a problem with Canadian Payroll and HSBC Direct Deposit

For the past number of years we have submitted payroll under a single Originator ID for multiple companies that used the same Bank Account.

Now the two have split the bank account and in the first company, which uses the default account - created with HSBC - we have no issues.

In the second company, that now uses a new bank account number, same originator ID, the Direct Deposit still fails back to the Default bank account.

We are told by the bank that we need to enter a "D" line - before the "Z" (summary line) that indicates that we are trying to use a different OFFSET Bank account number.

We can not find the entry point for this Offset in the system.

We have entered all the new bank information in the company - we have entered the Direct Deposit bank account in the Checkbook Maintenance, we have enter the bank account number as the Return Account.

When we generate the payroll we get what we expect - the account seems to be there, but there is NO D LINE generated.

Where is the D LINE created - how is it controlled.

We have 100 employees that are not getting paid with a solution - the bank will not support this, as we are not using their software, go figure.

Bill Campbell

Director, Operations

MIS Management Information Solutions

billc.edmonton via Skype

*This post is locked for comments

I have the same question (0)
  • Bill Campbell Profile Picture
    12 on at

    Anyone out there that deals with Canadian Payroll know anything about multiple accounts being selected for a direct deposit process?

    We are getting a lot of blow back from the client as this is a show stopper if we can not figure this out.  WE know how to manually create the "D" line - but really how can this not be in part of the system.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    I am not sure if this is what you need but check out this KB.  2026313. This helped us set up an unusual settlement line.

  • Bill Campbell Profile Picture
    12 on at

    Richard, thanks for the assistance on this matter, however, the EFT process and the Canadian Payroll system do not share the same data.  So, while the EFT system might get fixed that way, however, we are still stuck on the Canadain Payroll system.

    Thanks for the try.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Bill,

    Did you ever managed to resolve you problem ? I recently had to configure the HSBC file format for the SafePay module in GP for our US branch... We do use direct deposit as well for the Canadian Payroll, but quite frankly don't know where you setup the direct deposit.. ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans