Problem in Explode of outstanding report !

Discussion in 'Free Source Codes' started by Rohit001, Mar 15, 2020.

    
  1. Rohit001

    Rohit001 Member


    please help here is code-
    [#Menu:gateway of tally]
    Add: Item: Before: @@LocQuit: BILL WISE DEBIT OUTSTANDING: Display:BILLSALEREPORTDIX

    [Report:BILLSALEREPORTDIX]
    Use:DSP TEMPLATE
    Form:CASHSALEREPORTDIX
    Set : SVFromDate: ##SVCurrentDate
    Set : SVToDate : ##SVCurrentDate
    Set : FilterPartyNameGWLWBILLDIX : ""
    [Form:CASHSALEREPORTDIX]
    Use:DSP TEMPLATE
    Height:100% SCREEN
    Width:100% SCREEN
    Part:CASHSALEREPORTtitleDIX,CASHSALEREPORTbodyDIX,CSBOTTOMTITLEDIX
    Button:EXPLODEFLAG,BtnPartyNameGWLWFilterBILLDIX
    [Button:BtnPartyNameGWLWFilterBILLDIX]
    Key : F5
    Action : Execute : Dispatch DetailsWiseBILLDIX
    Title : PARTY NAME


    [Report:Dispatch DetailsWiseBILLDIX]
    Form : Dispatch DetailsWiseBILLDIX

    [Form:Dispatch DetailsWiseBILLDIX]
    Part : Dispatch DetailsWiseBILLDIX
    Space Left : 2 mms
    Space Right : 2 mms

    [Part:Dispatch DetailsWiseBILLDIX]
    Line : Dispatch DetailsWiseBILLDIX

    [Line:Dispatch DetailsWiseBILLDIX]
    Field : Medium Prompt,Dispatch DetailsWiseBILLDIX
    Local : Field : Medium Prompt : Set as : "Select Party Name:"
    Space Bottom : 2 mms

    [Field:Dispatch DetailsWiseBILLDIX]
    Table : FILTER,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : FilterPartyNameGWLWBILLDIX
    Modifies : FilterPartyNameGWLWBILLDIX

    [Collection: FILTER]
    Type: Ledger
    ChildOf: $$GroupSundryDebtors
    BelongsTo: Yes

    [System:Formula]
    SMSFilterBILLDIX : $PARTYLedgerName=@@PartyLedgerWiseBILLDIX
    PartyLedgerWiseBILLDIX : If $$IsEndOfList:##FilterPartyNameGWLWBILLDIX or ##FilterPartyNameGWLWBILLDIX="" Then $PARTYLedgerName Else ##FilterPartyNameGWLWBILLDIX


    [Variable: PartyNameGWLWNIKDIX]
    Type : String
    Repeat : ##DSPRepeatCollection

    [Variable:FilterPartyNameGWLWBILLDIX]
    Type : String

    [System:Variables]
    FilterPartyNameGWLWBILLDIX : ""


    [Part:CASHSALEREPORTtitleDIX]
    Line:CASHSALEREPORTtitleDIX,kBILLDIX
    Background:YELLOW
    [Line:kBILLDIX]
    Right Field : Name Field
    Left Field : Short Prompt,SMSfilterRptBILLDIX
    Local : Field : Name Field : Info : @@DSPDateStr
    Local : Field : Name Field : Width : 60
    Local : Field : Name Field : Align : Right
    Local : Field : Short Prompt : Set as: "Party Name:"
    [Field:SMSfilterRptBILLDIX]
    Use : Simple Field
    Style : Normal
    Set as : @CSITEMNAMEDIX
    Set Always : Yes
    CSITEMNAMEDIX : If $$IsEndOfList:##FilterPartyNameGWLWBILLDIX or ##FilterPartyNameGWLWBILLDIX="" Then "" Else ##FilterPartyNameGWLWBILLDIX


    [Line:CASHSALEREPORTtitleDIX]
    Field:CASHSALEREPORTtitleDIX
    Right Field: uni date field;;
    Space Bottom:.5
    Local:Field:uni date field:Set as:##SVCURRENTDATE;;DATE FIELD2
    Local:Field:uni date field:Width:10;;;DATE FIELD3

    [Field:CASHSALEREPORTtitleDIX]
    Use:name field
    Indent:6
    Set as:"BILL WISE DEBIT OUTSTANDING"
    Full Width:Yes
    Style:HEADER TITLE
    Align:Center
    Color:red
    Border:THICK BOTTOM
    Wide Space:Yes;
    Line:1.5;;;0
    [#Style:HEADER TITLE]
    Height:grow 20%


    [Part:CASHSALEREPORTbodyDIX]

    Line:CASHSALETITLELINEDIX,CASHSALEDETAILLINEDIX
    Repeat:CASHSALEDETAILLINEDIX:CASHSALECOLLDIX
    Scroll:Vertical
    Common Border:Yes
    Total:CSTOTALBILLAMTDIX,CS TOTALBILLRECDIX,csvalueDIX
    Background:GREEN1DIX



    [Collection:CASHSALECOLLDIX]
    Type:VOUCHERS:VOUCHERTYPE
    Child Of:$$VchTypeSales
    Belongs To:Yes
    Fetch:DATE,VOUCHERNUMBER,BASICBUYERNAME,Reference,STOCKITEMNAME,BasicPurchaseOrderno,BasicOrderDate,BasicOrderRef,AMOUNT
    Fetch:LEDGERENTRIES.*
    Compute:$$CollAmtTotal:InventoryEntries:$CreditTotals
    compute:$$CollAmtTotal:InventoryEntries:$Amount

    Filter : NOTIsOptionalVoucher,SMSFilterBILLDIX
    [Line:CASHSALETITLELINEDIX]
    Field:CS SNODIX,CS BILLDATEDIX, CS BILLNODIX, CS ITEMNAMEDIX,CS PARTYSALEDIX,CS PARTYPODATEDIX,CS PARTYREFDIX,CS TOTALBILLAMTDIX,CS TOTALBILLRECDIX,csvalueDIX
    Local:Field:CS SNODIX:Info:"Sr NO"
    Local:Field:CS BILLDATEDIX:Info:"BILL DATE"
    Local:Field:CS BILLNODIX:Set as:"BILL No"

    Local:Field:CS ITEMNAMEDIX:Set as:"CUSTOMER NAME"

    Local:Field:CS PARTYSALEDIX:Info:"P.O.NO."
    Local:Field:CS PARTYPODATEDIX:Info:"P.O.DATE"
    Local:Field:CS PARTYREFDIX:Info:"REF.NO."
    Local:Field:CS TOTALBILLRECDIX:Info:"Recieved"
    Local:Field:csvalueDIX:Info:"Balance"
    Local:Field:csvalueDIX:Align:Center
    Local:Field:CS TOTALBILLAMTDIX:Info:"AMOUNT"
    Local:Field:CS TOTALBILLAMTDIX:Align:Center
    Border:Flush Column Titles
    Local:Field:DEFAULT:Color:BLUE

    [Line:CASHSALEDETAILLINEDIX]

    Field:CS SNODIX,CS BILLDATEDIX, CS BILLNODIX,CS ITEMNAMEDIX,CS PARTYSALEDIX,CS PARTYPODATEDIX,CS PARTYREFDIX,CS TOTALBILLAMTDIX,CS TOTALBILLRECDIX,csvalueDIX


    Explode:csINVENTRIESDIX:$$KeyExplode;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Explode: CPGrp OnAccVouchersNIK:$$KeyExplode

    [Part:csINVENTRIESDIX]
    Line:csINVENTRIESDIX
    Repeat:csINVENTRIESDIX:MYCOLL
    [Line:csINVENTRIESDIX]
    Field:csINVENTRIESDIX,csINVENTRIESqtyDIX,csINVENTRIESrateDIX,csINVENTRIESVALUEDIX

    [Field:csINVENTRIESDIX]
    Use : UniDateField
    Set as : $Date
    Width : if NOT $$InPixelMode then @@ShortDateWidth else @@ShortDateWidth - 1
    Alter : CPBillVoucher
    Display : VCH Display
    Option : Excel BILLVCH Date : $$InExportMode AND ($$KeyExplode OR ##ExplodeFlag)

    [Field:csINVENTRIESqtyDIX]
    Use : ShortNameField
    Set as : $CurLangVoucherTypeName
    Width : @@NumberWidth + 1
    [Field:csINVENTRIESrateDIX]
    Use : ShortNameField
    Set as : $VoucherNumber
    Width : @@NumberWidth - 1

    [Field:csINVENTRIESVALUEDIX]

    Use : Amount Field
    Set as : $BillAmount
    Format : "DrCr"
    Width : if NOT $$InPixelMode then @@AmountWidth else (@@AmountWidth - 1)

    [Part: CPGrp OnAccVouchersNIK]

    Line : CPGrp OnAccVouchersNIK
    Repeat : CPGrp OnAccVouchersNIK : MYCOLL2
    Scroll : Vertical

    Option : Non Bold Part
    Option : Italic Part

    [Line: CPGrp OnAccVouchersNIK]

    Use : csINVENTRIESDIX
    EmptyIf : (If #CFPIsRecievable Then NOT $$IsDr:$OnAccLedTotal Else $$IsDr:$OnAccLedTotal) OR +
    ($Date != $$ExplodeOwner:#CPGSDate)
    Local : Field :csINVENTRIESVALUEDIX : Set as : $OnAccLedTotal

    [Collection:MYCOLL]
    Source Collection:MYCOLL1
    Walk : LedgerEntries
    By : MasterID : $MasterID
    Compute : Date : $Date
    Compute : VoucherTypeName : $VoucherTypeName
    Compute : CurLangVoucherTypeName: $VoucherTypeName
    Compute : VoucherNumber : $VoucherNumber
    Compute : BillAmount : @@AllocBillsTotal

    Parm Var : BillName : String : #BillName
    Parm Var : LedgerName : String : #LedgerName
    Filter : NOTIsOptionalVoucher

    [Collection:MYCOLL1]
    Object : Bill : @@PartyBillKey
    Fetch : Name, Parent, LedgerEntries.*

    Parm Var: BillName : String : #BillName
    Parm Var: LedgerName : String : #LedgerName

    [Collection: MYCOLL2]

    Type : OnAccountVouchers
    Child Of: #LedgerName
    Fetch : Date, CurLangVoucherTypeName, VoucherNumber, IsPostDated
    Fetch : HasInventory

    Compute : OnAccLedTotal : ($$OnAccountTotal:#LedgerName)
    Parm Var: SVFromDate : Date : @@BooksFromDate
    Parm Var: SVToDate : Date : ##ProjectionEndDate
    Filter : NOTIsPostDatedVch

    [System: Formula]

    PartyBillKey : $$SPrintf:"%s%s%s":##BillName:$$Separatorchar:##LedgerName

    [Field:CS SNODIX]
    Use:NUMBER FIELD
    Set as:$$Line
    Width:4
    Border:THIN LEFT
    [Field:CS BILLDATEDIX]
    Use:UNI DATE FIELD
    Set as:$DATE
    Alter:Voucher
    Border:THIN LEFT
    Width:7
    [Field:CS BILLNODIX]
    Use:NAME FIELD
    Set as:$VOUCHERNUMBER
    Alter:Voucher
    Border:THIN LEFT
    Width:6

    [Field:CS ITEMNAMEDIX]

    Use:NAME FIELD
    Set as:$LedgerName
    Display:Voucher
    Border:THIN LEFT
    Width:35

    [Field:CS PARTYSALEDIX]
    Use : Name Field
    Set as:$BasicPurchaseOrderno
    Width:40

    Border:THIN LEFT
    [Field:CS PARTYPODATEDIX]
    Use : Name Field
    Set as:$BasicOrderDate
    Width:10

    Border:THIN LEFT
    [Field:CS PARTYREFDIX]
    Use : Name Field
    Set as:$Reference
    Width:10

    Border:THIN LEFT
    [Field:csvalueDIX]
    Use : AMOUNT Field
    Set as:$$ToValue:$DATE:$CLOSINGBALANCE:LEDGER:$$CollectionField:$ledgername:1:ledgerentries

    Width:15
    Format:"DrCr,Nozero,"
    Border:THIN LEFT

    [Field:CS TOTALBILLAMTDIX]
    Use:AMOUNT FIELD
    Set as:$AMOUNT
    Format:"DrCr,Nozero,"
    Border:THIN LEFT
    Width:15
    [Field:CS TOTALBILLRECDIX]
    Use:AMOUNT FIELD
    Set as:$$ToValue:$DATE:$CreditTotals:LEDGER:$$CollectionField:$ledgername:1:ledgerentries;$AMOUNT
    Format:"DrCr,Nozero,"
    Border:THIN LEFT
    Width:15
    [PART:CSBOTTOMTITLEDIX]
    Bottom Line:cashsalebottomlineDIX
    Background:YELLOW
    Height:5% SCREEN
    [Line:cashsalebottomlineDIX]

    Field:cstotalTITLEflDIX,cstotalVALUEflDIX,cstotalVALUEflDIX1,cstotalVALUEflDIX2
    Border: THIN TOP BOTTOM

    [Field:cstotalTITLEflDIX]

    Set as:"TOTAL"
    Style:LARGE BOLD
    Color:BLUE
    Align:Center
    Width:50% PAGE
    Border:THIN LEFT



    [Field:cstotalVALUEflDIX]
    Use:amount field
    Set as:$$Total:CSTOTALBILLAMTDIX
    Style:LARGE BOLD
    Space Right:1.25

    Color:BLUE
    Format:"DrCr"
    Width:35% PAGE
    Border:XX
    [Border:XX]
    Left:Thin
    Right:Thin
    [Field:cstotalVALUEflDIX1]
    Use:amount field
    Set as:$$Total:CSTOTALBILLRECDIX
    Style:LARGE BOLD
    ;Space Right:1.25

    Color:BLUE
    Format:"DrCr"
    Width:13% PAGE
    Border:XX

    [Field:cstotalVALUEflDIX2]
    Use:amount field
    Set as:$$Total:csvalueDIX
    Style:LARGE BOLD
    ;Space Right:1.25

    Color:BLUE
    Format:"DrCr"
    Align:Right
    Width:14% PAGE


    [Color:GREEN1DIX]
    RGB:26,234,135

     
    Last edited: Mar 15, 2020


  2. Rohit001

    Rohit001 Member


    Please help sir
     


  3. Neha19

    Neha19 Member


    Hello. Anybody got the solution??? Please help
     


Share This Page