(pdo-mysql): INSERT INTO sc_log (inserted_date, username, application, creator, ip_user, action, description) VALUES ('2026-08-26 06:19:15', '', 'grid_commission_agent_allocation', 'Scriptcase', '192.168.0.21', 'access', '')  
(pdo-mysql): select count(*) from (SELECT Idtid, InvId, Unqkey, LocCd, SlDivCd, CustTpCd, CustCd, ItemCd, BsVal, GrVal, CrdPrd, IGpId, InvDt, VendorCd, advtpmstid, IsAdvreq, AdvAdjAmt, AdvAmt, IsAdvRcv, Compct, IncentivePct, CDPct, CDAmt, InterestPct, InterestAmt, ComAmount, CollectionVchId, ReceiptDate, CommPaid, CmPaymentVchId, IncentivePaid, IncentivePmVchId, IncentiveAmount, cmadvanceId, LrDt, NoDays, IntNoDays, TotInv, TotRcv, Percent, cmagrtypeid, UpdBy, CreatedBy, UpdDtTm, CreatedDtTm, Alloc_Date FROM invitbtcommission where VendorCd="" and InvDt>='' and InvDt<='' AND ItemCd IN (SELECT ItemCd FROM cmprdgrpitems WHERE cmprdgrpmstid IN ( SELECT cmprdgrpmstid FROM cmagentagrprdgrp WHERE VendorCd='')) and CustCd IN (SELECT CustCd FROM cmagentcust WHERE VendorCd='')) nm_sel_esp  
(pdo-mysql): SELECT LocCd, CustTpCd, CustCd, ItemCd, BsVal, GrVal, IGpId, InvDt, CrdPrd, Compct, IncentivePct, CDPct, InterestPct, SlDivCd, advtpmstid, cmagrtypeid, Idtid, InvId, Unqkey from (SELECT Idtid, InvId, Unqkey, LocCd, SlDivCd, CustTpCd, CustCd, ItemCd, BsVal, GrVal, CrdPrd, IGpId, InvDt, VendorCd, advtpmstid, IsAdvreq, AdvAdjAmt, AdvAmt, IsAdvRcv, Compct, IncentivePct, CDPct, CDAmt, InterestPct, InterestAmt, ComAmount, CollectionVchId, ReceiptDate, CommPaid, CmPaymentVchId, IncentivePaid, IncentivePmVchId, IncentiveAmount, cmadvanceId, LrDt, NoDays, IntNoDays, TotInv, TotRcv, Percent, cmagrtypeid, UpdBy, CreatedBy, UpdDtTm, CreatedDtTm, Alloc_Date FROM invitbtcommission where VendorCd="" and InvDt>='' and InvDt<='' AND ItemCd IN (SELECT ItemCd FROM cmprdgrpitems WHERE cmprdgrpmstid IN ( SELECT cmprdgrpmstid FROM cmagentagrprdgrp WHERE VendorCd='')) and CustCd IN (SELECT CustCd FROM cmagentcust WHERE VendorCd='')) nm_sel_esp order by Idtid asc LIMIT 0,102  
Report of Agent Wise Commission
Report of Agent Wise Commission
    Exit   Export     Search
No Records Found