Introduction: This report will display the HSN summary details. SELECT ‘HSN Summary’ inv_type ,hsn_data.supp_gstin s_gstin ,hsn_data.period inv_period ,hsn_data.item_nm item_name ,hsn_data.hsn_sac hsn_sac_code ,hsn_data.uom_code trx_uom_code ,SUM(hsn_data.trx_line_qty) trx_line_quantity ,SUM(hsn_data.taxable_amt) taxable_amount ,hsn_data.SGST_RT SGST_RATE ,SUM(hsn_data.SGST_AMT)…
Read More<?xml version=”1.0″ encoding=”utf-8″?> <!– +======================================================================+ –> <!– | Copyright (c) 2005, 2014 Oracle and/or its affiliates. | –> <!– | All rights reserved. | –> <!– | Version 12.0.0 |…
Read MoreTo Create Business Purpose as Statements for Customer Site / SET SERVEROUTPUT ON; DECLARE p_cust_site_use_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE; p_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE; x_site_use_id NUMBER; x_return_status VARCHAR2(2000); x_msg_count NUMBER; x_msg_data VARCHAR2(2000); ln_cust_acct_id NUMBER; lv_location VARCHAR2(240);…
Read MoreBelow query is useful when you required Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receipt Write off) SELECT ACRA.RECEIPT_DATE ,( select…
Read MoreCompanies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functionality to electronically transfer collection documents to banks using files…
Read MoreCompanies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functionality to electronically transfer collection documents to banks using files…
Read More