Greetings,
I would like to inquire about a method for extracting transactions or orders from an existing batch and transferring them to a new batch. Here is the issue we are currently facing and our goals:
Our consortium's patron services mistakenly used an incorrect payment method when processing an order. To rectify this, they created a new order in a separate batch. However, our revenue reports are based on the posting date of the batch. Consequently, the first batch contains an order with the incorrect payment method, while the corrected order is included in the second batch, which has a different date. Unfortunately, we cannot simply unpost the first batch and repost it on the same day, as it contains other orders. Therefore, we are seeking a procedure to separate those specific orders from the second batch and add them to the new batch.
Best,
Mohammed
Hi Mohammed,
There is no front-end method to change the batch that a transaction was performed in, and we do not recommend changing financial details like this using custom scripting in the database. It sounds like you are following the recommended practice of aligning the dates of the transactions, batches, and postings for the clearest reporting. I suggest making note of this situation in the batch notes of both batches so you have it on record, and making similar notes in your general ledger when the transactions are posted there.
Thank you, Michael, for your response; I was looking for an SQL solution in the backend.