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
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.
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.
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..
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..
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.
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.
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
[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