ranafaraz

SELECT
	
	concat(o.value, ' - ', o.name) AS Org,
	concat(vwc.majorheadvalue, ' - ', vwc.majorhead) AS MajorHead,
	concat(vwc.minorheadvalue, ' - ', vwc.minerhead) AS MinorHead,
	concat(vwc.subheadvalue, ' - ', vwc.subhead) AS SubHead,
	concat(vwc.value, ' - ', vwc.name) AS BudgetHead,
	SUM(f.amt) AS Allocation,
	SUM(i.grandtotal) AS Utilization
FROM

ranafaraz

SELECT 
	ep.title AS Equipment_Type,
	e.title AS Equipment,
	e.picture
	
FROM 
equipments e
INNER JOIN equipements_type ep ON (( ep.id = e.type_id ))

GROUP BY

ranafaraz

SELECT

	i.documentno AS Invoice_No,
	p.documentno AS Payment_No,
	concat(bacct.name, ' - ', bacct.accountno) AS Bank_Acct,
	concat(ev.value, ' - ', ev.name) AS Charge_Head,
	concat(o.value, ' - ', o.name) AS Charge_Org,
	i.dateinvoiced,
	i.dateacct,
	bp.value AS Search_Key,

ranafaraz

SELECT
	concat(vwc.majorheadvalue, ' - ', vwc.majorhead),
	
	SUM(f.amt) AS Current_Allocation
FROM
	gl_fund f
	INNER JOIN ad_org o ON (( o.ad_org_id = f.ad_org_id))
	INNER JOIN gl_budget b ON (( b.gl_budget_id = f.gl_budget_id ))
	INNER JOIN f_vwchart vwc ON (( vwc.c_elementvalue_id = f.c_elementvalue_id ))
	

ranafaraz

SELECT 
	
	b.name AS Bank_Name,
	
	bacct.accountno,
	
-- 	COUNT(bacct.c_bankaccount_id),
-- 	SUM(ob.currentbalance)
	
	bacct.bankaccounttype,

ranafaraz

SELECT SUM(mp.market_price) FROM adempiere.market_price mp WHERE mp.ad_client_id = 1000000 AND mp.isactive = 'Y'
--

ranafaraz

// Call out to hit Account Book of IUB
		
			@SuppressWarnings("resource")
				public String account_book_api(Properties ctx, int WindowNo, GridTab mTab,
						GridField mField, Object value, Object oldValue) throws IOException
				{
					int c_invoice_id = Integer.parseInt((String) mTab.getValue("c_invoice_id").toString());
					
					String sql = "SELECT " + 
							"i.c_invoice_id AS Trans_ID," +

ranafaraz

-- This query is deprecated as withholding taxes has been moved to Invoice (Vendor) window.
SELECT
	( CASE WHEN ( P.c_doctype_id = ( 1000012 ) :: NUMERIC ) THEN 'Bank Payment Voucher' :: TEXT ELSE'Cash Receiving Voucher' :: TEXT END ) :: CHARACTER VARYING ( 70 ) AS print_title,
-- Client
	( SELECT cl.NAME FROM adempiere.ad_client cl WHERE cl.ad_client_id = i.ad_client_id ) AS Client,
-- Organization
	concat ( org.VALUE, ' - ', org.NAME ) AS Org,
-- BPartner Variables
	concat ( bp.NAME, ' (ID: ', bp.VALUE, ') ', bp.description ) AS BPartner,
-- Invoice Variables

ranafaraz

-- Static values were replaced by dynamic Form values in the Callout.

SELECT
	f.amt AS Total_Budget,
	(
	SELECT SUM
		( linetotalamt ) 
	FROM
		( adempiere.c_invoiceline ledger INNER JOIN adempiere.c_invoice lgi ON ( ( ledger.c_invoice_id = lgi.c_invoice_id ) ) ) 
	WHERE

ranafaraz

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:_0="http://idempiere.org/ADInterface/1_0">
   <soapenv:Header/>
   <soapenv:Body>
      <_0:setDocAction>
         <_0:ModelSetDocActionRequest>
            <_0:ModelSetDocAction>
               
               
               <_0:serviceType>complete_payment</_0:serviceType>
               <_0:tableName>C_Payment</_0:tableName>