Mass 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 MoreCheck Data type using JavaScript
Use 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 MoreCheck duplicate data using Javascript
Use 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 MoreISO Receipt Register -GST Query
SELECT 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 MoreQuery to Fetch Invoice details, HSN Code, Third party Registration number and GST Details.
The 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 MoreReturn To Vendor Summay-GST
The 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 MoreTAX INVOICE RCM(REVERSE CHARGE MECHANISM) – GST
The 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 More