I tried fetching Party address in movement analysis >> Ledger analysis >item analysis. but i am stuck could plz help me. below is my code. thank you ;; OM Ganapathaye Namaha !!!:::: [#Part: STV ColVchTitle] Background: Red [#Line: STV ColVchTitle] ;Set as: "Address" ;Local : Field : STV Party : Set as: "NEW" [#Field: STV Fixed] Add: Fields: After: STV Party :NEW1 Use : Name Field Set as : if NOT $$IsEmpty:##VoucherTypeName then $CurLangVoucherTypeName else @@STVPartyName Width : 50 Style : Normal Bold Border : Thin Left [#Field: STV Party] Width: 50 [Field: NEW1] Set as: $$CollectionField:$Address:ledgerEntriesartyledger1 [Collection: Partyledger1] Type : Address : Ledger Child of : #LedgerName Object : StatePinDetail Fetch : Address, Mailing Name Option : GroupStatePin : NOT $$IsEmpty:##GroupName
Remove the unwanted kachras..... use as under: Code: [#Part: STV ColVchTitle] Background: Red [#Field: STV Fixed] Add: Fields: After: STV Party :NEW1 [#Field: STV Party] Width: 50 [Field: NEW1] Set as: $$CollectionField:$Address:ledgerEntries:partyledger1 [Collection: Partyledger1] Type : Address : Ledger Child of : #LedgerName Object : StatePinDetail Fetch : Address, Mailing Name Option : GroupStatePin : NOT $$IsEmpty:##GroupName
[#Part: STV ColVchTitle] Background: Red [#Line: STV ColVchTitle] ;Set as: "Address" ;Local : Field : STV Party : Set as: "NEW" [#Field: STV Fixed] Add: Fields: After: STV Party :NEW1 Use : Name Field Set as : if NOT $$IsEmpty:##VoucherTypeName then $CurLangVoucherTypeName else @@STVPartyName Width : 80 Style : Normal Bold Border : Thin Left [#Field: STV Party] Width: 30 [Field: NEW1] Set as : "Address" Width: 20 HELP me in this field "NEW1" remaining i will do
you should read very carefully....the comment.....especially the second line....which comprises of 3 words only.
ADD this............. [Collection: Partyledger1] Type : Address : Ledger Child of : #LedgerName Object : StatePinDetail Fetch : Address, Mailing Name Option : GroupStatePin : NOT $$IsEmpty:##GroupName
;; OM Ganapathaye Namaha !!!:::: [#Part: STV ColVchTitle] Background: Red [#Field: STV Fixed] Add: Fields: After: STV Party :NEW1 [#Field: STV Party] Width: 50 [Field: NEW1] Use: NAme field Set as: $$CollectionField:$Address:ledgerEntriesartyledger1 [Collection: Partyledger1] Type : Address : Ledger Child of : #LedgerName Object : StatePinDetail Fetch : Address, Mailing Name Option : GroupStatePin : NOT $$IsEmpty:##GroupName This the code sir but while passing transaction if i give other address its not coming Y???
This code is to get address in your required report and address is picked up from master.......(as defined there in master) It has nothing to do with transactions. during Sales/purchase entry the address you input (overwrite) is different and so is their field. If you want the address then you need to change your collection parameters so it picks up the value from the REVISED address given during voucher entry. (note...this voucher level address will not change the Master level address)
;; OM Ganapathaye Namaha !!!:::: [#Part: STV ColVchTitle] Background: Red [#Field: STV Fixed] Add: Fields: After: STV Party :NEW1 [#Field: STV Party] Width: 50 [Field: NEW1] Use: NAme field ;Set as: $$CollectionField:$Address:1:ledgerEntries Set as : $$FullListartyAddress:$Address [Collection: Partyledger1] ;Source Collection : Default Walk: LedgerEntries Compute : PartyAddress : $$FullListartyAddress:$Address Fetch : Address, Sir please see i have made changes in my collection
I dunno.... i don't have time toload TDL and see.... You have to do it........refer the relevant field in Tally(devmode) in the Vocuher entry.........and imbibe that code.
Yes sir your are right..., After trying all the possibilities only i asked for help.... hope you can understand juzz help me in the collection i will try
You have to do it yourself......... u have not tried it properly ....... anyway I can't spare time...... you write the code, any problems with that, experts will help. But I do not have time to make code for other, as am busy with my own.
i have already given to you the hint.....if you had noticed and read properly........in post # 11.... the place where u input the new address....find that field in Tally(devmode) and then call for it....just like u done for ledger address.