WTSum ) 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 ,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. DocNum, CardCode, CardName, DocTotal, 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. AcctCode, ” ) as accountCode, isnull ( VPM4. 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.

Transtype layered