In MiClub XClub go to;

Config > General Ledger to retrieve the batch number that is not posting

Open SQL Management Studio and click New Query

Paste the following statement into the window and set the GeneralLedgerBatchID to equal the batch number from above, in this case 9

set Status = 2
where GeneralLedgerBatchId = 9

Execute the query

The client can now resend the batch in MiClub XClub