where i have gone wrong ?

Discussion in 'Free Source Codes' started by RAJESH KUMAR JAKKA, Sep 12, 2020.

         
  1. RAJESH KUMAR JAKKA

    RAJESH KUMAR JAKKA New Member


    dear expert

    plz let me know where i have gone wrong in fetching the value from voucher to ledger

    my code is as follows;
    ;;;;jai ganeshaya namaha
    [#Line: ACLSTitle]
    Add:Right Field:Before:VCH DebitTitle:cash,cheq
    [Field:cash]
    Use:name field
    Set as:"CASH "
    Border:column titles
    Color:blue
    [Field:cheq]
    Use:name field
    Set as:"CHEQ"
    Border:column titles
    Color:blue
    [#Line: ACLSInfo]
    Add:Right Field:Before:ACLSAmt:CASH1,CHEQ1

    [Field:CASH1]
    Use:AMOUNT FIELD
    Storage: CASH1
    Color:BLUE
    Set Always: Yes
    Space Right:17
    Width: 5

    [Field:CHEQ1]
    Use:AMOUNT FIELD
    Storage:CHEQ1
    Color:BLUE
    Set Always:Yes
    Space Right: 20
    Width: 5

    [System:UDF]
    CASH1:Amount:896
    CHEQ1:Amount:897

    ;;;;;============================= CREATION OF UDF TITLES IN LEDGER======
    [#Line: DSP VchAccTitles]
    USE:LINE: VCHDETAIL
    Add:Right Field:Before:DSP VchTypeTitle:CASH2,CHEQ2
    [Field:CASH2]
    Use:name field
    Set as:"CASH"
    Skip:Yes
    Color:blue
    [Field:CHEQ2]
    Use:name field
    Set as:"CHEQ"
    Skip:Yes
    Color:blue
    [#Line:DSP VchDetail]
    Add:Right Field:Before:DSP VchType:CASH3,CHEQ3
    [Field:CASH3]
    Use:AMOUNT field
    Set as:$CASH1
    Color:BLUE
    [Field:CHEQ3]
    Use:AMOUNT field
    Set as: $CHEQ1
    Color:BLUE
    [#Collection : Vouchers of Ledger]
    Fetch:CASH1,CHEQ1
     

    Attached Files:



  2. Himanshu-2002

    Himanshu-2002 Member


    I am not 100% Sure But If I will do this then I will follow this steps

    Step 1: Create a Collection Which Contains All Vouchers

    Example:

    [Collection: MySalesVouchersColl]
    Type:Vouchers:VoucherType
    Child Of:$$VchTypeSales
    Belongs To:Yes

    Step 2: Walk In Collection and Fetch Required Values

    [Collection:Sales AllVoucher]
    Source Collection: MySalesVouchersColl
    Walk:Inventory Entries
    Compute : MyInventoryCash :$MyUDF
    Compute : MyInventoryCheque:$MyUDF2

    Step 3: Use Computer Value in Field

    Example:

    [Field: MyField]
    Set as: $MyInventoryCash

    [Field: MyField2]
    Set as: $MyInventoryCheque


    Hope This Helps
     


  3. Himanshu-2002

    Himanshu-2002 Member


    If You want to fetch total Cash Or Cheque Value only from that particular voucher then You can use By and Aggre Compute attributes
    Too
     


  4. RAJESH KUMAR JAKKA

    RAJESH KUMAR JAKKA New Member


    sir
    i could get the total value from the voucher as displayed in the attachment but partywise amount is not being fetched to respective party ledger
    eg: received from abc 2/- (1/- in cash and 1/- in cheque) and in the same way received from badri 25/- (13/- cash and 12/- cheque)
    but in any ledger the total of 2/- and 25/- is being displayed in both ledgers

    hence plz tell me how to filter party wise voucher amount to be fetched to the respective ledger
     

    Attached Files:



  5. RAJESH KUMAR JAKKA

    RAJESH KUMAR JAKKA New Member


    my code is
    [#Line:DSP VchDetail]
    Add:Right Field:Before:DSP VchType:CASH3,CHEQ3
    [Field:CASH3]
    Use:AMOUNT field
    Set as:$mymode
    Color: Blue
    Style: Normal
    Space Right:15
    [Field:Cheq3]
    Use:AMOUNT field
    Set as:$mymode1
    Color: Blue
    Style: Normal
    Space Right: 15
    [#Collection : Vouchers of Ledger]

    Compute : mymode : $$CollAmtTotal:LedgerEntries:$cash1
    Compute : mymode1 :$$CollAmtTotal:LedgerEntries:$cheq1
     


  6. Himanshu-2002

    Himanshu-2002 Member


    Sir Study By, Aggre Compute, Walk Attributes and My explanation which I give earlier
     


  7. Himanshu-2002

    Himanshu-2002 Member


    After that If you are unable to achieve it Tell me I will try to give a detailed explanation with Codes
     


  8. Himanshu-2002

    Himanshu-2002 Member


    I am little busy with my studies ( IIT Aspirant ) that is why Maybe I will reply you little late but I will reply you For sure
     
    ASHOK likes this.


  9. RAJESH KUMAR JAKKA

    RAJESH KUMAR JAKKA New Member


    thank you sir and all the best for your studies and sorry for the late reply, i do my best try to apply "by and agree and walk attribute"
     


Share This Page