Exporting in Excel

Discussion in 'Tally Developer' started by rony, Aug 16, 2017.

    
Tags:
  1. rony

    rony Member


    Dear Experts,
    I have some query pl help me 2 solve
    1) I have added HSN code in stock item after part no. and i want to fetch same in invoice, I tried 2 codes a) $HSNCODE:StockItem:$StockItemName, b) $HSNCODE:$StockItem:$StockItemName but both gives error. If U can help in what code can be use to bring HSN code for every item from stock creation menu.
    2 ) While exporting in excel default columns r coming . Is there any code to export with our desire columns setting. EX. default first column r date then inv no. etc if we want first column Gst no. then amount or else.
    Thanks in advance.
     



  2. You can use something like below.

    $(StockItem, $StockItemName).GSTDetails[Last].HSNCode
     


  3. rony

    rony Member


    thank u very much 2 response else i was thinking no on e is there!!!. But i m using erp 1.1 in that gst detail sub menu is not available . if u can suggest any thing else i highly appreciate.
    any way thanks.
     


  4. manohar

    manohar New Member



Share This Page