Dear Experts, By using this function, i am able to create ledger but not able to import address in multiple lines. It is coming in a single line. Please guide me in the same query. [Function: Create New Ledger] Variable : Counter1 : Number Variable : IsObjectExists : Logical Variable:TempLed:String 001 : NEW OBJECT : Ledger 002 : SET VALUE : Name : ##Lednm 003 : Set Value arent :$Ledgrp1 004 :Set Value:LedStateName:$state1 005 :Set Value:COUNTRYNAME:"India" 006 :Insert Collection Object:Address 007 :Set Value:Address:$Add1 + ","+$Add2+","+$Add3 ; 008 :Set Value:Address:$Add2;New ; 008A:Set Value:Address:$Add3;New 009 :Set Target:.. 010 :Set Value:Ledgerphone:$phone1 011 :Set ValueARTYGSTIN:$GSTNO1 012 :Set Value:GSTRegistrationType:IF $$IsEmpty:$GSTNO1 then "Consumer" else "Regular" 013 : CREATE TARGET 014 : INCREMENT : Counter1 015:Return
Repeat below as many line as you want: 006 :Insert Collection Object:Address 007 :Set Value:Address:$Add1 + ","+$Add2+","+$Add3 ; 008 :Set Value:Address:$Add2;New ; 008A:Set Value:Address:$Add3;New 009 :Set Target:..
sir, bellow code is for excel to tally ledger import 059 : Set Value : Address : If $$IsEmpty:$$FileReadCell:##RCnt:9 Then "" Else $$FileReadCell:##RCnt:9 above code import only ledger address one line how to import second and third line.............. please tell me,
Try this.. may be it will help you Code: A01: Insert Collection Object : Address A02: Set Value : Address: if $$:IsEmpty:$$FileReadCell:##RCnt:8 Then "" else $$FileReadCell:##RCnt:8 A03: Set Target : .. A04: Insert Collection Object : Address A05: Set Value : Address: if $$:IsEmpty:$$FileReadCell:##RCnt:9 Then "" else $$FileReadCell:##RCnt:9 A06: Set Target : .. A07: Insert Collection Object : Address A08: Set Value : Address: if $$:IsEmpty:$$FileReadCell:##RCnt:10 Then "" else $$FileReadCell:##RCnt:10 A09: Set Target : .. A10: Insert Collection Object : Address A11: Set Value : Address: if $$:IsEmpty:$$FileReadCell:##RCnt:11 Then "" else $$FileReadCell:##RCnt:11 A12: Set Target : ..
Thank You for your reply sir.but it does not works.. Can you please share your mail id . i will send complete code for address column help................