Tenant profile

all respected
my father have property business rental property
i want to create tenant profiles for each tenant
can any body help me

please

 

Post all the details required, so that, members will try to help.

 

thank you for your reply
i will make a pdf formate file
so u can understand easily

simply i need to cerate a tenant detail like a profile

thanks

 

kindly plz see the sample file plzzzzzzzzzz

 

nobody guide us please

 

Dear Members, which is the best option for this case;
1. Create UDFs in party Ledger Master
2. Create a DataBase (Excel/Access) and store the values in the database, then retrieve the same with PartyName Ledger
3. Not having Much Knowledge about LIST VARIABLE, Using LIST Variable is efficient ?

 

thanks for reply
i am biggner
kindly help me please

 

Sample Data & Rent Tdl File attached.

 

gangetser respected thanks for honorable reply
dear respected sir can i send u a udf fiedls i need to get deta from tally master ledger creation on this form no need to go to sales voucher
just create a button on gateway of tally and all the data get from tally master udf fields plzzzzzzzz thanks

 

means to say we create UDF fields in tally master and fetch all data from these fields a button shows on gateway of tally we press this button and a filter list open for tenant i just press tenant 1 then this form which u create should be open plzzzzzzzzzzz

 

Can i get your mail id Mr.gangastar plzzzzz

 

i have creatred all these fields udf in ledger creation so neet to get all data from that fields on this form through udf plzzzzz

 

kindly see these UDF fields

 

$UDFName :Ledger:$PartyLedgerName

 

here are i have a great person gangster who is very helping person
thanks sir

 

Ms. Naina, do u know TDL

 

This is Sample Format go through this tdl

;[Include:E:\Program Files\Tally.ERP9 6.0.3\Dropbox\BALAJI TDL\TDL CONFIG LATEST.txt]

