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

Conrad Cattle President

Conrad Cattle

Joined: 6/20/2019

  • EFY Export - File Creation Number in detail and footer

    Fri, 31 May 2019 18:55:57 GMT – Dynamics 365 Business Central – Needs Votes 

    Why can’t I put the file creation number in the detail and footer? The header allows me to properly map it. But the detail and footer do not. But Standard CPA 1464 requires this.

  • EFY Export - File Creation Number in detail and footer

    Fri, 31 May 2019 18:56:36 GMT – Dynamics 365 Business Central – Completed 

    Why can’t I put the file creation number in the detail and footer? The header allows me to properly map it. But the detail and footer do not. But Standard CPA 1464 requires this.

  • EFT Export File name should be the file creation number

    Fri, 31 May 2019 19:00:06 GMT – Dynamics 365 Business Central – Needs Votes 

    In "Bank Account" we type in what we want the CPA Export File Name to be. However, this shouldn't be a static name. This should be the same as the "CPA File Creation No." Banks use this file name to ensure that the same file isn't uploaded twice. You can not have the same file name uploaded twice. There needs to be a way to set the CPA Export File Name to be the same as the CPA File Creation No. This may seem small but is a really important security and information management tool that keeps payments happening without screw ups.

  • Tax: 3 decimal places

    Fri, 31 May 2019 21:18:33 GMT – Dynamics 365 Business Central – Under Review 

    The tax table for Tax Jurisdictions are restricted to 3 decimal places. But QST in Quebec is 3 decimal places.

  • EFT Export - File Creation Number in Detail and Footer Field Lookup Table

    Mon, 03 Jun 2019 17:31:13 GMT – Dynamics 365 Business Central – Completed 

    In Data Exchange Definitions, for creating EFT file exports: The Detail Field Lookup Table (10304) and the Footer Field Lookup Table (10305) should include the File Creation Number (item 7 in table 10303). This is a requirement for the standard EFT file upload standard CPA 005 1464. CPA 005 1464 format files are accepted at the following banks: HSBC Toronto Dominion (TD) Scotiabank Royal Bank of Canada (RBC) Bank of Montreal (BMO) This is the standard EFT Export format of Sage Canada. Requirements for CPA 1464 are located here: for ATB (pages 45-47): https://www.atb.com/learn/resources/Documents/EFT_User_Guide.pdf for BMO (pages 61-66): http://www.bmocm.com/products/treasury/cda/ccbc/implementation/userguides/images/EFT.pdf for RBC (pages 5-8): https://www.rbcroyalbank.com/ach/file-451771.pdf for HSBC: they send a PDF to their customers and I can send this to you, unfortunately this site doesn't allow attachments I have already created a similar request but it didn't have enough detail. It is located here: https://experience.dynamics.com/ideas/idea/?ideaid=e0c833d0-d583-e911-80e7-0003ff689ebe