Correcting wrong values in price layers after tickets have been sold

We have a situation where the price layers from some tickets have been set up with incorrect values and tickets have been sold before this was discovered.  The face value of the tickets remains the same, but the way this has been divided across price layers is incorrect.

I am looking into whether it is possible to correct this in orders sold with the incorrect price layers.  It looks to me like it could be done by:

  • Upading due_amt & paid_amt for relevant rows in T_SLI_DETAIL
  • Updating relevant rows in T_TRANSACTION
  • Updating relevant rows in T_PAYMENT
  • Updating T_GL_POSTING_FTP to divde money correctly across affected gl_account_no's
  • Updating T_GL_POSTING_HISTORY to divde money correctly across affected gl_account_no's

Is there anything that I am missing?  Am I crazy to even contemplate attempting such an adjustment?

Parents
  • Whenever we make a gl mistake, I find out how much should be changed then set-up correction payment methods attached to the GLs and do the adjustment in an order using the cash bag. 

  • Hi Lou, can you please clarify what your process is?  Are you talking about making the correction in each affected order?  We have a lot of orders that need to be adjusted so I was hoping to script something that could do the update in bulk rather than order by order.

  • Hi Sarah,

    No, I don't mean reversing and re-entering each order, but rather finding the total amount that went to the wrong gl, then doing a gl adjustment in one order. You need to create two payment methods (sorry I'm copying and pasting the following):

    To payment method #1, assign the GL account that was incorrectly assigned to the performance (the wrong GL account) -- Income. To payment method #2, assign the GL account that should have been assigned to the performance (aka - the correct GL account) -- Refund. Assign these payment methods to the user group of the user who will make the correction. Then in the Orders window, open a new order and click the Money Bag. In the Amount field, enter the amount that needs to be assigned to the correct GL account. In the Payment Method field, select Payment Method #1. Click the Insert button. In the Amount field, you will see the negative equivalent of the amount that you entered in the first Amount field. In the Payment field, enter Payment Method #2. Click the OK button, enter a source and click the Done button to finish the transaction. 

    Your totals for your price layers will still be incorrect in any ticketing reports, but the gl totals will be corrected. 

    Thanks,

    Lou Ann

Reply
  • Hi Sarah,

    No, I don't mean reversing and re-entering each order, but rather finding the total amount that went to the wrong gl, then doing a gl adjustment in one order. You need to create two payment methods (sorry I'm copying and pasting the following):

    To payment method #1, assign the GL account that was incorrectly assigned to the performance (the wrong GL account) -- Income. To payment method #2, assign the GL account that should have been assigned to the performance (aka - the correct GL account) -- Refund. Assign these payment methods to the user group of the user who will make the correction. Then in the Orders window, open a new order and click the Money Bag. In the Amount field, enter the amount that needs to be assigned to the correct GL account. In the Payment Method field, select Payment Method #1. Click the Insert button. In the Amount field, you will see the negative equivalent of the amount that you entered in the first Amount field. In the Payment field, enter Payment Method #2. Click the OK button, enter a source and click the Done button to finish the transaction. 

    Your totals for your price layers will still be incorrect in any ticketing reports, but the gl totals will be corrected. 

    Thanks,

    Lou Ann

Children