LPO number in outstanding report TDL

Discussion in 'Tally Developer' started by ahmed rishali, Mar 5, 2013.

    
  1. ahmed rishali

    ahmed rishali Member


    Code:
     
    [#Line: BILLWithDates]
    Delete: Right Fields    : BILLOverdue
     
    [#Field: BILLFixed]
    Add :    Fields : After :  BILLRef : BillLPONo
     
        [Field : BillLPONo]
        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:BillLPONo:Setas:"LPO No"
     
    [#Line: BILLCol2]
    Local:Field:BillLPONo:Setas:""
     
     
    
     
    tejeet likes this.


  2. admin

    admin Administrator Staff Member


    Great Post :)
     


  3. nirav1385

    nirav1385 New Member


    REQUIRED DELIVERY NOTE NUMBER IN OUTSTANDING REPORT TDL ???
     


  4. nirav1385

    nirav1385 New Member


    3 delivery order 3 lpo number in 1 invoice, in outstanding report shows only 1 lpo number...
     


  5. sivam

    sivam Active Member



    [#Object:Voucher]

    SSDNNumber : $$FullList:InvoiceDelNotes:$BasicShipDeliveryNote


    [Field : BillLPONo]
    use : namefield
    Width:8
    Set as : $$FilterValue:$SSDNNumber :LedgerEntries:First:polyfabSales
    My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo
     
    vinoth likes this.



  6. Code:
    [#Line: BILLWithDates]
    Delete: Right Fields    : BILLOverdue
    [#Field: BILLFixed]
    Add :    Fields : After :  BILLRef : BillLPONo
    Add : Fields: After: BillLPONO : BILLDONO
        [Field : BillLPONo]
        use : namefield
        Width:8
        Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:First:fabpurchase
        My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo
    
    [System: Formula]
        fab Purchase  : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName
    
    [#Line: BILLCol1]
    Local:Field:BillLPONo:Setas:"LPO No"
    ;;======================================
    
    [#Line: BILLWithDates]
    Delete: Right Fields    : BILLOverdue
    
    [#Field: BILLFixed]
    Add : Fields: After: BillLPONO : BILLDONO
    
    [#Line: BILLCol2]
    Local:Field:BillDONo:Setas:"DO No."
    
    [Field : BillDONo]
    use : namefield
    Width: 8
    Set as : $$FilterValue:$SSDNNumber :LedgerEntries:First:polyfabSales
    my value :$$FullList:InvoiceDelNotes:$BasicShipDeliveryNote
    
    [#Object:Voucher]
    
    SSDNNumber : $$FullList:InvoiceDelNotes:$BasicShipDeliveryNote
    
     



  7. DO number is not coming in outstanding please help me
     



  8. i got it its working fine thx
     


  9. nirav1385

    nirav1385 New Member


    Error!
    cannot understand.

    Bad formula!
    '$$FilterValue:$SSDNNumber :LedgerEntries:First:polyfabSales'


    please help
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    there should not be a SPACE after SSDNNumber
     


  11. rajiv jain

    rajiv jain Member


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


  12. tejeet

    tejeet Member


    dear ahmed sir,
    please add lpo dt. in your above lpo codes & please update new codes or email me new codes @ tejeet1@gmail.com
     


  13. imranlhr

    imranlhr Member


    Dear Experts,

    please share the code of LPO number in Pending Purchase also
     


  14. mukeshb

    mukeshb Member


    Dear Rishali,

    How can we add filter for same by pressing F12 key.
     


Share This Page