on 07-03-2015 10:21 AM
Hi experts,
I need user query for Warehouse wise customer billing report like AR invoices. Please do needful.
Hi Vignesh,
Try by this query
SELECT T0.[DocNum], T0.[DocType], T0.[CardCode], T0.[CardName], T0.[DocStatus],T0.[DocDate], T0.[DocTotal], T0.[VatSum], T0.[VatPercent], T1.[Dscription], T1.[Quantity], T1.[WhsCode], T1.[SlpCode], T1.[ItemCode] FROM OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[WhsCode] =[%0]
Regards,
Bhushan Verma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try with this query,
SELECT T0.[DocNum], T0.[DocType], T0.[DocStatus], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[WhsCode], T2.[WhsName], T0.[DocTotal] FROM OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OWHS T2 ON T1.[WhsCode] = T2.[WhsCode]
where T1.[WhsCode] = [%0]
Regards,
Bhushan Verma
Hi Vigesh
Try the below query i think it will helps you
SELECT T0.[CardCode] AS 'Customer/Vendor Code', T0.[CardName] AS 'Customer/Vendor Name', t2.GroupName,t1.CardType ,T0.[ItemCode] AS 'Item No.',
T0.[Dscription] AS 'Item Description', T0.[OutQty] AS 'Sales Quantity Quantity' FROM [dbo].[OINM] T0
inner join ocrd t1 on t1.cardcode=t0.cardcode
inner join ocrg t2 on t2.GroupCode=t1.GroupCode
WHERE (T0.[DocDate] = (CONVERT(DATETIME, '[%0]', 112) ) ) AND (T0.[Warehouse] = (N'[%1]' ) )
With Regards
Balaji Sampath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
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.