1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Address, MobileNo. & Salesman Name in Overdue Receivable

Discussion in 'Tally Developer' started by Ras Raj, Dec 12, 2012.

    
  1. Ras Raj

    Ras Raj Member


    Dear Expert,

    I want to add Address, Mobile No & Salesman Name in Overdue report but i did not get the proper result.

    Please help me.
     
    Ras Raj, Dec 12, 2012
    #1


  2. Ras Raj

    Ras Raj Member


    I am unable to upload file, so am typing code.....


    ; || Kuldevebhyo Namah, Kuldevibhyo Namah, Durgaay Namah, Laxminarayanaay Namah ||

    ;;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    ;;Field in Voucher Header - Sales Man Name
    ;;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    [#Part : EI BaseInfo]
    Add : Line : RssSalesMan

    [Line : RssSalesMan]
    Field : Short Prompt, RssSalesMan,
    Local : Field : Short Prompt : Set as: "Sales Man"
    Local : Field : Short Prompt : Color: Blue

    [Field : RssSalesMan]
    Use: Name Field
    Set as: "N.A."
    Storage: RssSalesMan
    Color: Blue
    ;Validate: NOT $$IsEmpty:$$Value
    ;Notify: NotifyValue is Empty : $$IsEmpty:$$Value
    Control: ControlValue is Empty : $$IsEmpty:$$Value
    [System : UDF]
    RssSalesMan: String : 23402



    ;;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    ;;Report Customization - Contact Details in Overdue
    ;;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    [#Report: Bills Receivable]
    Set : ShowOpBillAmt : Yes

    [#Report: Bills Payable]
    Set : ShowOpBillAmt : Yes

    [#Line: BILLCol2]
    Local : Field : RssAddressTitle: Set as:""
    Local : Field : RssMobileTitle: Set as:""
    Local : Field : RssSalesManTitle: Set as:""

    [#Line: BILL Detail]
    Add : Fields:Before:BillOp: RssAddressDetail, RssMobileDetail, RssSalesManDetail
    Fields : Name Field
    Local : Field : Name Field : Set as : $StateName:Ledger:##LedgerName
    Local : Style : Default : Bold : No

    [Field:RssAddressDetail]
    use:Name Field
    Set as:"Address"
    ;;Set as:$Address
    ;;Set as:$Address:BillParty
    ;;Set as:$LedgerEntries[1].$Address
    ;;Set as:$Address:partyName:##PartyName
    ;Set as:$StateName:Ledger:##LedgerName
    Width:20

    [Field:RssMobileDetail]
    Fetch Object: Ledger:##LedgerName:Name,MailingName,StateName,PINCode,LedgerContact,LedgerPhone,LedgerMobile,LedgerFax,IncomeTaxNumber,VATTINNumber,SalesTaxNumber,registrationnumber, Narration
    Set as:"Mobile"
    ;Set as:$LedgerMobile:BillParty
    Set as:$LedgerMobile:Ledger:##LedgerName
    Width:10
    [Field:RssSalesManDetail]
    Set as:$RssSalesMan
    Width:12
     
    Ras Raj, Dec 12, 2012
    #2


Share This Page