help to add a one field in outstanding aging report

Discussion in 'Tally Developer' started by mutharasan, Aug 24, 2016.

    
  1. mutharasan

    mutharasan Member


    Dear All Tdl Experts,

    Thanks in advance,

    please help me to add one new field in outstanding aging report. i tried in many ways, but i can't do it. please guide me.

    Thanking you,
     


  2. mpal2311

    mpal2311 Active Member


    try this.


    [#Line: BILLWithDates]
    Delete: Right Fields : BILLOverdue

    [#Field: BILLFixed]
    Add : Fields : After : BILLRef : BillPONo

    [Field : BillPONo]
    use : namefield
    Width:8
    Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:First:polyfabSales
    My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo


    [System: Formula]
    Polyfab Sales : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName

    [#Line: BILLCol1]
    Local:Field:BillPONo:Setas:"PO No"

    [#Line: BILLCol2]
    Local:Field:BillPONo:Setas:""
     


  3. mpal2311

    mpal2311 Active Member


    try this also:

    [#Line: BILLWithDates]
    Delete: Right Fields : BILLOverdue

    [#Field: BILLFixed]
    Add : Fields : After : BILLRef : BillLPONo, BillPOdate


    [Field : BillPOdate]

    ;;Use : Short Date Field

    Set as : $$FilterValue:$BasicOrderDate:LedgerEntries:First:polyfabSales ;;if $$IsSysName:$BasicPurchaseOrderNo then "" else $$FullList:InvoiceOrderList:$BasicOrderDate:mad:BasicOrderDateUniversal
    width : 10
    MyValue:$$FullList:InvoiceOrderList:$BasicOrderDate

    [Field : BillLPONo]

    use : namefield
    Width:8
    Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:First:polyfabSales
    My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo
    ;;Set as: $BasicPurchaseOrderNo



    [#Collection: Company Receivables]
    Fetch:BasicPurchaseOrderNo,BasicOrderDate


    [#Collection: Company Payables]
    Fetch:BasicPurchaseOrderNo,BasicOrderDate

    [System: Formula]
    Polyfab Sales : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName

    [#Line: BILLCol1]
    Local:Field:BillLPONo:Setas:"PO No"

    [#Line: BILLCol2]
    Local:Field:BillLPONo:Setas:""

    [#Line: BILLCol1]
    Local:Field:Billpodate:Setas:"PO Date"

    [#Line: BILLCol2]
    Local:Field:Billpodate:Setas:""
     


  4. kamal

    kamal Member


    Dear sir,
    i want to display customer mobile number in Group outstanding report
    please correct below code

    [#Line: BILLCol1]
    use :BillDetail
    Local : Field : BillContact : Set as: $$LocaleString:"Contact"
    [#Line: BILLCol2]
    Local : Field : BillContact : Set as: ""
    [#Field: BILLFixed]
    Add: Field : After: BILLParty : BillContact
    [Field: BillContact]
    Set as : $LedgerMobile:Ledger:partyLedgerName

    [#Line: BILL Total]
    Local : Field : BillContact : Set as : ""

    [#Part: GRPLedBILL Details]
    Local: Line : BILL Detail : Local : Field : BillContact : Set as : ""

    [#Line: GRPLedBILL Total]
    Local : Field : BillContact : Set as : ""
     


  5. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Try This

    [#Line: BILLCol1]
    use :BillDetail
    Local : Field : BillContact : Set as: $$LocaleString:"Contact"

    [#Line: BILLCol2]
    Local : Field : BillContact : Set as: ""

    [#Field: BILLFixed]
    Add: Field : After: BILLParty : BillContact

    [Field: BillContact]
    Set as : $LedgerMobile:Ledger:$parent

    [#Line: BILL Total]
    Local : Field : BillContact : Set as : ""

    [#Part: GRPLedBILL Details]
    Local: Line : BILL Detail : Local : Field : BillContact : Set as : ""

    [#Line: GRPLedBILL Total]
    Local : Field : BillContact : Set as : ""
     


  6. kamal

    kamal Member


    Thank You subramanian garu
     


  7. kamal

    kamal Member


    Hi sir,,

    how can i add Godown Name in Bill Outstanding Report
    and filter data using godown
     


  8. V Shankar

    V Shankar New Member



    Sir,

    same report can i have the buyers name (the name on the invoice) not the party ledger name
     



  9. Help me to a design a outstanding collection, First repeat will be "BASED ON PARTY LEDGER NAME", THEN REPEAT BASED ON VOUCHER TYPE".
    [Collection : MyOsColl]
    Type : Bills
    Compute : PartyName : $$FuncDSPAccName:$Parent
    Compute : BillRef : $BillRef
    Filter :Filter : IsReceivable, PartyFilter
    [System : Formula]
    PartyFilter : $$FuncDSPAccName:$Parent = #MyPartyLedger
    MySPfilter : ($$IsSales:$VoucherTypeName)
    ExemptedFilter : $$FilterValue:$VoucherTypeName:LedgerEntries:First:MySPFilter = "GST Seeds Sales"
    TaxableFilter : $$FilterValue:$VoucherTypeName:LedgerEntries:First:MySPFilter = "GST Sales Taxable"
    Further I am unable use "Walk" and " to Group" "By" in the collection
     


  10. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Where is your code ??
     



  11. Started Designing; Below is the Outline;
    Want a collection "By" "PartyName" then using the collection I want to repeat a PartyName Line in the "Bills Receivables" based on "VoucherTypeName"
     


  12. Jayakrishnan

    Jayakrishnan New Member


    Same like this i want to code for Sales Ledger name in outstanding report instead of contact number. so i can analyse what item sold and showing outstanding....pls help me
     


  13. Jayakrishnan

    Jayakrishnan New Member


    Please help on this
     


  14. rke

    rke Member


    how can add the ref n o in it
     


Share This Page