dear sir, i have seen that there are very expert in tally, i need actual buyer name and address in tally sales columnar report. can you help me to add this column. i have created a tdl for buyer name and address. but i am unable to add these feilds in sale report. plz help thanks in advance.
same type of query is already posted. Please check below thread to get idea.. http://tdlcoder.com/index.php?threa...itional-field-in-sales-register.205/#post-428
Respected Sir, I have tried a lot, but the code given in that specific post is dead, that does not work. it's giving error, plz check and make it correct, so that i can furthre change it according to my needs.
[#Part: CMP COLBasics] Add : Line:AtEnd: JVVShow RefDate [Line : JVVShow RefDate] Fields : Medium Prompt,JVVShow RefDate Local : Field : Medium Prompt : Info : $$LocaleString:"Show DespatchThru ?" ;;; String displayed Columnar Register Configuration [Field: JVVShow RefDate] Use : Logical Field Modifies: TDLeXpertsShowDespatchThru [Variable: TDLeXpertsShowDespatchThru] Type : Logical Persistent : Yes [System : Variable] TDLeXpertsShowDespatchThru:"" [#Line : DSP ColVchTitle] Add : Fields : After : DBC VchNo : TDLeXperts DespatchThru Local : Field : Default : Style : Small Italic Local : Field : TDLeXperts DespatchThru : Set As : "DespatchThru" [#Line : DSP ColVchDetail] Add : Field : After : DBC VchNo: TDLeXperts DespatchThru [Field : TDLeXperts DespatchThru] Use : Name Field SetAs :$BasicShippedBy; $TDLeXpertsVCHDespatchThru Width : 13% Page Border : Thin Left Style : Small Invisible : NOT ##TDLeXpertsShowDespatchThru [#Line : DSP ColVchTotal] Add : Field : After : DBC VchNo : TDLeXperts SalesEmpty Local : Field : TDLeXperts DespatchThru : Invisible : Yes [Field : TDLeXperts SalesEmpty] Use : Name Field SetAs : "" Width : 13% Page [#Collection : Columnar Filtered Vouchers of Company] Fetch : TDLeXpertsVCHDespatchThru [#Collection: Columnar Vouchers of Ledgers] Fetch : TDLeXpertsVCHDespatchThru
;;;;;;;;; Code to Display Buyername & Address in Columnar Sales Register;;;;;;;;;;;;;; ;;;-----------------------------------------------------------------------------------;;;;;;;;;;;;;;;;;;;;; [#Line: DSP ColVchDetail] Add : Explode : BuyeraddressPart : $$KeyExplode OR ##ExplodeFlag [Part : buyer AddressPart] Line : BuyeraddressLine Repeat : Buyeraddressline : MyBuyeraddressColl [Line : BuyerAddressLine] Field : BuyerAddressFld [Field : BuyerAddressFld] Set as : $Address Space Left : 8 [Collection : Buyeraddresscoll] Type : Ledger Filter : ChkPartyName Fetch : Name [Collection : MyBuyerAddresscoll] Source Collection : BuyerAddresscoll Walk : Address By : Address : $Address [System : Formula] Chkpartyname : $Name = #DBCParty
Hi, Gaurav, i am not a developer but m looking for the same addon, can you please share a working one with me on hiranisur@gmail.com