EFT Tables Used in Dynamics GP
Time and again built-in Dynamics GP reports and SmartLists aren’t enough for GP users, so business analysts, developers, or consultants are required to created custom SmartLists, SQL views, and SSRS reports.
A popular report request is a customized SSRS report for EFT transactions.
Below is a handy list of all the tables needed to build custom reports or SQL views for EFT in Dynamics GP:
| Physical Name | Display Name |
| CM00101 | Checkbook Electronic Funds Transfer Maintenance |
| CM00102 | Checkbook EFT Optional Header |
| CM00103 | Checkbook EFT Format Header |
| CM00104 | Checkbook EFT Format Detail |
| CM20202 | Checkbook Transaction Electronic Funds
EFTTYPE |
| CM20203 | Checkbook EFT Transaction Batch
EFT_STATUS |
| CM90001 | Checkbook EFT |
| SY06000 | Address Electronic Funds Transfer Master
(Customer/Vendor Banking Information) 3 = RM 4 = PM |
If you have any questions about reporting in Dynamics GP, please reach out to us.
Webinar - Dynamics GP Coffee Break | Using and Enabling Document Attach
Find out how to setup and use Document Attach, how to attach document transactions, and how to properly store and view documents.
October 17
9:00 am – 9:25 pm PST
Author
