#929
UPDATE `manual_transactions` SET `transref_list`='' WHERE `manual_transaction_id`=929 LIMIT 1;
UPDATE manual_transactions SET amount=amount+1002.16 WHERE manual_transaction_id=929;
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,1002.16,91,75,223,1,1,"2014-03-14",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;



#1681
UPDATE `manual_transactions` SET `amount`=1650.00 WHERE `manual_transaction_id`=1229 LIMIT 1;
UPDATE `manual_transactions` SET `reference_to`='3865' WHERE `manual_transaction_id`=1229 LIMIT 1;
UPDATE `manual_transactions` SET `reference_to`='' WHERE `manual_transaction_id`=1229 LIMIT 1;



#3488
UPDATE `manual_transactions` SET `transref_list`='775,776,778,1429,3115' WHERE `manual_transaction_id`=3488 LIMIT 1;
UPDATE `manual_transactions` SET `transref_list`='6903,6922' WHERE `manual_transaction_id`=7595 LIMIT 1;
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,1455.07,91,43,65,1,1,"2014-10-07",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount+1455.07 WHERE manual_transaction_id=3488;




#6651
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,8.31,92,46,128,1,1,"2014-12-31",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount-8.31 WHERE manual_transaction_id=6651;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=2737 LIMIT 1;




#3490
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,4200.55,91,43,72,1,1,"2014-10-07",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount+4200.55 WHERE manual_transaction_id=3490;


#6656
UPDATE `invoice_master` SET `manual_transaction_id`=4979 WHERE `invoice_id`=726 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=4979 WHERE `invoice_id`=4590 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=4979 WHERE `invoice_id`=4643 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=4979 WHERE `invoice_id`=6758 LIMIT 1;
UPDATE invoice_master
SET manual_transaction_id=4979
WHERE invoice_id IN (6866,6960,7317,7436,7505,7640,7673);


INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,1174.63,92,43,65,1,1,"2014-12-31",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount-1174.63 WHERE manual_transaction_id=6656;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=12234 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=12235 LIMIT 1;



#8477
INSERT INTO `invoice_reserve` (`manual_transaction_id`, `invoice_id`, `reserve`, `created_at`) VALUES (8024, 10543, 125.32, '2015-06-28 05:54:12');
UPDATE `invoice_master` SET `manual_transaction_id`=8024 WHERE `invoice_id`=10543 LIMIT 1;
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,40.86,91,218,521,1,1,"2015-03-03",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount+40.86 WHERE manual_transaction_id=8477;




#7595
UPDATE `manual_transactions` SET `transref_list`='6903,6922,3114,774,777' WHERE `manual_transaction_id`=7595 LIMIT 1;



#11383
UPDATE `invoice_reserve` SET `reserve`=8105.33 WHERE `invoice_reserve_id`=20555 LIMIT 1;
UPDATE `manual_transactions` SET `amount`=amount+4252.36 WHERE `manual_transaction_id`=11383 LIMIT 1;
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,4252.36,91,253,723,1,1,"2015-05-18",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;

#12337
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,0.15,92,218,521,1,1,"2015-06-11",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount-0.15 WHERE manual_transaction_id=12337;
UPDATE `invoice_reserve` SET `reserve`=113.65 WHERE `invoice_reserve_id`=17350 LIMIT 1;




#11067
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=9210 LIMIT 1;
DELETE FROM `manual_transactions` WHERE `manual_transaction_id`=10327 LIMIT 1;
DELETE FROM `manual_transactions` WHERE `manual_transaction_id`=10329 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=19323 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=19324 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=19325 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=19326 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=19327 LIMIT 1;

DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=19348 LIMIT 1;
UPDATE `manual_transactions` SET `reference_to`='6659,7020,7019,7057,7193,7294,7293,7456,7457,7460,7658,7721,7725' WHERE `manual_transaction_id`=10351 LIMIT 1;
UPDATE `manual_transactions` SET `reference_to`='6659,7020,7019,7057,7193,7294,7293,7456,7457,7460,7658,7721,7725' WHERE `manual_transaction_id`=10353 LIMIT 1;
UPDATE `manual_transactions` SET `trailing_balance`=1 WHERE `manual_transaction_id`=10351 LIMIT 1;
UPDATE `manual_transactions` SET `trailing_balance`=1 WHERE `manual_transaction_id`=10353 LIMIT 1;
UPDATE `manual_transactions` SET `trailing_balance_amt`=2499.6 WHERE `manual_transaction_id`=10351 LIMIT 1;
UPDATE `manual_transactions` SET `trailing_balance_amt`=2499.6 WHERE `manual_transaction_id`=10353 LIMIT 1;
INSERT INTO `manual_transactions` (`manual_transaction_id`, `transaction_type`, `debtor_id`, `originator_id`, `currency_id`, `parent_id`, `prev_parent_id`, `fx_rate`, `actual_fx_rate`, `amount`, `debtors`, `reference_to`, `specific_allocation`, `balance`, `current_balance`, `notes`, `transaction_file`, `specific_deductible`, `deductible_amount`, `trailing_balance`, `trailing_balance_amt`, `transref_list`, `reconcile_payment`, `reconcile_ref`, `payment_return`, `false_payment`, `amendment_id`, `status`, `reconcile_status`, `reconcile_credit`, `multiple_payments`, `multiple_status`, `interface`, `paid_balance`, `paid_status`, `processed_amount`, `transaction_date`, `notification_title`, `transaction_name`, `issue_date`, `created_at`, `created_by`, `modified_at`, `modified_by`, `authorised_at`, `authorised_by`) VALUES (null, 17, 0, 76, 0, 0, 0, 0.0000, 0.0000, 2499.6, '217', '', 0, 0.00, 0.00, '', '', 0, 0.00, 0, 0.00, '', 0, 10353, 0, 0, 0, 1, 0, 0, '', 0, 1, 0.00, 0, 0.00, '2014-09-19', 0, '', '0000-00-00', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0);

DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5553 LIMIT 1;
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,3.57,92,76,217,1,1,"2015-05-12",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount-3.57 WHERE manual_transaction_id=11067;



#9502
UPDATE `invoice_reserve` SET `reserve`=1051.54 WHERE `invoice_reserve_id`=18267 LIMIT 1;
UPDATE manual_transactions SET amount=amount-60.68 WHERE manual_transaction_id=9502;
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,60.68,92,232,557,1,1,"2015-03-31",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;


#6661
INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,93,91,43,79,1,1,"2014-12-31",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount+93 WHERE manual_transaction_id=6661;