Dynamics Community Forum Thread Details

Checkbook Balance Inquiry showing wrong date

Hi,

Our finance reported an error, they make a deposit transaction in GP (version 10.0) on 30-Sep-13 for which they took hard copy print out.

They then void this check on 30-Oct-13. After that inquiry (check book balance OR check book register) does not showing any transaction on 30-Sep-13. However, it is showing voided transaction for the date 30-Oct-13. Now, to reconcile balance with the bank they need to show the acutal deposit transaction that happened on 30-Sep-13.

I checked "CM20200" table and found that this transaction has TRXDate and GLPOSTDT as 30-Oct-13. Also, it shows VOIDDATE and VOIDPDATE same as 30-Oct-13.

Since, they have hardcopy printout for 30-Sep-13 so we have to accept that such deposit was actually made on 30-Sep-13.

Can anyone help me to resolve this issue. In any case I need to show deposit transaction on 30-Sep-13 and Void transaction on 30-Oct-13.

Regards,

Waliullah

If you void a deposit transaction rather than original transaction date, GP will update the date values for the fields VOIDDATE and VOIDPDATE in CM20200 table. Void transation will never affect/update to the original transaction date and posting date.

Based on the CM20200 table records, the deposit transaction created date and voided date are same(30-Oct-13). You already mentioned, the print out of original deposit transaction has the date of 30-Sep-13. So, I guess somebody was updated TRXDate and GLPOSTDT in back end.

To resolve this issue, you need to update TRXDate and GLPOSTDT to 30-Sep-13 in SQL.

Note: Before updating these date fields make sure you have a latest backup for company database.

Hope this helps!!!

Quick Links

Leaderboard