Dear Experts Please guide me how to search following from this web ? http://tdlexperts.com/index.php?threads/two-company-vouchers-combined-daybook.3593/#post-8831 Please reply.
http://tdlexpert.com/index.php?threads/two-company-vouchers-combined-daybook.3593/#post-8831 Is this what you wanted? link is modified click on it and it will open your thread now.
BTW...this is a basic report..............good for learning and enhancing it further................. I've done it.......... it was one of my earliest TDL......... enhaced it with search facility and also other details in the Daybook.
That's Great Amitji Thank you. I am unable to find given reference link in any thread that's why I ask. How to know Post Number & search by Post Number in forum. Please reply.
There is no way to know this............you got to search line by line............in the various forums.
This I had abandoned in Aug-2018, as was busy with other projects. Two things are pending. 1. Filtering on Amount ........... greater than and lesser than............ 2. Explode Part.........majority (75%+) is completed, but yet to finish. Maybe will take this when I get some free time......... It is 7-8 months old, so the quality will not be upto mark. Photos attached below............
As i recollect ----- All my formulas for greater than and lesser than was unsuccessful. Can anyone give me idea on how to filter on between two amounts ????
Future plans include..... adding to Search Filter (after explode module is finished) Search on a. Narration b. Cost Centre c. StockItem d. StockItem description e. Bank Details (Bank name & Cheque #) f. Bill Reference
@Amit Kamdar ji.. Since you have worked on this type of report needed a hint from you regarding a problem with the multi company report. I am trying to fetch Mobile no for one of my reports, a part of the code is as below. So it is fetching the Mobile number but only of those ledgers that are part of the company which is selected when the report is generated. It if not picking the mobile number of the ledger from the owner company of the voucher. Can you guide me in the right direction to be able to fetch it from the ledger to which that voucher belongs. 2) Also there are 2 udfs in the ledger master , if i try the same way the UDFs done get fetched. Any help in this regard would be highly helpful ( Off topic : Thanks to your guidance I have been able to create 6 TDLS to suit my business needs. Salesman TDL in Ledger, Multicompany Report TDL, Pending Amount TDL, Sales Data Export with UDF etc ) [Part: MultiCmpDBPart] Lines : MultiCmpDBLnTitle, MultiCmpDBLnDetails Repeat : MultiCmpDBLnDetails: Vouchers of Multiple Companies Total : invAmount Scroll : Vertical [Field : MultiCmpOwnerCmpName] Use : Name Field Set as : $OwnerCompany Alter : Voucher Variable : SVCurrentCompany Modifies : SVCurrentCompany Invisible: Yes [Field : MParty] use : Name Field set as : $Name [Field : MMob] set as : $LedgerMobile:Ledger:#Mparty [Collection: Vouchers of Multiple Companies] Collection : MultiCmpDB VchCollection : Company Collection Sort : Default : $date, $VoucherNumber [Collection: MultiCmpDB VchCollection] Type : Voucher Filter : Issale Fetch : Date, Vouchernumber, VoucherTypeName, Amount, MasterID, LedgerName, Ledgermobile Compute : Owner Company : $$LoopCollObj:$Name [Collection: Company Collection] Type : Company Fetch : Name [System : Formula] Issale : $$IsSales:$vouchertypename ChkParty : $PartyLedgername
Actually it might be fetching, but not able to get the Mobile Number........... because the LedgerName is not found......... Study the "Vouchers of Ledger" collections ...... therein they have computed the LedgerName i.e. IsPartyLedger or Firstledger ........which contains the MobileNumber data... As a point of reference -- when you go any party ledger ---- you see the next Dr/Cr ledger name but not the Party name .... and hence it is not picking up.
Make another field next to [Field : MultiCmpOwnerCmpName] --- for LedgerName to check if the Owner LedgerName is coming and not the Entry's ledgername. Once the correct name appears, you hide that field and use it --- $LedgerMobile:Ledger:#OwnerpartyFld
[Field : MultiCmpOwnerCmpName] -- what reply you getting in this field ? the correct co name?? [Field : MParty] -- what reply u getting here?? the correct ledgername (Owner) or the voucher entry's next edger name as it appears in ledgerdisplay??
have added the screenshots.. Pls see the difference of number 4 in walkin cash ledger.. It shows 4 when SM is selected as the company becoz it is stored as 4 in that company but it is blank when ED is selected (same ledger name in both, if ledger name matches in both you get the number retrieved which is stored in the company that is selected)
That might be due to the Collection structure .................... there is a difference between opening multiple companies and having a group company. You can hare the code on nehalsofttech@gmail.com ........ also send dummy data for the above 2 companies .......... delete the rest of the vouchers, but retain only those that is needed for the above Report. Due to coming diwali and tight schedules..... i will need some time to look into it. So kindly keep patience. I too have a few backlogs queries of other members.
Will send once splitting the company is done.. it has 5 years data so splitting and deleted unwanted entries is taking forever.. Will mail you the TDL also along with that.. Do you think something in this post will help ?? http://tdlexpert.com/index.php?threads/group-company-outstanding-parent-name-not-fetched.11156/
If you are able to get the OWNER of ledger, then yes......... But your requirement and in connection with your data set and the collections you have made, the picture is not yet clear in my min, regarding your needs. Once i get the data and ur code I will understand it better.
Well what do you know.. It Got Solved. I achieved what I wanted to achieve. And your own old post helped me solve it. Used that method and got it working for Mobile No. For my UDF One Mistake I was doing is there is a TDL that activates the UDF and I was not using it to test this TDL Individually assuming that once that data is saved in the ledger it will remain there. Mistake. There is just one more thing preventing me from completing it. I have a sort on the UDF for the report and it is working. My requirement is I want the UDF to be shown in Display ( It is Showing) but I dont want it to Print .. Can the field be hidden in print ???
