DynamicAccounting.netYou, Me, and Dynamics GP

2016-02-09 · 2016

Weekly Dynamic: Auditing EFT Changes

Payables & ReceivablesFraud, Audit & Controls

Archived post from 2016. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

If you’re looking to audit data in GP with a tool like Fastpath’s Audit Trail, auditing changes to EFT settings is important too. I thought I’d mention a few relevant tables here:

SY06000 – Address Electronic Funds Transfer Master – Holds EFT settings assigned to a vendor or customer address. This holds a customer/vendor account, routing, swift code, etc. Audit this table to see initial setup of EFT and monitor changes to EFT settings.

CM90001 – Checkbook EFT Log – Log file generated when an EFT file is created. Audit this to capture the creation of EFT transactions include file summary information.

CM20203 – Checkbook EFT Transaction Batch – EFT Batch information. Audit this for batches related to EFT.

CM20202 – Checkbook Transaction Electronic Funds Transfer – EFT Transaction information. Audit this for transaction specifics related to EFT. Generally not recommended due to potentially large volumes.