I posted a batch and then i realized i had the wrong posting date... is there a way to change the posting date of the batch even after it has posted???voiding out all the transactions in this batch is not an option since there are a lot of transactions...
The batch will be deleted once it has been posted.
We can only change the posted transaction date through back end. I give you the code.
Before, i want to comfirm the which batch(AP Payables, AP manual Payement, AR receivables, GL Journal Trans,..etc) did you posted?
The batch was for AR receivables.
I would not recommend changing the transaction data at the database level, there is a general ledger posting data included as well. Therefore, I would simply recommend voiding and re-entering the transactions.
The batch date is included in the setup, under the "posting date from" option. You can either choose to have your posting date from the transaction or the batch, as shown below;
I have to second Mohmoud's recommendation to NOT change it in the db. There are too many things to hit. Plus, auditors and such will question this. If the transactions are too many to reverse, take the distributions report and correct the GL. There are other issues with AR receivables and, if the date difference is major, this can affect the customers average days to pay and the ageing and calculation of late charges. If these matter, then void the transactions and re-enter them.
Thank you all! This helped a lot .
In regards to accounts payable...does anyone know how to edit the batch ID name after it's posted?
I should reemphasize on an important issue. The batch is nothing but a container of transactions, all the transactions within will be posted with their associated document numbers and the batch id is gone. You can even use the batch id after it has been posted since it is not unique.
For batch with multiple uses (monthly, weekly, quarterly ..etc), the batch remains after it is posted, it depends on how frequent it is used.
Your feedback is highly appreciated,
I am agree with above Mahmoud point.
Another thought I would like to inject here is the reprinting of posting journals. It is usually best practice to give each batch a unique ID. You can use something like today's data and person's initials. This way in the future, if you ever need to reprint just that batch, you can select to print by batch ID. On the other hand, if you were to reuse the batch ID, then in the future if you reprint by batch ID you will see the combined transactions but the posting date of the transactions would be different. Now this could be why you want to change the batch ID.
Ah, I think I'm asking the wrong question. Is there a way to change a batch posting date? In our office, we used the date as the batch ID name. The issue at hand is trying to correct the batch posting date after its posted.
The batch is a container, when it is posted it disappears from the system
do you want to correct the transaction date ?
No option available for change the batch posting date after it was posted.
You can change the posting date in back-end only. But, this not advisable.
Hope this helps!!!
You can enter a reversing entry in GL to move the transactions from the fiscal period you do not want to the fiscal period you do want.