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
1-Purchasing
2-sales

CM20203 Checkbook EFT Transaction Batch

EFT_STATUS
1 – pending generation
2 – marked for generation
3 – already generated (not used)

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.

What Is New in Dynamics GP?

Get 8 premium pieces of content that will help you plan a Dynamics GP upgrade!

Get the Upgrade Guide

What Is New in Dynamics GP?

Get the Upgrade Guide