Excel Import Doubt

Discussion in 'Tally Developer' started by MithunN, Oct 11, 2018.

    
?

i have done Credit Note Excel Import .Voucher Number is Automatic in excel sheet there is no Voucher

  1. as soon as possible

    0 vote(s)
    0.0%
  2. if any body know help me

    1 vote(s)
    100.0%
  1. MithunN

    MithunN Member


    i have done Credit Note Excel Import .Voucher Number is Automatic in excel sheet there is no Voucher Number Column
    in narration i have to get voucher number.

    I have tried Like this

    01 : Set Value : Narration : $$Locale String:$Voucher Number
    but i am not getting in Narration if any body knows help with this.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In case Voucher Number is automatic... then Voucher number will not be assigned until and after the voucher is saved/written. So in this case you would not be able to fetch VchrNum in narration ....because during the RUN of the function, Voucher is not saved and hence no Number has been assigned.

    However you can write another function......
    One for import...........and after import is finished...run VCH narration function which will assign the Voucher number to the narration.
     
    Meena Mhatre likes this.


  3. MithunN

    MithunN Member


    Thank you so much sir
     


  4. Maulik Patel

    Maulik Patel Active Member


    Hi
    Please add below line to your code and try

    Code:
    001 : SET VALUE : Narration : $$TgtObject:$VoucherNumber
    Please note that this line must be written before SAVE TARGET / CREATE TARGET or ALTER TARGET line
     


  5. MithunN

    MithunN Member


    Thank You Sir
     


Share This Page