Dear Admin, How to fetch my customer emirates names(ledger creation screen country next option emirates it’s coming) . Please check my screen shot
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..
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.
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
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
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.
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 ?
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).
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
Amit sir, I was asking for 97748 no. post of Thursday img. He wants corresponding amount in its row so refer. Regards
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.