كود لمتابعة حركة المبيعات والمقبوضات [align=left]SELECT dbo.RM20101.CUSTNMBR, dbo.RM20101.DOCNUMBR, dbo.RM20101.RMDTYPAL, dbo.RM20101.DOCDATE, dbo.RM20101.ORTRXAMT,dbo.RM00101.CUSTNAME, dbo.RM40401.DOCDESCR, dbo.RM20101.CURNCYID, CASE WHEN dbo.RM20101.RMDTYPAL = 1 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS Sales, CASE WHEN dbo.RM20101.RMDTYPAL = 3 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS Sales2, CASE WHEN dbo.RM20101.RMDTYPAL = 1 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS Sales3, CASE WHEN dbo.RM20101.RMDTYPAL = 9 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS Cash, CASE WHEN dbo.RM20101.RMDTYPAL = 7 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS Cash2, CASE WHEN dbo.RM20101.RMDTYPAL = 8 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS returen, dbo.RM00101.CUSTCLAS, dbo.RM20101.TRXSORCE, CASE WHEN dbo.RM20101.RMDTYPAL = 7 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS BankTransfer, CASE WHEN dbo.RM20101.RMDTYPAL = 7 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS Discount, cASE WHEN dbo.RM20101.RMDTYPAL = 7 AND dbo.RM20101.DOCDATE > '12/31/2007' THEN dbo.RM20101.ORTRXAMT ELSE 0 END AS Comuation, dbo.RM20101.TRXDSCRN FROM dbo.RM00101 INNER JOIN dbo.RM20101 ON dbo.RM00101.CUSTNMBR = dbo.RM20101.CUSTNMBR INNER JOIN dbo.RM40401 ON dbo.RM20101.RMDTYPAL = dbo.RM40401.RMDTYPAL[/align] __________________ هذا الموضوع عبارة عن بذرة تحتاج للنمو والتحسين؛ فساهم في إثرائه بالمشاركة فيه [LEFT]Best Regards Ahmed Ibrahim I.T Manager http://ahmedibrahim.net Mobile: +2 010-3438385 Microsoft Certified Business Management Solutions Specialist for Microsoft Dynamics AX 2009,Dynamics CRM4,GP10 Microsoft Certified Business Management Solutions Professional Applications for Microsoft Dynamics GP10 MCTS: SQL Server 2005,Windows SharePoint Services 3.0 ITIL Foundation V3 |