SELECT
name AS ID,
posting_date AS Date,
account AS Account,
voucher_type AS Voucher Type,
voucher_no AS Voucher No,
cost_center AS Cost Center,
debit AS Debit Amount,
credit AS Credit Amount,
against AS Against,
is_cancelled AS Cancelled
FROM tabGL Entry
WHERE
account IN (
‘E5014 - Demonstration Charges - KAEE’,
‘E7015 - Conference & Board Meeting (Non Sales) - KAEE’,
‘E8001 - Conference and seminar - KAEE’,
‘E8002 - Advertisement Charges - KAEE’,
‘E8003 - Creative charges - KAEE’,
‘E8004 - Promotional Material - KAEE’,
‘E8005 - Direct Mailer - KAEE’,
‘E8006 - Customer Relationship Management (CRM) - KAEE’,
‘E8008 - Subscription and Membership Fees - KAEE’,
‘E8009 - Tender Fees - KAEE’,
‘E8012 - Lodging & Boarding - KAEE’,
‘E8014 - Local Conveyance - KAEE’,
‘E8015 - Travel Fare - KAEE’,
‘E8016 - Internet & Mobile Charges - KAEE’,
‘E8018 - Sales Promotion Expenses - KAEE’
)
AND is_cancelled = ‘No’
AND posting_date between %(date1)s and %(date2)s;
