on 07-08-2010 12:02 PM
Dear Experts,
I need help in below query.. when i was tried it shown an error message:
INV1, Itemcode | INV1, Dscription | ORDR, NumAtCard | POR1, Quantity/ OITM, SalpackUN | INV1, Quantity/OITM, SalpackUN
Selection Criteria:
1. OINV, Docdate greater than and
2. OINV, Docdate Smaller than and
3. OINV, CardName
Please kindly help me out....
Thanks and Regards,
Manikandan
Hi Mani,
You are querying the Sales Orders (ORDR, RDR1), Purchase Orders (OPOR, POR1) and A/R Invoices (OINV, INV1) tables.
What information are you trying to achieve that requires such a query? I ask this because I don't know if there is a direct connection between the Sales and Purchase documents and, in case there isn't, you won't get any usable results.
Best Regards,
Vítor Vieira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vieira,
I made a mistake in that posting.... Plz kindly look at the bellow query..
INV1, Itemcode | INV1, Dscription | ORDR, NumAtCard | INV1, Quantity/OITM, SalpackUN
Selection Criteria:
1. OINV, Docdate greater than and
2. OINV, Docdate Smaller than and
3. OINV, CardName
Thanks and Regards,
Manikandan
Hi Mani,
Please use the query Parminder kaur provided, but copy it from my post (Parminder did't use the code tags and his query is missing some characters
SELECT
INV1.ItemCode, INV1.Dscription, OINV.NumAtCard, (INV1.Quantity / OITM.SalPackUn)
FROM
OINV INNER JOIN
INV1 ON OINV.DocEntry = INV1.DocEntry INNER JOIN
OITM ON INV1.ItemCode = OITM.ItemCode
WHERE
OINV.DocDate BETWEEN '[%0]' AND '[%1]' AND OINV.CardName = '[%2]'
Regards,
Vítor Vieira
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.