SkyBiz Support Ticket

Knowledgebase

SkyBiz Support Ticket > SkyBiz Support Ticket > Knowledgebase

» Category: MySQL Query (Go back)

» Articles in this category:

Delete journal From Point Of Sales for those posted using method "By Transaction"

Below is query to delete journal posted from Point Of Sales and posted using method "By Transaction": Delete From journal1 Where D_ate Between 'yyyy/mm/dd' And 'yyyy/mm/dd' And TranType = 'GJ'

Query For Empty Tax Code

SELECT H.D_ate, D.RunNo, D.ItemCode, D.Description, D.Qty, D.HCUnitCost, D.HCTax, ((6/106)*D.HCLineAmt) as vHCTax, D.HCLineAmt, D.DetailTaxCode, D.TaxRate1 FROM stk_cus_inv_dt D INNER JOIN stk_cus_inv...

Query for Unreconcile Bank by Account Code

UPDATE journal1 SET reconed = 'U' WHERE AcountCode = 'B60-0100'

Query to Unmatch Deleted Credit Note on Property

Select * from match_bill where TRNNO = 'xxx'

Query for checking multiple collection in same transaction number

SELECT H.D_ate, R.* FROM stk_receipt2 R INNER JOIN stk_cus_inv_hd H ON R.Doc1No = H.Doc1No WHERE H.D_ate BETWEEN '2016/06/01' AND '2016/06/30' GROUP BY R.Doc1no HAVING COUNT(R.Doc1No) > 1;

Query For Checking Incorrect Total Detail Tax

SELECT H.D_ate, H.Doc1No, H.HCDtTax, SUM(D.HCTax) AS vDtTax FROM stk_cus_inv_hd H INNER JOIN stk_cus_inv_dt D ON H.Doc1No = D.Doc1No WHERE H.HCDtTax <> 0 GROUP BY D.Doc1No HAVING H.HCDtTax &l...

Guide(s) to Change Tax Computation Method

Below are Guide(s) to Change Tax Computation Method from Calculate Tax Payable & Expenses to Calculate Tax Payable Only Step A. Go to Start

Insert Project Budget Missing Detail From Backup

INSERT INTO STK_PRJT_BUDGET_DT SELECT * FROM 'BACKUPDATA'. STK_PRJT_BUDGET_DT WHERE DOC1NO = 'XXXX'

Query for switch empty location code to specific location code

Update stk_grndo_dt SET LocationCode = 'xxx' Where LocationCode = ''; Update stk_sup_inv_dt SET LocationCode = 'xxx' Where LocationCode = ''; Up

Query for switch empty branch code to specific branch code

Update stk_pur_requis_dt SET BranchCode = 'xxx' Where BranchCode = ''; Update stk_pur_order_dt SET BranchCode = 'xxx' Where BranchCode = ''; Update stk_g

MyFinancial - Query for switch Global Tax To Detail Tax

UPDATE sys_general_setup4 SET E_num = '0' WHERE C_ode = 'Fin_TaxCompMethod'