Attributes for Finished Goods Item
Field Name Level Values User Item Type Master FINISHED GOOD Item Status Org Active Inventory Item Master Yes Stockable Org Yes Transactable Org Yes Reservable Org Reservable Cycle Count Enabled…
Read MoreWhen the Transactable Item Flag can be enabled
The Transactable Flag for an Item can be enabled only if the Item has Stockable Flag Enabled.
Read MoreReturnable Flag for an Item
The Returnable Flag should be Enabled, If the Item is returnable after successfully completion of order.
Read MoreAnalysis of Customer wise Items count of sales orders based on period
This query is to analyse the type of items that a customer is buying in specific period through out his orders. In the below example we have taken only the…
Read MoreUsing pivot option in sql and naming aliases
This is a simple SQL Query used to show how the pivot option is used. Here in this example the columns JAN, FEB and MAR would be having single quotes…
Read MoreAP Invoice Attachments Extraction
select distinct aia.invoice_id, aia.Voucher_Number, d.file_name, d.url from fnd_attached_documents fad, ap_invoices_all aia, fnd_documents d where 1=1 and aia.invoice_id = fad.pk1_value and fad.entity_name = ‘AP_INVOICES’ and fad.document_id = d.document_id;
Read MoreNetting Agreements Details Table
This is the table where all the netting agreement would be storing. Script: select agreement_name, agreement_id from apps.fun_net_agreements_all;
Read MoreAPI to Check the AP invoice Accounting status
This API is used to check the Accounting status of AP invoices. Script: DECODE(apps.AP_INVOICES_PKG.GET_POSTING_STATUS( aia.invoice_id ), ‘P’, ‘Partial’, ‘N’, ‘Unaccounted’, ‘Y’, ‘Accounted’);
Read MoreQuery to Extract GST TAX Type Details Extraction
This Query is used to extract all the TAX Type that are available in the system, Especially used when Migrating the data and reporting purpose. Script: SELECT ‘GST’ “Tax…
Read MoreScript to Find Lower Threshold Tax slab Vendors Registered Details
This Query is useful to fetch the vendor details that are having certificates for lower Tax Deduction rates or Exceptional Tax Deduction case vendors. Script: SELECT vendor_name, pan_no, org_tan_num,…
Read More