Tally experts please solved purchase import rouding off issue

Discussion in 'Free Source Codes' started by Vikram Hiwale, Aug 14, 2020.

    
  1. Vikram Hiwale

    Vikram Hiwale New Member


    Dear Sir \ Madam,

    I am created purchase import tdl but there is some error comes when import data from excel to tally.

    only issue found those entries whos values define minus figure in round off.

    for your refrence i am shared tdl file data file and excel file.

    kindly solved this isssue and give me reason why thos error come.
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You should make 2 INSERT OBJECTION for Ledger Round Off......

    1 ---- IF : $IsDeemedPositive:Ledger:##vLedgerName... then in Set Amount --- If $Amount < 0 then 0 else $Amount

    2 ---- IF : NOT $IsDeemedPositive:Ledger:##vLedgerName... then in Set Amount --- If $Amount < 0 then $Amount else 0

    Replace ##vLedgerName. with your variable name.
     
    Sanjeev S likes this.


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Or you can combine the above 2, if you well versed in Do If conditions.
     


  4. Vikram Hiwale

    Vikram Hiwale New Member


    thanx sir,

    I am write this code kindly check it same issue arise

    961 : IF : Not $$IsEmpty:$DarshImpRoundofVarLV
    961a: Log : $DarshImpRoundofVarLV
    962 : INSERT COLLECTION OBJECT : LEDGERENTRIES
    963 : SET VALUE : LEDGERNAME :"Round off"
    964 : SET VALUE : ISDEEMEDPOSITIVE : Yes
    969 : SET VALUE : AMOUNT :If $DarshImpRoundofVarLV < 0 then 0 else $DarshImpRoundofVarLV
    971 : Set Target : ..
    972 : End If


    972a : If : @HTE_RoundOff = No
    972b : IF : Not $$IsEmpty:$DarshImpRoundofVarLV
    972c : Log : $$Number:($$String:$DarshImpRoundofVarLV)
    972d : INSERT COLLECTION OBJECT : LEDGER ENTRIES
    972e : SET VALUE : LedgerName : "Round Off"
    972f : SET VALUE : IsDeemedPositive : Yes
    972g : SET VALUE : Amount : If $DarshImpRoundofVarLV < 0 then $DarshImpRoundofVarLV else 0
    972h : SET TARGET : ..
    972i : END IF
    972js : END IF
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    One should be YES in deemedpositive and other should be NO......

    Data is with you, code is with you.....you can try at your side and let us know.............do some R&D.
     


  6. Vikram Hiwale

    Vikram Hiwale New Member


    THANK YOU SIR ISSUE GOT RESOLVED:):):):)
     


  7. Vikram Hiwale

    Vikram Hiwale New Member


    THANX SIR
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Good effforts....good knowledge... keep it up
     


  9. Sadakkatha

    Sadakkatha New Member


    Or Using this method for Purchase Rounding Issue
    961 : IF : Not $$IsEmpty:$DarshImpRoundofVarLV
    961a: Log : $DarshImpRoundofVarLV
    962 : INSERT COLLECTION OBJECT : LEDGERENTRIES
    963 : SET VALUE : LEDGERNAME :"Round off"
    964 : SET VALUE : ISDEEMEDPOSITIVE : Yes
    969 : SET VALUE : AMOUNT : If $$IsNegative:$DarshImpRoundofVarLV Then $$AsDrAmt:$$AsAmount:$DarshImpRoundofVarLV *-1 Else $DarshImpRoundofVarLV *-1
    971 : Set Target : ..
    972 : End If
     


  10. Vikram Hiwale

    Vikram Hiwale New Member


    H


    THANX SIR.......
     


  11. Rakesh Kumar

    Rakesh Kumar Member


    Dear Vikram, kindly share the full amended code along with Excel sheet.
    I have tried a lot, but not imported. kindly help me to do the same.
     


Share This Page