Excise Invoice No and Date Mandatory in Receipt Localized Form
I want to make Excise invoice No and Date field mandatory in Receipt Localized form when excise taxes will be there. But It is not working.
I have applied below: Please correct me
Trigger Event: WHEN-NEW-BLOCK-INSTANCE
Trigger Object: JAI_RCV_HEADERS
Condition: EXISTS (
SELECT 1
FROM jai_rcv_line_taxes jrlt,JAI_RCV_HEADERS jch
WHERE jrlt.shipment_header_id = jch.shipment_header_id
and jch.shipment_header_id = :JAI_RCV_HEADERS.shipment_header_id
and jrlt.vendor_id = jch.vendor_id
and jch.vendor_id = :JAI_RCV_HEADERS.vendor_id
AND UPPER (tax_type) IN
('EXCISE', 'ADDITIONAL_CVD', 'CVD',