| Summary: | PROVIDE THE DETAIL IN ATTACH FORMAT | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS SALES | Reporter: | Sanjay Gupta <sanjay.gupta> |
| Component: | IMIS SALES FORMS AND REPORTS | Assignee: | Mahender <mahender.singh> |
| Status: | RESOLVED USER TO VERIFY | ||
| Severity: | enhancement | CC: | sharad.sharma |
| Priority: | --- | ||
| Version: | unspecified | ||
| Hardware: | PC | ||
| OS: | Windows | ||
| Database: | Module ID: | ||
| Attachments: |
EXCISE DETAILS
excise data FILE ATTACHED |
||
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.
|
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