ALTER TABLE `inv_product_sale` ADD `ips_credit` DECIMAL(11,2) NULL AFTER `ips_balance`;
UPDATE `inv_product_sale` SET `ips_credit` = `ips_grand_total`  WHERE `ips_pay_mode` = 2;