Created attachment 1916 [details] FILE ATTACHED SELECT COMPANY_CODE ,TYPE_SERIES_NO ,INVOICE_DATE ,SUM(MRP_VALUE) MRP_VALUE ,SUM(ASS_VALUE) ASS_VALUE ,SUM(NCCD_AMOUNT) NCCD_AMOUNT ,SUM(BED_AMOUNT) BED_AMOUNT ,SUM(TAXABLE_AMOUNT) TAXABLE_AMOUNT ,SUM(TOTAL_VALUE) TOTAL_VALUE ,SUM(IN_UNITS) IN_UNITS ,SUM(IGST_AMOUNT) IGST_AMOUNT ,SUM(CGST_AMOUNT) CGST_AMOUNT ,SUM(SGST_AMOUNT) SGST_AMOUNT ,SUM(CESS_AMOUNT) CESS_AMOUNT ,SUM(CESS_ON_QTY) CESS_ON_QTY ,SUM(TOTAL_CASES) TOTAL_CASES ,REMARKS ,VEHICLE_NO ,XFR_COMPANY ,CUSTOMER_NAME ,SUM(NET_WEIGHT) FROM( SELECT COMPANY_CODE ,INVOICE_TYPE ,INVOICE_SERIES ,INVOICE_NUMBER ,PKG_VOUCHERS.GET_VOUCHER_STRING(COMPANY_CODE, INVOICE_TYPE, INVOICE_SERIES, INVOICE_NUMBER) TYPE_SERIES_NO ,INVOICE_DATE ,PKG_IC.GET_GROUP_DESCRIPTION (ITEM_CLASS, ITEM_GROUP) GROUP_NAME ,ITEM_CLASS ,ITEM_GROUP ,ITEM_CODE ,STOCK_TYPE ,MAX_RETAIL_PRICE * SUM(NVL(QUANTITY,0)) MRP_VALUE ,SUM(NVL(ASS_VALUE,0)) ASS_VALUE ,SUM(NVL(NCCD_AMOUNT,0)) NCCD_AMOUNT ,SUM(NVL(BED_AMOUNT,0)) BED_AMOUNT ,SUM(NVL(TAXABLE_AMT,0)) TAXABLE_AMOUNT ,SUM(NVL(TOTAL_VALUE,0)) TOTAL_VALUE ,SUM(NVL(QUANTITY,0)) IN_UNITS ,SUM(NVL(IGST_AMOUNT,0)) IGST_AMOUNT ,SUM(NVL(CGST_AMOUNT,0)) CGST_AMOUNT ,SUM(NVL(SGST_AMOUNT,0)) SGST_AMOUNT ,SUM(NVL(CESS_AMOUNT,0)) CESS_AMOUNT ,SUM(NVL(CESS_ON_QTY,0)) CESS_ON_QTY ,TOTAL_CASES ,REMARKS ,VEHICLE_NO ,XFR_COMPANY ,CUSTOMER_NAME ,SUM(NET_WEIGHT) NET_WEIGHT FROM VW_MFG_UNIT_DISPATCHES WHERE INVOICE_DATE BETWEEN '01/02/2021' AND '31/03/2021' --AND COMPANY_CODE =:CO AND ITEM_CLASS = '4' --AND NVL(BED_AMOUNT,0) != 0 AND INVOICE_TYPE = 'LI' --AND ITEM_GROUP LIKE NVL('4', '%') GROUP BY COMPANY_CODE,INVOICE_TYPE, INVOICE_SERIES, INVOICE_NUMBER, INVOICE_DATE,ITEM_CLASS,ITEM_GROUP,ITEM_CODE,STOCK_TYPE,MAX_RETAIL_PRICE,TOTAL_CASES,VEHICLE_NO, XFR_COMPANY,CUSTOMER_NAME,REMARKS) GROUP BY COMPANY_CODE,INVOICE_DATE,TYPE_SERIES_NO,TOTAL_CASES,VEHICLE_NO, XFR_COMPANY,CUSTOMER_NAME,REMARKS ORDER BY COMPANY_CODE,INVOICE_DATE
check and confirm
Created attachment 1915 [details] excise data file attached
SELECT COMPANY_CODE ,TYPE_SERIES_NO ,INVOICE_DATE ,SUM(MRP_VALUE) MRP_VALUE ,SUM(ASS_VALUE) ASS_VALUE ,SUM(NCCD_AMOUNT) NCCD_AMOUNT ,SUM(BED_AMOUNT) BED_AMOUNT ,SUM(TAXABLE_AMOUNT) TAXABLE_AMOUNT ,SUM(TOTAL_VALUE) TOTAL_VALUE ,SUM(IN_UNITS) IN_UNITS ,SUM(IGST_AMOUNT) IGST_AMOUNT ,SUM(CGST_AMOUNT) CGST_AMOUNT ,SUM(SGST_AMOUNT) SGST_AMOUNT ,SUM(CESS_AMOUNT) CESS_AMOUNT ,SUM(CESS_ON_QTY) CESS_ON_QTY ,SUM(TOTAL_CASES) TOTAL_CASES ,REMARKS ,VEHICLE_NO ,XFR_COMPANY ,CUSTOMER_NAME ,SUM(NET_WEIGHT) FROM( SELECT COMPANY_CODE ,INVOICE_TYPE ,INVOICE_SERIES ,INVOICE_NUMBER ,PKG_VOUCHERS.GET_VOUCHER_STRING(COMPANY_CODE, INVOICE_TYPE, INVOICE_SERIES, INVOICE_NUMBER) TYPE_SERIES_NO ,INVOICE_DATE ,PKG_IC.GET_GROUP_DESCRIPTION (ITEM_CLASS, ITEM_GROUP) GROUP_NAME ,ITEM_CLASS ,ITEM_GROUP ,ITEM_CODE ,STOCK_TYPE ,MAX_RETAIL_PRICE * SUM(NVL(QUANTITY,0)) MRP_VALUE ,SUM(NVL(ASS_VALUE,0)) ASS_VALUE ,SUM(NVL(NCCD_AMOUNT,0)) NCCD_AMOUNT ,SUM(NVL(BED_AMOUNT,0)) BED_AMOUNT ,SUM(NVL(TAXABLE_AMT,0)) TAXABLE_AMOUNT ,SUM(NVL(TOTAL_VALUE,0)) TOTAL_VALUE ,SUM(NVL(QUANTITY,0)) IN_UNITS ,SUM(NVL(IGST_AMOUNT,0)) IGST_AMOUNT ,SUM(NVL(CGST_AMOUNT,0)) CGST_AMOUNT ,SUM(NVL(SGST_AMOUNT,0)) SGST_AMOUNT ,SUM(NVL(CESS_AMOUNT,0)) CESS_AMOUNT ,SUM(NVL(CESS_ON_QTY,0)) CESS_ON_QTY ,TOTAL_CASES ,REMARKS ,VEHICLE_NO ,XFR_COMPANY ,CUSTOMER_NAME ,SUM(NET_WEIGHT) NET_WEIGHT FROM VW_MFG_UNIT_DISPATCHES WHERE INVOICE_DATE BETWEEN '01/02/2021' AND '31/03/2021' --AND COMPANY_CODE =:CO AND ITEM_CLASS = '4' --AND NVL(BED_AMOUNT,0) != 0 AND INVOICE_TYPE = 'LI' --AND ITEM_GROUP LIKE NVL('4', '%') GROUP BY COMPANY_CODE,INVOICE_TYPE, INVOICE_SERIES, INVOICE_NUMBER, INVOICE_DATE,ITEM_CLASS,ITEM_GROUP,ITEM_CODE,STOCK_TYPE,MAX_RETAIL_PRICE,TOTAL_CASES,VEHICLE_NO, XFR_COMPANY,CUSTOMER_NAME,REMARKS) GROUP BY COMPANY_CODE,INVOICE_DATE,TYPE_SERIES_NO,MRP_VALUE,TOTAL_CASES,VEHICLE_NO, XFR_COMPANY,CUSTOMER_NAME,REMARKS ORDER BY COMPANY_CODE,INVOICE_DATE
Created attachment 1914 [details] EXCISE DETAILS PLZ. Provide the Excise invoice wise details(B-59, 1D, 1C AND 6A) for the period feb-2021 and March-2021, in attach format previously provide by you.