Dear Sir My code is : SELECT $NAME , $PARENT , $ADDRESS , $LEDGERMOBILE , $INCOMETAXNUMBER , $PARTYGSTIN , $EMAIL , $PINCODE , $LEDSTATENAME FROM LEDGER This code is working but problem is with address . As its extracting only first line of address but I want the complete address. Please provide me code for detail address. Please help me out.
[#Object : Ledger] FullAddress : $$FullList:Address:$Address Then restart Tally Then use SELECT $NAME , $PARENT , $FullADDRESS , $LEDGERMOBILE , $INCOMETAXNUMBER , $PARTYGSTIN , $EMAIL , $PINCODE , $LEDSTATENAME FROM LEDGER it has to work
SELECT $NAME , $PARENT , $_Address1,$_Address2,$_Address3,$_Address4,$_Address5 , $LEDGERMOBILE , $INCOMETAXNUMBER , $PARTYGSTIN , $EMAIL , $PINCODE , $LEDSTATENAME FROM LEDGER