Fetch BasicBuyerName and BasicBuyerTIN

How to fetch Basic Buyer Name and Basic Buyer TIN in Sales Register or Daybook?
(Both are entered in Supplementary Details in Voucher)

Thanks

 

you want add buyer name and tin no in day book collections

 

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.

 

Thanks!

 

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

 

Hi Kamal ,
Try This Corrected Code......

 

Sir ThankQ
we have to Fetch : BuyerName in collection

 

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