cancel
Showing results for 
Search instead for 
Did you mean: 

Query Print layout Design

Former Member
0 Kudos

Create query --

How many quanty received by Goods Received PO within one month for a perticular Group and what is total amount of purchase group item?

Edited by: Philip Eller on Jun 26, 2008 10:58 AM

Accepted Solutions (1)

Accepted Solutions (1)

former_member187989
Active Contributor
0 Kudos

sandeep,

docentry is internal key generated to link opdn table with

other tables like pdn1,pdn2,pdn3 etc.

Jeyakanthan

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Use this query

SELECT SUM(T1.Quantity) AS TOTAL_QTY, SUM(T1.LineTotal) AS TOTAL_PRICE FROM OPDN T0 INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OITB T3 ON T2.ItmsGrpCod = T3.ItmsGrpCod WHERE T3.ItmsGrpNam = N'[%0]' AND (T0.DocDate >= N'[%1]' AND T0.DocDate <= N'[%2]')

Select the item group and type the start date and end date

Hope it could be helpful.

Sagar

Former Member
0 Kudos

give me more detail of field(DocEntry )

Former Member
0 Kudos

can u tell me what are details u needed in taht Print Layout.

Sagar