All transction report by part /Name / - Purchase / Sale /Produce / Issue

[Former Member]

I have tried the following program for run the above requirement. this is only showing part passed through both tranasation.

I wand all trans, if trans not done it show zero value.

Please help me

SELECT T0.[ItemCode], T0.[ItemName], T0.[ItmsGrpCod],T1.[ItmsGrpNam], sum(T2.Quantity) 'GRN',  Sum(t3.Quantity) 'Ship' FROM OITM T0 

INNER JOIN OITB T1 ON T0.ItmsGrpCod = T1.ItmsGrpCod

INNER JOIN POR1 T2 ON T0.Itemcode = T2.Itemcode

INNER JOIN DLN1 T3 ON T0.ItemCode = T3.Itemcode GROUP BY T0.[ItemCode], T0.[ItemName], T0.[ItmsGrpCod],T1.[ItmsGrpNam] ORDER BY T0.[ItemCode]

Thanks

Anantha Desai

[kothandaraman_nagarajan]

Hi Anantha Desai,

Please provide exact requirement for query and also explain the process flow. The above query is not giving that much information to create query.

Thanks & Regards,

Nagarajan

[Former Member]

Report requirement of reconsilation as required

From Date :                                         To :  Date

All detail in Qty

Part No |  Part Name  | Open  | Pur | Prod  | Issue-Prod | Add  | Remove | Transfer | Balance

Provide your number, I will call you

Thanks

Anantha Desai

9845721048

[kothandaraman_nagarajan]

Hi,

Do you have any relationship between purchase and production order? means is there any common field between PO and Production order?

If no, it is diffcult to get such query. You may get separeate query for Purchase process and Production process.

Thanks & Regards,

Nagarajan

[Former Member]

This is to understand the part, all transactions done. No internal relationship

[kothandaraman_nagarajan]

Hi,

Have you checked inventory audit report under inventory reports?

Thanks & Regards,

Nagarajan

[Former Member]

Inventory audit report provide the in report form one bellow one, I want transaction sum one next to one as summary report between the dates.

Thanks

Anantha Desai