Doyen System Pvt. Ltd.
Monday, 19 June 2017
GL Transactions for Payments
›
SELECT DISTINCT aca.payment_method_lookup_code trans_type, TO_CHAR (aca.check_number) invoice_num, TO_CHA...
GL Transactions for AR
›
SELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num, TO_CHAR (rct.trx_date) invoice_date, TO_CHAR (rcl...
GL Transactions for AR Adjustments
›
SELECT NULL trans_type, ent.transaction_number invoice_num, (SELECT TO_CHAR (trx_date) FROM ra_customer_trx_all ...
GL Transactions for AP
›
SELECT /*+ leading (ael aeh) */ aia.invoice_type_lookup_code trans_type, ent.transaction_number invoice_num, TO_CHA...
Thursday, 30 March 2017
Extract for Payments - Check and EFT
›
SELECT papf.employee_number employee_number , aps.vendor_name payee_name , ieba.bank_account_num bank_a...
4 comments:
Monday, 20 March 2017
Steps to Create Excel for Apps Report
›
GL Wand needs no desktop installation and it is very user friendly for creating many financial reports. It is a very good reporting too...
Thursday, 16 March 2017
ERROR ORA -00980 Synonym Translation no longer valid
›
Error Message : ORA -00980 Synonym Translation no longer Valid. Error Area : it is related Database (Table/view) not related to forms ...
1 comment:
‹
›
Home
View web version
