Dynamics Community Forum Thread Details

AP Cks posted to incorrect period

Is there a query that can be run to correct the period to post for checks that have been posted and released? We have a batch of checks that were posted to a future period and they have already cleared teh bank.

Hello C,

We don't have one query to do what you are looking for. Several tables are updated when you release a check batch. In addition, vendor history is also updated. Generally we recommend voiding the checks and reissuing them even though you must use a different check number. If you want to pursue this on your own, you would need to look at the APdoc, Aptran, Apadjust tables for AP. Also, for the voucher document in APdoc, you would need to correct the PerClosed field. You could correct vendor history in the Vendor History screen. In GL, you can bring up the batch in the Journal Transactions screen while in Inititalize Mode and change the period to post and save. That will sufficiently correct the GL tables prior to posting.

This is generally unsupported method to correct a check batch and if done improperly, could cause various issues, especially if you also use Cash Manager. I would try it in a copy of your live database first.

Quick Links