1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Help me to generate single report instead of below two

Discussion in 'Requests' started by Dilpesh Bhavsar, Aug 23, 2018.

    
?

One report instead of these two

  1. Hi

    0 vote(s)
    0.0%

  2. hi

    0 vote(s)
    0.0%
Multiple votes are allowed.
Page 1 of 2
  1. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    Collection for Sales Report 01 ( Shows basic sales details )

    [Collection : MySalesVouColl]
    Type : Vouchers : VoucherType
    Child of : $$VchTypeSales
    Belongs to : yes
    Fetch : Date,VoucherNumber,PartyLedgerName,_UDF_788549157,_UDF_788549158,Amount,VoucherTypeName​


    Collection for Sales Report 02 ( Shows invetory details of sales vouchers )

    [Collection : MyDetaoledSalesVouColl]
    Type : Vouchers : VoucherType
    Child of : $$VchTypeSales
    Belongs to : yes
    Fetch : Date,VoucherNumber,PartyLedgerName,_UDF_788549157,_UDF_788549158,Amount,VoucherTypeName


    [Collection : MyDetailedSalesReportColl]
    Source Collection : MyDetaoledSalesVouColl
    Walk : Inventory Entries
    Fetch : Date,VoucherNumber,StockItemName,Rate,Discount,BilledQty,Description,Inventory Entries,StockGroupName
    Fetch : BasicUserDescription.*

    ​
    I want data of above reports in single report .. please help
     

    Attached Files:

    Dilpesh Bhavsar, Aug 23, 2018
    #1


  2. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    I learnt basics of TDL through this site and it's very helpful for me and this is my first request
     
    Dilpesh Bhavsar, Aug 23, 2018
    #2


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In your report............
    for Basic Sales data....refer to collection.......[Collection : MyDetaoledSalesVouColl]
    for Inventory data......refer to collection.......[Collection : MyDetailedSalesReportColl]
     
    Amit Kamdar, Aug 23, 2018
    #3


  4. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    I want data of above reports in single report .. please help[/QUOTE]​


    --

    Dear Amitji,

    Thanks a lot. I got what i want in single report .. but one UDF of Sales Person is not shown in this report ! Please help
    ...
    [Field : MDsrSalesExe]
    Use : Name Field
    Set as : $_UDF_788549157 ;Sales Executive
    Width : 15

    ...
    [Collection : MyDetailedSalesVouColl]
    Type : Vouchers : VoucherType
    Child of : $$VchTypeSales
    Belongs to : yes

    [Collection : MyDetailedSalesReportColl]
    Source Collection : MyDetailedSalesVouColl
    Walk : Inventory Entries
    Fetch : Date,VoucherTypeName,VoucherNumber,_UDF_788549157,PartyLedgerName,StockItemName,Rate,Discount,BilledQty,Description,Inventory Entries,StockGroupName
    Fetch : BasicUserDescription.*​
     

    Attached Files:

    Dilpesh Bhavsar, Aug 23, 2018
    #4


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    ratify this UDF in [#Object:Ledger]
     
    Amit Kamdar, Aug 23, 2018
    #5


  6. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    Sorry, i dont know what you are trying to say, please explain or give me some hint
    Thanks in advance..
     
    Dilpesh Bhavsar, Aug 23, 2018
    #6


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Object:Ledger]
    _UDF_788549157 : $_UDF_788549157
     
    Amit Kamdar, Aug 23, 2018
    #7


  8. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    It is not working.

    But, my UDF is working fine in TestSale.txt report , I am attaching both TDLs. Please check and revert.
     

    Attached Files:

    Dilpesh Bhavsar, Aug 23, 2018
    #8


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    What is _UDF_788549157 and _UDF_788549158 ???? user defined?? or from default tally?
     
    Amit Kamdar, Aug 23, 2018
    #9


  10. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    Boths are User Defined...

    _UDF_788549157 >> used to store value of SALES EXECUTIVE while voucher entry.
    _UDF_788549158 >> used to store CUSTOMER REFERENCE while voucher entry.
     
    Dilpesh Bhavsar, Aug 23, 2018
    #10


  11. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    System: UDF]

    _UDF_788549157 : String: 20004 ;SaleExe
    _UDF_788549158 : String: 20005 ;SaleRef
     
    Dilpesh Bhavsar, Aug 23, 2018
    #11


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    in your collection....put

    Compute : _UDF_788549157 : $_UDF_788549157
     
    Amit Kamdar, Aug 23, 2018
    #12


  13. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    Not working.. now it is not showing from TestSales.txt ??
     
    Dilpesh Bhavsar, Aug 23, 2018
    #13


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    also put
    [#Object : LedgerEntry]
    _UDF_788549157 : $_UDF_788549157
     
    Amit Kamdar, Aug 23, 2018
    #14


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Remove........_ [#Object : Ledger]

    You need to WALK ledger entries too.... is this field part of Inventory or Accounting entry?
     
    Amit Kamdar, Aug 23, 2018
    #15


  16. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    Not working

    _UDF_788549157 (Sales Exe) not showing in both reports.
     
    Dilpesh Bhavsar, Aug 23, 2018
    #16


  17. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    It's a part of account entry only.
     
    Dilpesh Bhavsar, Aug 23, 2018
    #17


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    walk : allledgerentries, allinventoryentries
     
    Amit Kamdar, Aug 23, 2018
    #18


  19. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    not working
     
    Dilpesh Bhavsar, Aug 23, 2018
    #19


  20. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    but why it is not showing in first report TestSales.txt which is fine and working also not MODIFIED today ?
     
    Dilpesh Bhavsar, Aug 23, 2018
    #20


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Just by opening mouth wide and sticking out tongue....will not result in proper diagnosis by doctor. You need to tell the Doctor your symptoms too..

    Same way....i do not have your data nor your complete TDL....so at best I can share just snippets of other steps............or alternative steps.
     
    Amit Kamdar, Aug 23, 2018
    #21
    Jaydeep Shah likes this.


  22. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    OK.. I understand. :(
    find attached complete TDL.. which i have made with the help of sample codes from this site. With lots of trial and error but finally It is fully working as per my requirement.

    Thanks again to members like your and also of course to The Admin :)
     

    Attached Files:

    Dilpesh Bhavsar, Aug 23, 2018
    #22


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You have made these 3 collections

    [Collection: MyDebtorsLedTableBillMadeBy]
    Type : Ledger
    Child Of : "BillMadeBy"
    Fetch : Name
    Format : $Name, 15
    Title : $$LocaleString:"Made By"
    [Collection: MyDebtorsLedTableSaleRef]
    Type : Ledger
    Child Of : "Reference"
    Fetch : Name
    Format : $Name, 25
    Title : $$LocaleString:"Reference"

    [Collection: MyDebtorsLedTableSalesman]
    Type : Ledger
    Child Of : "Sales Executive"
    Fetch : Name
    Format : $Name, 15
    Title : $$LocaleString:"Salesname"

    Does it means all ledgers have to opened under respective group like "sales executive" etc ???
     
    Amit Kamdar, Aug 23, 2018
    #23


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I think this is wrong way of doing things.... what exactly are you making out or trying to from your TDL???
     
    Amit Kamdar, Aug 23, 2018
    #24


  25. Dilpesh Bhavsar

    Dilpesh Bhavsar New Member


    OK, first of all , I am not a professional programmer. But, let me explain my TDL with my requirement.

    I have made this TDL to enter/select Sales Person and Sales Reference while making Sales Invoice. I also configured both the fields in Bill Wise Outstanding report as we required outstanding by each sales person separately.

    Further, with my TestSales2.txt TDL I want total sales report with all inventory details and these two fileds, which i can export in excel or access to generate few reports.
     
    Dilpesh Bhavsar, Aug 24, 2018
    #25


Page 1 of 2

Share This Page