1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Received Amt Column in Sales Register

Discussion in 'Tally Developer' started by Hasan@123, Jun 5, 2020.

    
Tags:
Page 1 of 3
  1. Hasan@123

    Hasan@123 Member


    Dear Developers,
    I have added a column in sales register to see sale bill wise received amount. I want this column to fetch received amount against each sale bill and if there is no amount received then it will remain blank.
    for example If a receipt entry of Rs.500 is passed against "Xyz", that 500 amount should reflect in this column. How can i fetch that amount? Please help and check my code...

    [#Line: DSP VchAccTitles]
    Add:LeftField:After: DSP VchAcctTitle:RecAmt
    [#Line: DBTitle1]
    Add:LeftField:After: DSP VchAcctTitle:RecAmt

    [Field : RecAmt]
    set As : "Received Amt"
    Width : 10% Page
    Align : Center
    Untitled.jpg
     
    Hasan@123, Jun 5, 2020
    #1


  2. Neeru

    Neeru Active Member



    Collection missing..
     
    Neeru, Jun 5, 2020
    #2


  3. Hasan@123

    Hasan@123 Member


    What will be the collection?
     
    Hasan@123, Jun 5, 2020
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Collection will be of Bills....
    refer to the module of O/s report within tally and refer corresponding code in TDE......and then you can collect the total amount of receipt vouchers.

    Compute the value in the collection and then call for that in your column field.

    But you are adding the field in the Sales Register, so you need to compute the same in the relevant collection of the Sales register.
     
    Last edited: Jun 19, 2020
    Amit Kamdar, Jun 19, 2020
    #4
    naren1234 and Jaydeep Shah like this.


  5. Anand K

    Anand K New Member


    you need to use collection for the bills outstanding. pl check the screen upload_2020-6-27_9-24-30.png shot.
     
    Anand K, Jun 27, 2020
    #5
    Jaydeep Shah, info.ap, Adeshwar Mehta and 2 others like this.


  6. Hasan@123

    Hasan@123 Member


    can u give a hint?
     
    Hasan@123, Jun 27, 2020
    #6


  7. Rajsrisrimal

    Rajsrisrimal Member

    Rajsrisrimal, Jun 28, 2020
    #7
    Vishal Sancheti likes this.


  8. Anand K

    Anand K New Member


    Hi rajsrisrimal, please check your mail and kindly revert.
     
    Anand K, Jun 28, 2020
    #8


  9. Jeevaraajan

    Jeevaraajan New Member

    Jeevaraajan, Jun 29, 2020
    #9


  10. Adeshwar Mehta

    Adeshwar Mehta Member


    Looks to be simple from what Mr Anand has achieved.. Has anyone been able to solve this ???? it would be a great if they post how they solved it.
     
    Adeshwar Mehta, Sep 12, 2020
    #10


  11. Rupesh H

    Rupesh H New Member

    Rupesh H, Sep 23, 2020
    #11


  12. Jaydeep Shah

    Jaydeep Shah Member

    Jaydeep Shah, Dec 17, 2020
    #12


  13. info.ap

    info.ap New Member

    info.ap, Dec 17, 2020
    #13


  14. Adeshwar Mehta

    Adeshwar Mehta Member


    Hi, has anyone been able to figure out where to start?? Identified the Field as BILLC1 which i need to call.. but due to my inexperience unable to understand how to use that in Sales Register.. A starting point reference would be great to try and build on..
     
    Adeshwar Mehta, Jan 12, 2021
    #14


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You need to make a Function to extract the Values from collection of Receipt vouchers.
     
    Amit Kamdar, Jan 12, 2021
    #15
    naren1234 and Jaydeep Shah like this.


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Capture 1.PNG

    Capture 2.PNG
     
    Amit Kamdar, Jan 12, 2021
    #16
    sekharchana and Jaydeep Shah like this.


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    For PURCHASE register.........

    Capture 3.PNG

    Capture 4.PNG
     
    Amit Kamdar, Jan 12, 2021
    #17
    Vishal Sancheti and Jaydeep Shah like this.


  18. Adeshwar Mehta

    Adeshwar Mehta Member


    You have already achieved what I am trying to get..

    Unfortunately I have been going around in circles using Developer Mode by clicking the field and trying to isolate the field for a Sales Register.. Is there any mechanism where Tally In Developer Mode shows the code for a particular screen?? It only shows the field name and using search for the field name only sends us to field .. If that was there it would such an easy task to check which collection corresponds to which one.. and which part of the report corresponds to which fields so that it can be isolated and extracted.. A knowledge of coding sure helps..

    I guess even Anandji has already achieved this.. it seems simple for someone who is well versed in TDE .. Ill have to invest days to achieve what you have achieved in minutes..

    Apart from the Tally Reference Manuals.. Are you aware of any simpler and quicker manual/video to learn TDL to achieve what I am trying to achieve.. Because my requirement is limited to only this..
     
    Adeshwar Mehta, Jan 12, 2021
    #18


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I understand your point, but there is no such easy methods that comes with a full package.

    Other than the FieldName, you can put cursor in an empty space and it will give you a REPORT/FORM name. You can directly go to that report and drill down to find the Parts and Lines.... in the Lines you will find the associated Collection Name.

    When I made this TDL (dec-2019), it also took me a few months (1 hour everyday), as I am weak in functions. So perseverance pays. Initially learning is slow, but it picks up fast, once you get to understand the coding.
     
    Amit Kamdar, Jan 12, 2021
    #19
    naren1234, ankur daga, Jaydeep Shah and 1 other person like this.


  20. Jaydeep Shah

    Jaydeep Shah Member


    Can you please send me the code ??
     
    Jaydeep Shah, Jan 16, 2021
    #20


  21. Sohail Khan

    Sohail Khan Member


    Dear Amit Sir,
    Can you tell the name of the collection where the receipt is originally computed.
     
    Sohail Khan, Jan 23, 2021
    #21


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Name of the Collection already given by..........@Anand K

    I have used function to retrieve the values as that is more convenient and more efficient.
     
    Amit Kamdar, Jan 23, 2021
    #22


  23. Accoultion

    Accoultion New Member

    Accoultion, Jan 24, 2021
    #23


  24. Sohail Khan

    Sohail Khan Member


    Dear Sir,
    Below Code is giving me only the first Pending Amount how do i get according to reference Number?
    Please Help me to apply Filter.

    [Field: CollectedAmountInfo]
    Use : Amount Field
    Align : Right
    Width : @@VCHAmountWidth
    Style : small bold italic
    Set as : $ClosingBalance
    Set always : Yes
    Skip : Yes
    Invisible: Not $$IsSales:##VoucherTypeName
    Inactive:Not $$IsSales:##VoucherTypeName
    Background:RED

    [#Collection: NRM Vouchers of Company]
    Fetch : Reference,EICheckPost,BasicShipVesselNo,BasicPurchaseOrderNo,BilledQty,ActQty, ClosingBalance,BillRef,vouchernumber
    Compute:qty:$$CollQtyTotal:Inventoryentries:$BilledQty
    Compute : ClosingBalance :$$CollectionField:$ClosingBalance:1:LedgerBills
    Compute : BillRef :$$CollectionField:$Name:1:LedgerBills
    Filter :flt
    ;Compute : vch:$vouchernumber
    ;Filter:flt
    [System:Formula]
    flt:$BillRef=#DspVchNumber
     
    Sohail Khan, Jan 25, 2021
    #24


  25. Sohail Khan

    Sohail Khan Member


    [Field: CollectedAmountInfo]
    Use : Name Field
    Align : Right
    Width : @@VCHAmountWidth
    Style : small bold italic
    Set as: $$CollectionFieldByKey:$ClosingBalance:$VoucherNumber:MycollforAmount
    Set always : Yes
    Skip : Yes
    Invisible: Not $$IsSales:##VoucherTypeName
    Inactive:Not $$IsSales:##VoucherTypeName
    Background:RED

    [Collection: MycollforAmount]

    Source Collection : NRM Vouchers of Company
    ;Walk : All LedgerEntries
    Walk: Ledger Bills

    By : VoucherNumber : $VoucherNumber

    Compute : ClosingBalance : $ClosingBalance
    Compute : BillRef : $Name

    Search Key : $VoucherNumber

    Client Only : Yes
     
    Sohail Khan, Jan 30, 2021
    #25


Page 1 of 3

Share This Page