Queries: Invoices, Orders and Quotes - Revision history

Ngordon7000: Ngordon7000 moved page Code Scratchpad: Queries: Invoices, Orders and Quotes to Queries: Invoices, Orders and Quotes

2021-07-28T05:57:01Z

2017-09-30T01:24:41Z

Invoice and tax

2016-10-26T11:31:21Z

Orders with more detail

2016-10-26T11:29:32Z

Orders

2016-05-13T08:27:30Z

Orders

2015-09-07T13:26:43Z

Orders

2015-09-07T13:26:26Z

Orders

2015-09-07T12:38:25Z

Payments

2015-08-31T18:01:18Z

Add category

2015-08-05T06:53:05Z

Last payment related to an invoice

@@ Line 56: / Line 56: @@
   <nowiki>select
-	a.documentno, a.totallines, a.grandtotal, a.istaxincluded, a.dateinvoiced, a.dateacct,
+  b.c_invoice_id, b.c_invoiceline_id, a.documentno, a.totallines, a.grandtotal, a.istaxincluded, a.dateinvoiced, a.dateacct,
-	b.qtyinvoiced,b.qtyentered, b.pricelist, b.priceactual, b.pricelimit, b.priceentered, b.linetotalamt, b.taxamt
+  a.docstatus, coalesce(a.c_doctype_id, a.c_doctypetarget_id) as c_doctype_id,
-	from
+	b.qtyinvoiced,b.qtyentered, b.pricelist, b.priceactual, b.pricelimit, b.priceentered, b.linenetamt, b.linetotalamt, b.taxamt
-c_invoice a
+from
-join c_invoiceline b on a.c_invoice_id = b.c_invoice_id
+  c_invoice a
 where
 	a.documentno='INW82785';

@@ Line 30: / Line 30: @@
 ;</nowiki>
-== Orders with more detail ==
+== With more detail ==
   <nowiki>select

@@ Line 28: / Line 28: @@
 group by a.ad_client_id, dt.name
 order by dt.name
+;</nowiki>
-</nowiki>
+ <nowiki>select
 = Invoice and tax =

@@ Line 19: / Line 19: @@
 order by b.line;
-select a.c_order_id from c_order a where a.documentno='24307';</nowiki>
+select a.c_order_id from c_order a where a.documentno='24307';
 = Invoice and tax =

@@ Line 19: / Line 19: @@
 order by b.line;
-select a.c_order_id from c_orderline a where a.documentno='24307';</nowiki>
+select a.c_order_id from c_order a where a.documentno='24307';</nowiki>
 = Invoice and tax =

← Older revision		Revision as of 12:38, 7 September 2015
Line 76:		Line 76:

	Credit:Anozi Mada		Credit:Anozi Mada
		+
		+	== Link from POS Order to the invoice to the payment ==
		+
		+	<nowiki>select
		+	posorder.documentno, pmt.documentno
		+	from
		+	c_order posorder
		+	join
		+	c_invoice inv on inv.c_order_id = posorder.c_order_id
		+	join
		+	c_payment pmt on pmt.c_payment_id = inv.c_payment_id
		+	where posorder.documentno = '80014';</nowiki>

← Older revision		Revision as of 18:01, 31 August 2015
Line 1:		Line 1:
	[[Category:Code Scratchpad]]		[[Category:Code Scratchpad]]
		+	[[Category:Development‏‎]]
		+	[[Category:Developer documentation‏‎]]

	= Orders =		= Orders =

@@ Line 71: / Line 71: @@
 LIMIT 1</nowiki>
-Discussion [https://groups.google.com/forum/#!topic/idempiere/J17EgtVzVKk|here]
+Discussion [https://groups.google.com/forum/#!topic/idempiere/J17EgtVzVKk here]
 Credit:Anozi Mada