![]() ![]() DocNum, CardCode, CardName, DocTotal, vpm6. DocNum, CardCode, CardName, DocTotal ,0 as WGST ,0 as WH00 ,0 as WH01 ,0 as WH02 ,0 as WH03 ,0 as WH04 ,0 as WH05, sum ( VPM6. DocNum, CardCode, CardName, DocTotal ,0 as WGST ,0 as WH00 ,0 as WH01 ,0 as WH02 ,0 as WH03 ,0 as WH04, sum ( VPM6. WTSum ) as WH04 ,0 as WH05 ,0 as WH06 from OVPM DocNum, CardCode, CardName, DocTotal ,0 as WGST ,0 as WH00 ,0 as WH01 ,0 as WH02 ,0 as WH03, sum ( VPM6. ![]() WTSum ) as WH03 ,0 as WH04 ,0 as WH05 ,0 as WH06 from OVPM DocNum, CardCode, CardName, DocTotal ,0 as WGST ,0 as WH00 ,0 as WH01 ,0 as WH02, sum ( VPM6. WTSum ) as WH02 ,0 as WH03 ,0 as WH04 ,0 as WH05 ,0 as WH06 from OVPM TransType as TransType2, isnull (case when (select TransId from OJDT A where TransId in (select StornoToTr from OJDT) and A. DocNum, CardCode, CardName, DocTotal ,0 as WGST ,0 as WH00 ,0 as WH01, sum ( VPM6. WTSum ) as WH01 ,0 as WH02 ,0 as WH03 ,0 as WH04 ,0 as WH05 ,0 as WH06 from OVPM DocNum, CardCode, CardName, DocTotal ,0 as WGST ,0 as WH00, sum ( VPM6. WTSum ) as WH00 ,0 as WH01 ,0 as WH02 ,0 as WH03 ,0 as WH04 ,0 as WH05 ,0 as WH06 from OVPM DocNum, CardCode, CardName, DocTotal ,0 as WGST, sum ( VPM6. WTSum ) as WGST ,0 as WH00 ,0 as WH01 ,0 as WH02 ,0 as WH03 ,0 as WH04 ,0 as WH05 ,0 as WH06 from OVPM DocNum, CardCode, CardName, DocTotal, sum ( VPM6. Select DocNum, Cardcode, CardName, DocTotal, sum ( WGST ) as WGST, sum ( WH00 ) as WH00, sum ( WH01 ) as WH01, sum ( WH02 ) as WH02, sum ( WH03 ) as WH03, sum ( WH04 ) as WH04, sum ( WH05 ) as WH05, sum ( Wh06 ) as WH06 from BankCode, ” ) as BankCode, isnull ( PDF1. CheckNum, ” ) as CheckNumber, isnull ( PDF1. CardCode, ” ) as SupplierCode, isnull ( OPDF. This means the depreciation for January and February is done in March in general. The system proportionally posts a depreciation amount of 300 USD for the months from January to March. The depreciation run is executed for the first time in March. AcctCode, ” ) as accountCode, isnull ( VPM4. A planned depreciation of 1,200 USD for the current fiscal year has been calculated for an asset. WtAppld ),0 ) AS DocTotal, isnull ( sum ( VPM2. VendorName, ” ) as VendorName, isnull ( OCHO. CheckSum ,0 ) AS CheckAmount, isnull ( OCHO. TransId as JENo ,ĬASE when isnull ( CardName, ” ) = ” then CardCode else CardName end as Party ![]() Comments, ” ) as Comments, isnull ( RCT4. CanceledĬheque Register / Check Payment Register (Current Month Only)Īnd Month ( OCHo. Printed = ‘Y’ then ‘Printed’ else ‘Not Printed’ end isPrinted PrnConfrm = ‘Y’ then ‘Confirm’ else ‘Not Confirm’ end isConfirmed, CASE when OCHO. AcctName, ” ) as Control_Account_Name, CASE when OCHO. AcctCode, ” ) as Control_Account_Code, isnull ( VPM4. vatApplied ),0 ) AS WHT, isnull ( sum ( VPM2. WtAppld ),0 ) AS DocTotal, isnull ( sum ( VPM2. SELECT T0.'TransId', T0.'Account', T0.'TransType', SUM (COALESCE (CASE WHEN T0.'TransType' 15 THEN T0.'Credit' END,T0.'Credit')) As 'Credit', SUM (COALESCE (CASE WHEN T0.'TransType' 13 THEN T0.'Debit' END,T0.'Debit')) As 'Debit', SUM (COALESCE (CASE WHEN T0.'TransType' 13 THEN T0. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |