excel to tally

Discussion in 'Tally Integration' started by Sha Siddiqe, Apr 17, 2014.

    
  1. Sha Siddiqe

    Sha Siddiqe New Member


    I have done customization for excel to tally sales vouchers with vat details. Import has been successfully. But I go through to statuory vat details i got only vat Assesable value , Vat amount
    not showing. suppose I alter Specify voucher i got vat amount . How I fix issue . Kindly advice me.
    Thanks in advance

    SS
     


  2. D Lokesh

    D Lokesh Member




    Can try this....

    232 : Insert Collection Object: Ledger Entries
    232a:SET TARGET: LedgerEntries
    233:SET VALUE: TAXCLASSIFICATIONNAME: "Output VAT @ 5%"
    234:SET VALUE: LedgerName: "VATAMT"
    235: SET VALUE: Amount: ($$TgtObject:($$AsAmount:##MDVATAMT)) ;;----------- VAT Amount
    236:SET VALUE: VATASSESSABLEVALUE: -1 * ($$TgtObject:($$AsAmount:##MDAMOUNT)) ;;----------- Sales Amount
    237:SET VALUE: PREVAMOUNT: ($$TgtObject:($$AsAmount:##MDVATAMT))
    238:SET VALUE: PREVINVTOTALAMT: ($$TgtObject:($$AsAmount:##MDAMOUNT))
    239:SET VALUE: ISDEEMEDPOSITIVE: "No"
    239a: SET TARGET: ..
     


Share This Page