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 MoreUpdate 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 MoreSubmit 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 MoreSELECT 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 MoreUse 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 MoreUse the below script to perform duplicate data validation along with numeric data type validation in Javascript. <!–duplicate checking for lpn –> <script> function check_lpn(pThis) { var j_item_id=pThis.id; var k_item_id=’#f02’+j_item_id.substr(3);…
Read MoreUse the below Javascript to identify duplicate data – In this sample code, when user enters order number in the tabular form, an error will be thrown if the order…
Read MoreSELECT shipment_num, shipped_date, stnno, receipt_num, rcvd_date, send_orgid, send_orgname, recv_orgid, recv_org_name, gst_no, segment1, description, lot_num, pri_rec_uom, uomcode, LINK, rcv_qty, iso_price, iso_price_uom, NVL (tax_amount, 0) tax_amount, ((rcv_qty *…
Read MoreThe below query fetches the details of an Invoice along with the HSN Code of a respective item present in an Invoice. GST details can also be fetched. SELECT a.org_id,a.customer_trx_id,a.trx_number…
Read MoreThe below query fetches the data of purchase order wherein those items present in purchase order needs to be returned to Supplier because of some damage caused to goods etc..…
Read More