How to Compute this in default Collection of Bills Outstanding

Discussion in 'Tally.ERP 9' started by Sohail Khan, Dec 18, 2020.

    
  1. Sohail Khan

    Sohail Khan Member


    Dear Expert,
    Please Guide me How do I Compute this code in the default collection of Outstanding Reports. I am not able to find the collection. Thank You.


    [Field: OrderNoo]
    Use : Name Field
    Set as :$$collectionfield:$ordno:1:sumcoll
    Set Always :Yes
    Style : Normal Italic
    Line : 0
    Width : @@ShortNameWidth

    [Field: MultiAddress]
    Use : Name Field
    Set as : $$FullList:sumcoll:$addr
    Set Always :Yes
    Style : Normal Italic
    Width : @@NarrWidth
    Line : 0

    [Collection:coll]
    type: vouchers: vouchertype
    Child Of: $$VchTypeSales
    Belongs To:Yes

    [Collection:sumcoll]
    Source Collection :coll
    Walk :INVOICEORDERLIST
    Walk :BASICBUYERADDRESS
    Compute :vch:$vouchernumber
    Compute :eek:rdno:$BASICPURCHASEORDERNO
    Compute :addr:$BASICBUYERADDRESS
    Filter :flt

    [System:Formula]
    flt:$vch=#billref
     
    Last edited: Jan 7, 2021


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Remove your 2 collections.............They are irrelevant and slow down your system......

    Use CollectionField and refer to the collection LedgerEntries.
     
    Last edited: Dec 18, 2020


  3. Sohail Khan

    Sohail Khan Member


    Set As:$$FullList:Ledgerentries:$BASICBUYERADDRESS is giving me only the first line of the address.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make a system Formula..............
    [System : Formula]
    Fulladd : $$FullList:Address:$Address

    Then use that in your SET AS ............. $$Collection........................
     
    Sohail Khan likes this.


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your syntax is wrong..........
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  7. Sohail Khan

    Sohail Khan Member


    Thank You Sir. Its working now.
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very good... now post the screenshot of finished report, so others can also learn ...........
     


  9. Sohail Khan

    Sohail Khan Member


    Screenshot.
     

    Attached Files:



Share This Page