[#Menu:Gateway of Tally]
Add:Button:Rent Aggr
;Add:Key Item:Rent Agreement:Risplay Collection:SJGroupColl:NOT $$IsEmpty:$$SelectedCmps

[Button:Rent Aggr]
Title:"Rent Aggrement"
Key:ALT + V
Actionisplay Collection:SJGroupColl

[Collection:SJGroupColl]
Use:Remote My Ledger Coll
Delete:Report
Add:Report:SJGroup

[Collection:Remote My Ledger Coll]
Use:Alias Collection
Type:Ledger
Variable:LedgerName
Trigger:Remote Triggered Led Report
Report:Remote Final Led Report
Fetch:Name
Filter:SundryDebrs

[Report:Remote Triggered Led Report]
Title:"Select Ledger"
Form:Remote Triggered Led Report
Variable:SVFromDate, SVToDate
VariableSPShowOpening, DSPShowClosing

[Form:Remote Triggered Led Report]
Parts:Remote Triggered Led Report

[Part:Remote Triggered Led Report]
Lines:Remote Triggered Led Report

[Line:Remote Triggered Led Report]
Fields:Medium Prompt, Remote Triggered Led Report
Local:Field:Medium Prompt:Set as:"Ledger :"

[Field:Remote Triggered Led Report]
Use:Name Field
Table:Remote My Ledger Coll
Show Table:Always
Modifies:LedgerName
;Inactive:NOT $$IsBelongsTo:$$GroupSundryDebtors

[System:Formulae]
SundryDebrs:$$IsBelongsTo:$$GroupSundryDebtors

[Report:SJGroup]
Form:SJGroup
Object:VOUCHER:##VOUCHERID
Title:"SJ Group of Company"
Print Set:REPORT TITLE:"SJ Group of Co.,"
Fetch Object:Ledger:#LedgerName:Name, LedgerContact, LedgerPhone, OpeningBalance, LedOpeningBalance, TBalOpening

[Form:SJGroup]
Top Part:SJGroupTop
Space Top:0.35 INCH
Space Left:0.55 INCH
Space Right:0.45 INCH
Space Bottom:0.10 INCH

[Part:SJGroupTop]
Part:SJGroupTopCmp,SJGroupTopCmpTit;,SJGroupTopAggTit,SJGroupTopCaFTit,SJGroupTopSignTit
Vertical:Yes

[Part:SJGroupTopCmp]
Line:SJGroupTopCmp,SJGroupTopCAdd,SJGroupTopCEMN

[Line:SJGroupTopCmp]
Field:Name Field
Local:Field:Name Field:Set as@CmpMailName
Local:Field:Name Field:Full Width:Yes
Local:Field:Name Field:Align:Center
Local:Field:Name Field:Style:Large Bold
Local:Field:Name Field:Border:Thin Bottom
Local:Field:Name Fieldrint FG:Blue

[Line:SJGroupTopCAdd]
Field:Name Field
Local:Field:Name Field:Set as:$$FullList:SJCompanyaddress:$Address
Local:Field:Name Field:Full Width:Yes
Local:Field:Name Field:Align:Center

[Collection:SJCompanyaddress]
Type:Address:Company
Child Of:##SVCurrentCompany
Filter:IsNotBlankAddr

[Line:SJGroupTopCEMN]
Space Top:0.25
Field:Name Field,Short Name Field
Local:Field:Name Field:Set as:"Email:- " + $Email:Company:##SVCurrentCompany
Local:Field:Name Field:Full Width:Yes
Local:Field:Name Field:Align:Left

Local:Field:Short Name Field:Set as:"Contact:- " + $MobileNumbers:Company:##SVCurrentCompany
Local:Field:Short Name Field:Full Width:Yes
Local:Field:Short Name Field:Align:Right

[Part:SJGroupTopCmpTit]
Line:SJGroupTopCmpTit,SJGroupTopCmpTFDet

[Line:SJGroupTopCmpTit]
Field:Name Field
Border:Thin Box
Local:Field:Name Field:Set as:"TENANT PROFILE"
Local:Field:Name Field:Full Width:Yes
Local:Field:Name Field:Align:Center
Local:Field:Name Fieldrint BG:Green

[Line:SJGroupTopCmpTFDet]
Left Fields:Name Field, SJGroupStart
Right Fields:Short Name Field, SJGroupShNo
Border:Thin Box
Local:Field:Name Field:Set as:"Rent Start"
Local:Field:Name Field:Full Width:Yes
Local:Field:Name Field:Align:Left
Local:Field:Name Field:Border:Thin Box

Local:Field:Short Name Field:Set as:"Shop No"
Local:Field:Short Name Field:Full Width:Yes
Local:Field:Short Name Field:Align:Left
Local:Field:Short Name Field:Border:Thin Box

[Field:SJGroupStart]
Use:Name Field
Set as:$LedgerMobile:Ledger:#LedgerName
Align:Right
Full Width:Yes

[Field:SJGroupShNo]
Use:Name Field
Set as:$LedgerPhone:Ledger:#LedgerName
Align:Right
Full Width:Yes

 

brilliant grate same i want God Bless u just guide me how can i fetch data from udf really u grate

 

means to say rent start field need to fetch deta from 1 udf in tally master thanks u just a little guide me will try myself

 

God Bless you thanks you

 

If u r adding UDF field u want 2 fetch object name like LedShopNo, LedRentStart,,,,,,,,etc

[Report:SJGroup]
Form:SJGroup
Object:VOUCHER:##VOUCHERID
Title:"SJ Group of Company"
Print Set:REPORT TITLE:"SJ Group of Co.,"
Fetch Object:Ledger:#LedgerName:Name, LedgerContact, LedgerPhone, OpeningBalance, LedOpeningBalance, TBalOpening, LedShopNo,..............

 

Object:VOUCHER:##VOUCHERID
??????
sir object voucher or something other
this file i got from here and changed as per my requiremtn so thsese udf i want to fetch in tenent profile plzzzz

 

I WILL TRY TOMORROW BCOZ TODAY A LITTLE BUSY

 

KINDLY ADD A PART ON RIGHT SIDE FOR LEDGER TENANT NAME PLZZZ

 

I Am not getting success to fetch the udf fields data in this can u plzzz guide me