API to Create Bank Account Details
Below procedure will create Supplir Bank account details PROCEDURE create_banks_accounts(p_change_type VARCHAR2) AS ln_count NUMBER; ln_success_count NUMBER; ln_error_count NUMBER; ln_x_bank_id …
Read MoreTDS Register Report
Below query will display all TDS related details for GST implementations SELECT aia.invoice_date, aia.doc_sequence_value voucher_num, aia.invoice_num, aia.invoice_amount, aps.vendor_name party_name, (SELECT t.description FROM apps.ap_invoice_distributions_all apd,…
Read MoreRO Partywise Account Ledger Report
Below Query will fetch Vendor Wise RO Account Ledger details SELECT * FROM (SELECT asp.vendor_id, aia.gl_date accounting_date, …
Read MoreGL DRILL Down Query From GL into Cost Management Sub ledger Module.
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(receiving,inventory, WIP sources) sub-ledger modules. –SK Receiving Source: SELECT …
Read MoreGL DRILL Down Query From GL into Fixed Assets Sub ledger Module.
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(all sources) sub-ledger modules. SELECT GCC.concatenated_segments segments, …
Read MoreDrill Down Query From GL into Project Accounting subledger
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Project Accounting sub-ledger modules. SELECT GLCC.concatenated_segments segments …
Read MoreMass Update For Supplier Invoice Match
Update the match_option column in AP_SUPPLIERS table. No Oracle API is available to change the Invoice Match Option from one value to another. This has to be manually done from…
Read MoreLockbox – Error Handling
Submit postQuickcash for records struck in the interface. Query with Transmission Name & check Submit postQuickcash then submit. Receivables -> Lockbox Interface For any other issues that needs reprocessing, delete…
Read MoreQuery to find Suppliers/ Sites with 'Receipt' match option.
SELECT aps.vendor_id, aps.vendor_name, DECODE(aps.match_option,’P’,’Purchase Order’,’R’,’Receipt’) match_option_suppiers, apssa.vendor_site_id, DECODE(apssa.match_option,’P’,’Purchase Order’,’R’,’Receipt’) match_option_suppier_sites FROM apps.ap_suppliers aps, apps.ap_supplier_sites_all apssa WHERE aps.vendor_id = apssa.vendor_id AND …
Read MoreHighlight Data in different colors Using CSS
Use the below code in report query to highlight data with different colors based on conditions CASE WHEN (TRUNC(SYSDATE) > date_down AND date_down IS NOT NULL) AND date_out IS…
Read More