Only Blank values in Sales Register, Can anyone guide how to get Buyer name and address in below code? [#Line : DSP ColVchTitle] Add : Fields : After : DBC VCHType : EI PartyMailingName Add : Fields : After : DBC VchNo : EI PartyAddress Local : Field : Default : Style : Small Italic Local : Field : EI PartyMailingName : Set As : "Buyer Name" Local : Field : EI PartyAddress : Set As : "Buyer Address" [#Line : DSP ColVchDetail] Add : Field : After : DBC VCHType: EI PartyMailingName Add : Field : After : DBC VchNo: EI PartyAddress
thanks for pointing in right direction, have added filed in above code as below Code: [Field : PartyName] Use : Name Field SetAs : $PartyName Width : 13% Page Border : Thin Left Style : Small [Field : PartyAddress] Use : Name Field SetAs : $PartyAddress Width : 13% Page Border : Thin Left Style : Small
Thank you, have added collection in above code as below Code: [#Collection : Columnar Filtered Vouchers of Company] Fetch : PartyName Fetch : PartyAddress [#Collection: Columnar Vouchers of Ledgers] Fetch : PartyName Fetch : PartyAddress
Now the code is working as below:- Code: [#Line : DSP ColVchTitle] Add : Fields : After : DBC VCHType : PartyName Add : Fields : After : PartyName : PartyAddress Local : Field : PartyName : Set As : "Buyer Name" Local : Field : PartyAddress : Set As : "Buyer Address" [#Line : DSP ColVchDetail] Add : Field : After : DBC VCHType: PartyName Add : Field : After : PartyName: PartyAddress [Field : PartyName] Use : Name Field SetAs : $PartyName Width : 13% Page Border : Thin Left Style : Small [Field : PartyAddress] Use : Name Field SetAs : $PartyAddress Width : 13% Page Border : Thin Left Style : Small [#Collection : Columnar Filtered Vouchers of Company] Fetch : PartyName Fetch : PartyAddress [#Collection: Columnar Vouchers of Ledgers] Fetch : PartyName Fetch : PartyAddress