Customer wise sales report fetch emirates names

Discussion in 'Free Source Codes' started by ANAND J, Sep 15, 2019.

    
  1. ANAND J

    ANAND J Member


    Dear Admin,

    How to fetch my customer emirates names(ledger creation screen country next option emirates it’s coming) . Please check my screen shot
     

    Attached Files:



  2. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    $Ledstatename
     


  3. ANAND J

    ANAND J Member


    Not Working Dude...

    Please Create Dummy Co., Select Country is UAE after create one ledger name country after emirates its appearing in Ledger creation. I need that Emirates fetch in my report..
     

    Attached Files:



  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try this........

    $LedgerStateName:Ledger:#BWRPartyName
     


  5. ANAND J

    ANAND J Member


    Thanks a lot Group Admin & Vikram....☺☻
     


  6. 9779845157470

    9779845157470 New Member


    I try to modify Customer wise sales and purchase report .but could not work.please modify this
     

    Attached Files:



  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Also explain what the problem is and where is it? We cannot spend time fully for R & D and check out the whole TDL. Show by way of screenshot.
     


  8. 9779845157470

    9779845157470 New Member


     

    Attached Files:



  9. 9779845157470

    9779845157470 New Member


    Partywise sales and purchases had to come in different columns
     


  10. Himanshu-2002

    Himanshu-2002 Active Member


    Type This In Your Calculator

    Select * From Ledger

    And Find What you want
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In sales field --- Set as : If NOT $$IsDr:$Amount then $Amount else 0
    In Purchase field --- Set as : If $$IsDr:$Amount then $Amount else 0
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Is this the solution for each and every queries ???
     


  13. Himanshu-2002

    Himanshu-2002 Active Member


    I use this trick when I used to create simple Reports and It works every time For me But If my solution is wrong then Sorry
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Solution is not wrong, Methodology is wrong. Message panel command gives lots of unwanted things also and does not work in all cases. For new users and learners, it gets more confusing.... plus most of members are not real coders / programmers.

    Also in long run scenario fr learning TDL....... it is better to seek, search and understand directly from TDE.
     


  15. 9779845157470

    9779845157470 New Member


    It is okay to buy or sell with one party, But, buying and selling with one party it comes purchase Minus sales or sales Minus purchase. Any solution ?
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    For better MIS reporting.....it is advisable to have 2 different ledgers when you are dealing both trades --- with one single party.

    Acme Trading Co -- Drs
    Acme Trading Co -- Crs

    I have a client having one single party with whom there is Sales/Purchase as well as Consulting services. Also Sales were of 2 types - Trading & Works Contract. Also there were 2 types of Consulting having different TDS %ages. So all in all, there were 5 different ledgers each having their own criteria as per TDS and GST (goods or service).
     
    Jaydeep Shah likes this.


  17. rony

    rony Member


    Amir sir it is also possible that on sales and purchase field we put condition to fetch only those vouchers amount so in sales only sales figure will come as well in purchase only purchase figure will come. like If $$IsPurchase:$VoucherTypeName then $Amount Else 0
    Thanks
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You are referring to which Report ???
     


  19. rony

    rony Member


    Amit sir,
    I was asking for 97748 no. post of Thursday img. He wants corresponding amount in its row so refer.
    Regards
     


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Depending on your report and collection......... yes ...... you can use your formula based on voucher type to put amount in different column.

    Whereas I have not read his TDL, but from the picture -- the title is SALES REPORT (also there is no VchTyp field in that).......... So it is assumed that DR amount is DebitNote/Sales returns. So accordingly I have given him the reply...based on whether the amount is Dr or Cr.
     


Share This Page