1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

PO No and PO date in Out Standing Report

Discussion in 'Tally Developer' started by vishal jayswal, Jul 23, 2014.

    
  1. vishal jayswal

    vishal jayswal Member


    How can i add PO no and PO date in Outstanding Report.

    i had try but i am only able to get Only PO number, but PO date is not coming.
    So please help me..

    I shared my Source Code.

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

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


    [Field : BillPOdate]

    ;;Use : Short Date Field

    Set as : if $$IsSysName:$BasicPurchaseOrderNo then "" else $$FullList:InvoiceOrderList:mad:@BasicOrderDateUniversal
    width : 10


    [Field : BillLPONo]



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



    [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:""
     
    vishal jayswal, Jul 23, 2014
    #1


  2. mahgs

    mahgs Member


    Dear vishal jayswal:

    Find the Coading

    [#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:""
     
    mahgs, Jul 23, 2014
    #2
    Mahesh Sethi and Ras Raj like this.


  3. vishal jayswal

    vishal jayswal Member


    Thank You sir...
     
    vishal jayswal, Dec 12, 2014
    #3


  4. Anthony dinakaran

    Anthony dinakaran New Member


    Thanks for sharing very useful!
     
    Anthony dinakaran, Feb 3, 2015
    #4


Share This Page