HOW I CAN GET RELATABLE DATA PLS HELP

Discussion in 'Free Source Codes' started by GOINDI1311, Jan 11, 2024.

    
  1. GOINDI1311

    GOINDI1311 Member


    Respected Experts
    i am trying to fetch the outstanding bill from related ledger.
    but it showin all the bills on each ledger name.

    Please help.......as my collection given below....

    [Part:TRADING PART]
    Line:OSNAME
    Repeat:OSNAME:COLLOSNAME
    Scroll : Vertical
    Common Border : Yes

    [Line: OSNAME]
    Field: OSNAME

    Explode: DrillOSLIST

    [Part:DrillOSLIST]
    Line:OSREF
    REPEAT:OSREF:COLLOSBILL

    [LINE:OSREF]
    Field: OSBILLDT, OSREF, OSOP

    [FIELD:OSREF]
    Use : NameField
    Set As: $Name


    [Field:OSBILLDT]
    Use : Uni Date Field
    Set As : $Billdate

    [Field:OSOP]
    Use : Amount Field
    Set As : $OpeningBalance
    Format : "DrCr"

    [FIELD:OSNAME]

    Use: NAME

    Set as: $NAME
    Width : 45
    Align: CentER

    [Collection:COLLOSNAME]
    Type: LEDGER
    Fetch: NAME
    Belongs To: Yes


    [Collection:COLLOSBILL]
    Type: BILL
    Fetch: NAME,Billdate,OpeningBalance
    Belongs To: Yes
    upload_2024-1-11_15-7-56.png
     


  2. Rajat Agarwal

    Rajat Agarwal Member


    Set as : $$Localestring:$LedgerName
    Set as : $Closing balance
     


Share This Page