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 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 MoreThe below query fetches the details of a tax invocie where in Reverse charge mechanism(RCM) is applied in order to claim the extra tax paid by an organization along with…
Read MoreQuery retrieves data of those inventory items which are used for promotional purposes or given as a sample items for a sales executive in order to promote the products along…
Read More