How to Import Mfg & Exp Date in Goods Receipt Note?

Discussion in 'Tally Developer' started by gangstar, Sep 14, 2022.

    
  1. gangstar

    gangstar Member


    042: Insert Collection Object:BATCHALLOCATIONS
    073: Set Value:TrackingNumber:"1";$BillNo
    043: Set Value:Godown Name:$_6
    070: Set Value:BatchName:$_8
    071: Set Value:DestinationGodown Name:$_6
    044: Set Value:Actual Qty:($$TGTObject:$$ASQty:##SVQtyVar)
    045: Set Value:Billed Qty:($$TGTObject:$$ASQty:##SVQtyVar)
    046: Set Value:Rate:$$TGTObject:$$ASRAte:##SVRateVar
    047: Set Value:Discount:$$TGTObject:$$ASRAte:##SVDisVar
    048: Set Value:Amount: - ($$TGTObject:$$ASAmount:##SVAmtVar)
    069: Set Value:Mfdon:##VarVchDate

    Variable:SVExpVar:Date
    501: Set:SVExpVar:$$Date:$_10

    072: Set Value:ExpiryPeriod:$$DateRange:##VarVchDate:##VarVchDate:True
    ;$$DateRange:"365":($$TgtObject:$Date):True
    ;$$DateRange:"365":"01-10-2022":True
    ;$$DateRange:"02-10-2019":"02-06-2009":True
    ;$$DateRange:Exp:
     



  2. what is the context. I mean when u r calling the above function? As far as syntax is concern its seems to be okay.
     


  3. gangstar

    gangstar Member


    It's not picking the Excel Date Column
     


  4. gangstar

    gangstar Member


    069: Set Value:Mfdon:##SVMfgVar

    Variable:SVExpVar:Date
    Variable:SVMfgVar:Date

    502: Set:SVMfgVar:$$Date:(($$StringPart:$_9:8:2) + "-" + ($$StringPart:$_9:5:2)+ "-" + ($$StringPart:$_9:0:4))
    501: Set:SVExpVar:$$Date:(($$StringPart:$_10:8:2) + "-" + ($$StringPart:$_10:5:2)+ "-" + ($$StringPart:$_10:0:4))


    072: Set Value:ExpiryPeriod:$$DateRange:##SVExpVar:##SVMfgVar:True

    First Item Manufacture date Picking the Voucher Date and other items picking correctly from excel
     


Share This Page