Need Solution for fetching Payment Details from Bills Collection

Discussion in 'Free Source Codes' started by Aslan Iglesias, Feb 24, 2024.

    
  1. Aslan Iglesias

    Aslan Iglesias New Member


    Hi Experts,

    I am writing a collection for Cleared Bill, I need payment vouchers details like CostCente Class and Narration from the same collection

    [Collection: ClearedPaymentBills]
    Type : Bills
    Fetch : *,*.*
    Fetch : LedgerEntries.InventoryEntries.BatchAllocations.OrderNo
    Cleared : Yes
    Compute : PurcVchType : $$CollectionField:$VoucherTypeName:1:LedgerEntries
    Compute : PurcPartyName : $$CollectionField:mad:@RemoteParty:1:LedgerEntries
    Compute : PurcVCHNo : $$CollectionField:mad:@RemotePONum:1:LedgerEntries
    Compute : PurcDate : $$CollectionField:$Date:1:LedgerEntries
    Compute : PurcRefDate : $$CollectionField:$ReferenceDate:1:LedgerEntries
    Compute : PurcPONum : $$CollectionField:$BasicPurchaseOrderNo:1:LedgerEntries

    Compute : PartyPAN : $IncomeTaxNumber:Ledger:$Parent
    Compute : PartyGSTNum : $LedPartyGSTIN:Ledger:$Parent
    Compute : TDSTaxR : $$CollectionField:$TDSTaxRate:1:LedgerEntries
    Compute : TDSLed : $$CollectionField:mad:@TDSLedger:1:LedgerEntries
    Compute : TDSAmt : $$CollectionField:mad:@TDSAmount:1:LedgerEntries
     


  2. sivam

    sivam Active Member


    Use like Below

    Compute : BillNarration : $LedgerEntries[1,@@IsPaymentVch].Narration
     
    Aslan Iglesias likes this.


  3. Aslan Iglesias

    Aslan Iglesias New Member


    It is not showing any result
    My code is like this

    [Collection: ClearedPaymentBills]
    Type : Bills
    Fetch : *,*.*
    Compute : BillNarration : $LedgerEntries[1,@@IsPaymentVch].Narration

    ;select $Name,$Parent,$BillAmount,$OpeningBalance,$BillNarration from ClearedPaymentBills
     


  4. Sai Vineeth

    Sai Vineeth Active Member


    you missed Cleared : Yes
     


  5. sivam

    sivam Active Member


    This will fetch Narration Only from Payment Vouchers. So check Payment entry is there.?
     


Share This Page