EFT Tables Used in Dynamics GP
Views (180)
Like
Share
ReportEFT 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.
Read Next: 18 Warning Signs Your Business Need the Cloud
This post first appeared first on Encore Business Solutions.
*This post is locked for comments