Hi Experts,
I have did the queries as below but i have a problem to link to RIR2 which is Freight charges. I have tried after i linked the result is no correct.
Please Kindy advise.
SELECT T0.LineStatus AS 'Row Status', T1.DocDate AS 'Posting Date', T1.CardName AS 'Customer/Vendor Name', T1.NumAtCard AS 'Customer/Vendor Ref. No.', T0.ItemCode AS 'Item No.', T0.Dscription AS 'Item/Service Description', T0.CodeBars AS 'Bar Code', T0.Quantity AS 'Quantity', T0.OpenCreQty AS 'Balance Qty', T0.Price AS 'Unit Price', T0.VatGroup AS 'Tax Group', T0.VatSum AS 'Total Tax - Row', T0.U_TRFREMARK AS 'Transfer Remark', T0.U_PERFREIGHT1 AS 'Per Freight 1', T0.U_RIRNO AS 'RIR No', T0.U_PERFREIGHT2 AS 'Per Freight 2', T0.U_DELIVERPRICE AS 'Deliver Price', T0.ShipDate AS 'Row Delivery Date', T1.Comments AS 'Remarks' FROM [dbo].[RDR1] T0 INNER JOIN [dbo].[ORDR] T1 ON T1.DocEntry = T0.DocEntry
RDR2 table
SELECT T0.DocEntry AS 'Document Key', T0.ExpnsCode AS 'Freight Code', T0.PaidSys AS 'Paid (SC)', T0.PaidFC AS 'Paid (FC)' FROM [dbo].[RDR2] T0
Thanks.
Regards,
Danny
Edited by: Danny Gan on Apr 27, 2009 5:07 PM