PARTYWISE SALES WITH QUANTITY AND AMOUNT

Discussion in 'Free Source Codes' started by DEEPAK B, Feb 20, 2023.

    
  1. DEEPAK B

    DEEPAK B Member


    Sir, as previously I have already mentioned in my above post. I have added a new Field See Image (Untitled) from my Voucher i.e Rental Charges of that party but I am getting Total Rental Charges for all the parties See the attachment (Untitled)

    Can you help me with the below Code (The amount should be Partywise as shown in Sales Service Voucher) but its talking monthly total of all the parties where it should come party wise

    Where I am going wrong? I have tried my level best but could not find the result

    Also my Header is not coming why ?

    Code:
        [Line: CFBK Rep Title]
            Use : CFBK Rep Details
            Local : Field : Default             : Type         : String
            Local : Field : Default             : Align     : Center
            Local : Field : Default             : Style     : Normal Bold
            Local : Field : Default                : Background: Petal Pink
            Local : Field : Default                : Color        : Red
            Local : Field : CFBK Rep Name         : Widespaced: Yes
            Local : Field : CFBK Rep Name         : Set as     : "Particulars"
            Local : Field : CFBK Rep Name         : Width     : 30
            Local : Field : CFBK Led Amt         : Set as     : "Rent Charges"
            Local : Field : CFBK Led Amt        : Width     : 10
            Local : Field : CFBK Rep Party         : Delete    : Fields
            Local : Field : CFBK Rep Party         : Set as     : ##IName
            Local : Field : CFBK Rep Party         : Lines     : 0
            Local : Field : CFBK Rep Party         : Border    : Thin Left
            Local : Field : CFBK Rep Party         : Color        : Red
            Local : Field : CFBK Rep Col ATotal : Delete    : Fields
            Local : Field : CFBK Rep Col ATotal    : Widespaced: Yes
            Local : Field : CFBK Rep Col ATotal : Set as     : "Total"
            Border : Flush Totals
    
    [Field: CFBK Led Amt]
                Fields    : Vchsal
                Local    : Field:  Vchsal: Set as: $$CollAmtTotal:VchsaleAmt:$SalAmount
    
    [Collection: VchSaleAmt]
        Source Collection    : CFBK Voucher Amt
        By                               : PName        : $Partyledgername
        Aggr Compute        : SalAmount        : Sum : $IncomeAmt ;this is for net Monthly sale value
    
    [System: Formula]
        IsSalesSerVt: $$IsSales:$VoucherTypeName and $$IsEmpty:$InventoryEntries[1].StockItemName
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Put a condition.......... in your compute inside the collection............
    If $partyledgername = #CBKRepName then $Amount else 0
     
    DEEPAK B likes this.


  3. DEEPAK B

    DEEPAK B Member


    Thank you Amit Sir Once Again
    It's Done.
    Now I do not have to workout Manually everyone Month it just got easier with just click
     


Share This Page