Can I change a batch posting date after it is posted?

(0) Share

Report

Posted on by SaritaEl

245

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...

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

Saritael,

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?

Was this reply helpful? Yes No
SaritaEl 245 on at

Like (0)

Report

The batch was for AR receivables.

Thanks

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

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;

Was this reply helpful? Yes No
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
SaritaEl 245 on at

Like (0)

Report

Thank you all! This helped a lot .

Was this reply helpful? Yes No
Kpham 15 on at

Like (0)

Report

In regards to accounts payable...does anyone know how to edit the batch ID name after it's posted?

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

KPHAM

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,

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

I am agree with above Mahmoud point.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kpham 15 on at

Like (0)

Report

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.

Was this reply helpful? Yes No