on 07-19-2011 9:21 AM
Hi All,
We want GOODS INWARD AND OUTWARD REPORT IN FOLLOWING FORMAT.
INWARD
DATE PARTY INV NO# PRODUCT QTY TOTAL CARTONS TRANSPORTER
SAME FOR OUTWARD
IN ORDER TO CREATE THE REPORT I CREATED A PACKAGING LIST IN TEST DB ON DELIVERY.
AND TRIED FOLLOWING QUERY BUT IT IS NOT GIVING ME THE DESIRED RESULT.
SELECT I0.DOCDATE , I0.CARDNAME , I0.DOCNUM , I1.DSCRIPTION , SUM(D3.QUANTITY) , COUNT(D2.PACKAGENUM) , D2.PACKAGETYP
FROM OINV I0 INNER JOIN INV1 I1 ON I0.DOCENTRY = I1.DOCENTRY
LEFT OUTER JOIN ODLN D0 ON I1.BASEENTRY = D0.DOCENTRY
INNER JOIN DLN1 D1 ON D0.DOCENTRY = D1.DOCENTRY
INNER JOIN NNM1 S0 ON I0.SERIES - S0.SERIES
INNER JOIN NNM1 S1 ON D0.SERIES = S1.SERIES
LEFT OUTER JOIN DLN7 D2 ON D0.DOCENTRY = D2.DOCENTRY
INNER JOIN DLN8 D3 ON D2.DOCENTRY = D3.DOCENTRY
GROUP BY I0.DOCDATE , I0.CARDNAME , I0.DOCNUM , I1.DSCRIPTION , D2.PACKAGETYP
PLEASE HELP ME IN THIS QUERY
THANKS
MALHAAR
Hi All,
Please help me to re frame this query. I'm badly stuck in this
Thanks
Malhaar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Malhaar..........
For Inward and Outward Register you can have those details in UDO where you have to create the Fields in Sequenec order as you mentioned in your thread.
This will give you proper details of what you expect. But this would be the data entry........
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Malhaar..........
For Inward and Outward Register you can have those details in UDO where you have to create the Fields in Sequenec order as you mentioned in your thread.
This will give you proper details of what you expect. But this would be the data entry........
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Malhaar..........
For Inward and Outward Register you can have those details in UDO where you have to create the Fields in Sequenec order as you mentioned in your thread.
This will give you proper details of what you expect. But this would be the data entry........
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
which document you are using for inword and outword the quantity..
Regards
Deepak tyagi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.