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.
Having worked in a few places where SQL fixes were expected to fix these types of issues - they rarely do and the structure of transactions posted in a batch it too complicated to mess with safely. It's much easier to make a manual adjustment in your finance journals to reflect what you want to see and add batch notes / CSI whatever you need as a paper trail in Tess to match up to if you ever get audited.
Chalk it up to human error (it happens) and move on with lots of notes to support why the adjustment was made.
Best of luck with it all
I greatly appreciate your assistance. I had a conversation with our Finance department. They have committed to reconciling the general ledgers and adding batch notes / CSI, whatever is needed. I appreciate your support.