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.
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.
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
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.
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
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.