How to fetch Basic Buyer Name and Basic Buyer TIN in Sales Register or Daybook? (Both are entered in Supplementary Details in Voucher) Thanks
Yes, but they are not displaying in DayBook, I added a column in daybook and trying to fetch the name by $BasicBuyerName and also tried $BasicBasePartyName Thanks
Mr. Prateek you need to Fetch the Same in the collections of Day Book and Sales Registers. Then only it will show. 1. Add the Fields in the required reports. 2. Add the Fetch syntax in the Collections of day book and sales registers.
Dear Exports i created a report for Customer Name and Mobile No and unable to view Buyer Name please correct the code Thanks is advance ;;; SAI ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;add new file FOR BUYER MOBILE NO FIELD IN SALES ;; and IN INVOICE PRININT ;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;sairam [#Part: EI Buyer] Add: Option: CustomerNameMobile: $$IsSales:$VoucherTypeName [!Part: CustomerNameMobile] Add: Line: At End: CustomerNameMobile [Line: CustomerNameMobile] Border: thin box Field: Short Prompt, fldCustomerNameMobile Local: Field: Short Prompt: Info : "Buyer Mobile No " Local: Field: Short Prompt: Full Width: Yes [Field: fldCustomerNameMobile] Use: Name Field Storage : TSLCustNumber background : Surf Green [System: UDF] TSLCustNumber : String: 1158 ;;;; END OF FILE ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [#Menu: Gateway of Tally] Item : Mobile Nos : Display : MobileRegister : NOT $$IsEmpty:$$SelectedCmps [Report : MobileRegister] Variables : SV CurrentCompany, SV FromDate, SV ToDate, SV SortMethod Set : SV Sort Method : "Default" Set : Is Day Book : No Form : NMCustMobi Set : SVFromDate : ##SVCurrentDate Set : SVToDate : ##SVCurrentDate [Form : NMCustMobi] Use : Dsp Template Height : 100 % Page Width : 100 % Page Part : NMCustMbiPart [Part : NMCustMbiPart] Lines : NMCustMobiTitle, NMCustMobiData Repeat : NMCustMobiData : MyCollectionNM Scroll : Vertical Common border : Yes [Line : NMCustMobiTitle] Fields : NMVchData, NMDateData,NMNameData, NMNoData Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Style : Normal Bold Local : Field : NMVchData : Set as : "Voucher No." Local : Field : NMDateData : Set as : "Date" Local : Field : NMNameData : Set as : "Customer Name" Local : Field : NMNoData : Set as : "Mobile Number" Border : Thin Box [Line : NMCustMobiData] Fields : NMVchData, NMDateData, NMNameData, NMNoData Local : Field : Default : Style : Normal Local : Field : Default : Align : Center Option : AlterOnEnter : $$IsVoucher AND NOT $IsDeleted [Field : NMVchData] Use : Number Field Set as : $VoucherNumber Width : 10 Align : Right Alter : Voucher : $$IsVoucher AND NOT $IsDeleted space Right : 10 Border : Thin Right Align : Center [Field : NMDateData] Use : Uni Date Field Set as : $Date Border : Thin Right width : 20 [Field: NMNameData] Use : Simple Field Set as : $$FullList:MyCollection:$Taxname Style : Normal Width : 30 Scroll : Yes Border : Thin Left [Collection:My Collection] Source Collection:Columnar Filtered Vouchers of Company Fetch:Tax Name [Field : dummylie ] Use : Name field Set as : $BasicBuyerName ;LedgerName ;BasicBasePartyName Width : 40 Border : Thin left Align : Left [Field : NMNoData] Use : Name Field Set as : $TSLCustNumber Width : 20 Border : Thin Left Line : 0 [Collection : MyCollectionNM] Type : Vouchers Filter : NMOnlySales [System : formula] NMOnlySales : $$IsSales:$VoucherTypeName
Dear Kamal, Thanks for you sharing. From this report i have solve one of my Problem. So Thanks To You & NMS & Also Admin sir for Providing This kind of Plateform for New Devloper. Manish