Introduction: 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…
Read MoreIntroduction This Post is Described about the Delivery Challan with GST Details in ebs r12 Query retrieves data of those inventory items which are used for promotional purposes or…
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 MoreIntroduction 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…
Read MoreIntroduction This Post Is Described about the RMA Receipt Query-GST In oracle apps R12. select orgid,ORGCODE, ORGNAME, account_number, party_name,city, LINE_NUMBER, trx_number,trx_date, location, src_number,src_date,rma_gross,TAX_RATE_PERCENTAGE, interface_header_attribute2,reason_code,CGST,SGST,IGST,VAT,CST,(nvl(rma_gross,0) + nvl(CGST,0) + nvl(SGST,0) +…
Read MoreIntroduction This Post is Explain About to Check Data type using JavaScrip. Use the below script to perform duplicate data validation along with numeric data type validation in Javascript.…
Read MoreDescription Step how to Define a PROJECT in FUSION Applications. Define the Implementation Project. Please find the below steps to define a project Step1: Login as Application User. Step2: you will be…
Read MoreStep1: Click on Next button to assign Offerings and Options. Which we have planned to implement. we will navigate to Select offerings to implement window as below Step2: we are assuming…
Read MoreDescription Step how to Define a CALENDAR in FUSION Applications. 1 Define a CALENDAR Please find the below steps to define a CALENDAR Step1: Login as Application User Step2: you will be in home page as…
Read MoreDescription Step how to Add a Year to the CALENDAR in Fusion Applications. When a financial year ends and starts a new financial year, we have to define calendar in advance Please follow the below…
Read More