Discussion in 'General' started by abhishek chattaraj, Jul 14, 2017.
need help to fetch hsn code from its master table
What does that question even mean?
Actually I need the master table of hsn_code . After launching of gst I pick the hsn_code from a invoice view table jai_tax_det_fct_lines_v. Its perfect for now. But I need the master table through which I can update/modify the hsn_code for requirement. Though I am in a production/outsourcing company I need it sir.
I have NO IDEA of what you are saying. You need to make your post CLEAR as to what application it is you are running and what this hsn table actually is. Your current question is very much like "my elephant has no carburetor, can you sell me spinach?"
You really need to make your question clear to those who may not be intimately familiar with whatever it is you are using.
how to calculate opening balance?
SELECT pv.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE,
AND tb.EVENT_CLASS_CODE<>'PREPAYMENT APPLICATIONS'
AND trunc(tb.GL_DATE) <= TO_DATE(:P_TO_DATE,'YYYY/MM/DD HH24:MI:SS')