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