![]() When MAX(a.TransType)='30' and MAX(a.Debit)>0 then MAX(a.) ![]() When MAX(a.TransType)='24' and MAX(a.DebCred)='D' then (CASE when MAX(a.)=0 then MAX(a.Debit) else MAX(a.)end)- MAX(a.) When MAX(a.TransType)='24' and MAX(a.DebCred)='C' then (CASE when MAX(a.)=0 then -MAX(a.Credit) else -MAX(a.)end)-MAX(a.) ,case when MAX(a.TransType)='13' then MAX(a.) When MAX(a.TransType)='321' then MAX(a.ShortName) end as When MAX(a.TransType)='203' then MAX(a.ShortName) When MAX(a.TransType)='30' then MAX(a.ShortName) When MAX(a.TransType)='14' then MAX(a.ShortName) When MAX(a.TransType)='13' and MAX(a.DebCred)='C' and (LEFT(MAX(a.shortname),1)='C') then MAX(a.ShortName) When MAX(a.TransType)='13' and MAX(a.DebCred)='C' and (LEFT(MAX(a.shortname),1)='_') then MAX(a.contraact) When MAX(a.TransType)='24' and (LEFT(MAX(a.shortname),1)='C') then MAX(a.ShortName) Where convert(varchar, d.refdate, 101)'') then MAX(a.contraact) -and (isnull(MAX(a.Ref3Line),'')'') , MAX(convert(varchar, d.refdate, 101)) as , case when MAX(a.TransType)='13' then D.BASEREF When MAX(a.TransType)='203' THEN 'Dp Invoice' Where convert(varchar, d.refdate, 101)SUM(isnull(b.reconsum,'0')) then MAX(a.Debit) Left join OCRD g on g.CardCode = a.ShortName Left join ORIN f on d.TransType='14' and d.CreatedBy=f.DocEntry Left join OINV e on d.TransType='13' and d.CreatedBy=e.DocEntry Left join OITR c on b.ReconNum=c.ReconNum ![]() Left join ITR1 b on a.TransId=b.TransId and a.Line_ID=b.TransRowId ,MAX(convert(varchar, d.refdate, 101)) as ,MAX(convert(varchar, d.DueDate, 101)) as When MAX(a.TransType)='203' THEN D.BASEREF When MAX(a.TransType)='30' THEN D.BASEREF When MAX(a.TransType)='24' THEN D.BASEREF When MAX(a.TransType)='14' then D.BASEREF When MAX(a.TransType)='203' THEN 'DP Invoice'Ĭase when MAX(a.TransType)='13' then D.BASEREF When MAX(a.TransType)='30' THEN 'Journal Entry' ![]() When MAX(a.TransType)='24' THEN 'Payment' When MAX(a.TransType)='14' then 'Credit Memo' When MAX(a.TransType)='203' and MAX(a.Debit)SUM(isnull(b.reconsum,'0')) then MAX(a.Debit)Ĭase when MAX(a.TransType)='13' then 'Invoice' When MAX(a.TransType)='203' and MAX(a.Debit)=SUM(isnull(b.reconsum,'0')) then MAX(a.) + SUM(isnull(b.reconsum,'0')) When MAX(a.TransType)='321' and MAX(a.Debit)>0 then MAX(a.) + SUM(isnull(b.reconsum,'0')) When MAX(a.TransType)='30' and MAX(a.Debit)>0 then MAX(a.) + SUM(isnull(b.reconsum,'0')) When MAX(a.TransType)='24' and Max(a.DebCred)='D' then (MAX(a.) + SUM(isnull(b.reconsum,'0'))) When MAX(a.TransType)='24' and Max(a.DebCred)='C' then -MAX(a.Credit) When MAX(a.TransType)='13' and MAX(a.Debit)SUM(isnull(b.reconsum,'0')) then MAX(a.Debit) ,case when MAX(a.TransType)='13' and MAX(a.Debit)=SUM(isnull(b.reconsum,'0')) then MAX(a.) + SUM(isnull(b.reconsum,'0')) Select a.TransId,a.TransRowId,a.ShortName,a.b1,a.duedate,a.docnum, appears when executing this store procedure of ar invoice customer. ![]() Dear Experts, The error message belows: Msg 241, Level 16, State 1, Procedure INV_CUSTOMER, Line 17 Conversion failed when converting date and/or time from character string. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |