Multiple company collections issue

Discussion in 'Free Source Codes' started by Jayashri, Oct 19, 2021.

    
  1. Jayashri

    Jayashri Member


    Hi...any one kindly advice or crt d code,,,,

    Comes issue when group company combines and makes Part wise outstanding report.
    For example, A-company has ledger abc tex and B - company has abc tex So two bills are pending merge
    i want individual subtract ,,,

    my collections

    [Part:GRPLedBILL Title lED]
    Line : GRPLedBILL Title lED
    Repeat : GRPLedBILL Title lED:Ledger of Multiple Companies

    [Collection: Ledger of Multiple Companies]

    Collection : My Led : Company Collection Led
    Sort : Default : $Date, $LedgerName

    [Collection: Company Collection Led]

    Type : Company
    Fetch : Name

    [Collection:My Led]
    Type : Ledger
    Child Of : $$GroupSundryDebtors
    Compute : Owner Company : $$LoopCollObj:$Name
    Compute : GroupComNAme:$BasicCompanyFormalName:Company:##SVCurrentCompany
    Fetch : BasicCompanyFormalName,*;Name
    ;Compute : newGroups:$parent:Ledger:$LedgerName
    Filter:MyfltrGroup

    [Part:LederWisePendingBills]
    Line:MultiCmpDBLnTitle,LederWisePendingBills Vch
    Bottom Line:GRPLedBILL TotalS
    Repeat:LederWisePendingBills Vch:Bill of Multiple Companies
    Total: BILLOp, BILLCl

    [Collection: Bill of Multiple Companies]
    Collection : Group LedgerBillsS : Company Collection Bill
    Sort : Default : $Date, $LedgerName
    [Collection: Company Collection Bill]

    Type : Company
    Fetch : Name

    [Collection: Group LedgerBillsS]

    Type : Bills
    ;Childof : #GRPLedBILLTitlelED
    Fetch : *

    Fetch : Name, BillDate, BillCreditPeriod, BaseClosing, FinalBalance
    Fetch : ClosingBalance, ForexClosing ,OpeningBalance, BillDate, Name,LedgerGrp,GroupName,Parent
    Compute : Owner Company : $$LoopCollObj:$Name
    Filter:filternonBilles
     

    Attached Files:



Share This Page