I entered a payables voucher, dated May 31st, and decided to try and print a check at the same time.
I dated the check June 12th.
I tried to post the transaction because the distribution was wrong.
I changed the distribution to
Debit expense
Credit AP
Debit AP
Credit Bank.
The transaction then posted but everything posted with the date of May 31st.
What did I do wrong?
Thanks
*This post is locked for comments
Michael,
When you have a payment date that is different from the invoice date, it is not recommended to record them as one transaction (also sometimes referred to as 'check-on-the-fly') because of the exact issue you saw - there is no option to enter all the dates needed.
Normally, if you enter these as 2 separate transactions, you would have the following 4 dates:
- Invoice Document Date
- Invoice GL Posting Date
- Payment Document Date
- Payment GL Posting Date
When you enter these as one transaction, you do not have the Payment GL Posting Date as an option (there is just nowhere to enter it). So this date defaults to the Invoice GL Posting Date and if that is not the same as the Payment Document Date this will cause a Bank Reconciliation issue. Hope that helps explain what happened.
If this was not posted in a batch and was posted just as a trx, it picked up the transaction date. If it was in a batch and the batch date was set as 06/12/2012 then it would have posted to 06/12/12012. If it was just setup as a trx and you posted the trx looking at your posting setup (tools<<setup<<Posting<<Posting). You'll find that you are allowing trx posting but since you were in the trx window I bet you tell it to pick up the trx. date which it did.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (