Tally DeveloperA comprehensive resource forum of Tally Developer - The Development Platform of Tally.ERP 9.Sat, 25 May 2019 16:10:33 +0000Sat, 25 May 2019 16:10:33 +0000TDLeXperts-World's first online TDL (Tally Definition Language) communityhttp://tdlexpert.com/index.php?forums/tally-developer.7/
Problem in interting part at bottom of the invoiceSat, 25 May 2019 10:11:22 +0000http://tdlexpert.com/index.php?threads/problem-in-interting-part-at-bottom-of-the-invoice.6653/
http://tdlexpert.com/index.php?threads/problem-in-interting-part-at-bottom-of-the-invoice.6653/invalid@example.com (surendra19)surendra19
I am trying to insert a Part at the bottom of the the invoice after the part EXPINV InvoiceCompGen, but the Part is inserted before total of Invoice.

Problem in interting part at bottom of the invoice]]>3Tips / Logic for UDF storageSat, 25 May 2019 07:24:23 +0000http://tdlexpert.com/index.php?threads/tips-logic-for-udf-storage.6665/
http://tdlexpert.com/index.php?threads/tips-logic-for-udf-storage.6665/invalid@example.com (Gangadhar C Beldar)Gangadhar C Beldar
Now, the problem is that "When Ledger Name is changed/Altered in SM Group", The data stored in the UDF of are "Previously stored/Entries are have old Values of Ledger Name".

Help me in a collection]]>1Customized Voucher Entry ScreenFri, 24 May 2019 12:21:05 +0000http://tdlexpert.com/index.php?threads/customized-voucher-entry-screen.6655/
http://tdlexpert.com/index.php?threads/customized-voucher-entry-screen.6655/invalid@example.com (NiravMerchant)NiravMerchant
I have written tdl to have customized stock entry Screen - Not the tally default one.

it is like user needs a simple screen where they just enter date, customer party name ( using as godown name ) whether it is inward or outward movement and item details once done and user saves the screen it will generate stock jv automatically.

but when i try to save the screen it says No entries in Voucher.

Please find following is the screen shot of entry and sample code of the same...

Customized Voucher Entry Screen]]>6TDLeXperts forum rulesFri, 24 May 2019 10:16:57 +0000http://tdlexpert.com/index.php?threads/tdlexperts-forum-rules.6650/
http://tdlexpert.com/index.php?threads/tdlexperts-forum-rules.6650/invalid@example.com (Amit Kamdar)Amit KamdarNOTICE: The Moderators/Administrators of this forum take no responsibility or liability for anything that happens as a result of reading and/or downloading anything from this forum. TDLeXperts staff reserves the right to edit/modify/remove any post at any time with or without notice.

The only language allowed is English

Topics posted in the wrong section may be removed

Bypassing our word censor is strictly forbidden...

TDLeXperts forum rules]]>1Tally 18 DEMO......Thu, 23 May 2019 17:34:07 +0000http://tdlexpert.com/index.php?threads/tally-18-demo.6474/
http://tdlexpert.com/index.php?threads/tally-18-demo.6474/invalid@example.com (Amit Kamdar)Amit Kamdar
]]>43Cannot Geting value of UNIT OF ITEMWed, 22 May 2019 09:28:12 +0000http://tdlexpert.com/index.php?threads/cannot-geting-value-of-unit-of-item.6644/
http://tdlexpert.com/index.php?threads/cannot-geting-value-of-unit-of-item.6644/invalid@example.com (Partha Mondal)Partha Mondal
I customized Sales Voucher report. But I cannot getting the value of UNIT.
I use < Local:Field:UOM:Set as:$$Value:$BaseUnits >
And also I want in Quantity Field show only Quantity not with UNIT

View attachment 5207]]>3Sales Voucher Customization Print SettingsWed, 22 May 2019 02:52:43 +0000http://tdlexpert.com/index.php?threads/sales-voucher-customization-print-settings.6383/
http://tdlexpert.com/index.php?threads/sales-voucher-customization-print-settings.6383/invalid@example.com (Sumit8158)Sumit8158
I have done sales voucher customization but in printing there is a error.
1. Two borders appear in MRP column. Please see the attachment. This border appears if quantity column is set to yes.
But if quantity column is set to no OR MRP and Discount Columns are set to no print preview is just fine.]]>13Cash Balance in Day book....Mon, 20 May 2019 08:04:58 +0000http://tdlexpert.com/index.php?threads/cash-balance-in-day-book.6632/
http://tdlexpert.com/index.php?threads/cash-balance-in-day-book.6632/invalid@example.com (Ganesh01)Ganesh01
I Make an Report Like Day book with Cash balance. But, cash balance not coming correctly. Because, It adding the amount instead of subtracting the amount in payment & Receipt voucher type. please correct my formula. I attached the cash running balance formula & screenshots.

[Field: ClAmount]

Use : Amount Field
Set as : If ($$Line = 1) Then If (##DSPWithOpening) Then @NettOpBal Else +...

View attachment 4047]]>14fetch discount value from sales voucher in coloumnar reportSun, 19 May 2019 06:59:10 +0000http://tdlexpert.com/index.php?threads/fetch-discount-value-from-sales-voucher-in-coloumnar-report.6290/
http://tdlexpert.com/index.php?threads/fetch-discount-value-from-sales-voucher-in-coloumnar-report.6290/invalid@example.com (puzzle)puzzle
how can i fetch the values of discount in the columnar report from the sale voucher corresponding to item.?]]>3Print Godown Name in DayBook. Okay in Display Mode Problem in Printing.Sat, 18 May 2019 19:09:34 +0000http://tdlexpert.com/index.php?threads/print-godown-name-in-daybook-okay-in-display-mode-problem-in-printing.6628/
http://tdlexpert.com/index.php?threads/print-godown-name-in-daybook-okay-in-display-mode-problem-in-printing.6628/invalid@example.com (zakirhossain_diu)zakirhossain_diu
I am getting out put of Godown Name in Display Mode of DayBook. But Its Not taking Printed !!

Use : Amount Field
Set as : If ($$Line = 1) Then If (##DSPWithOpening) Then @NettOpBal Else +
@NettDrCrTotal Else...

Running Balance Not coming correctly......]]>HSN CodexMon, 13 May 2019 09:19:20 +0000http://tdlexpert.com/index.php?threads/hsn-codex.6594/
http://tdlexpert.com/index.php?threads/hsn-codex.6594/invalid@example.com (Amit Kamdar)Amit Kamdar
I have list of 18430 items. Is this the full list??? Anyone has a full list in Excel format?

Once list is complete in all respects, it will be available during selection of HSN Code & Description as a ready reckoner.

Customised Auto Delivery Challan]]>9Video of TDL demo.....Sun, 12 May 2019 11:29:44 +0000http://tdlexpert.com/index.php?threads/video-of-tdl-demo.6496/
http://tdlexpert.com/index.php?threads/video-of-tdl-demo.6496/invalid@example.com (Amit Kamdar)Amit KamdarAnybody has any idea what app is used to make TDL videos as you see on the youtube etc???]]>5LPO number in outstanding report TDLSat, 11 May 2019 07:19:22 +0000http://tdlexpert.com/index.php?threads/lpo-number-in-outstanding-report-tdl.2586/
http://tdlexpert.com/index.php?threads/lpo-number-in-outstanding-report-tdl.2586/invalid@example.com (ahmed rishali)ahmed rishali

LPO number in outstanding report TDL]]>10Payroll calculation in tally on hours basisThu, 09 May 2019 10:18:12 +0000http://tdlexpert.com/index.php?threads/payroll-calculation-in-tally-on-hours-basis.6587/
http://tdlexpert.com/index.php?threads/payroll-calculation-in-tally-on-hours-basis.6587/invalid@example.com (Sushma)Sushma
I am reading working hours of employees on daily basis from sql server. on week off, holiday, and leave days there is no hours recorded in sql server. so now I want to configure week off, holiday, and leave details of employee on tally.

please help me.

Thanks and Regards,
sushma A Jainar]]>2Help on Sort command not working in "Pending Bills Collection" (Bill Wise Collection)Wed, 08 May 2019 07:33:12 +0000http://tdlexpert.com/index.php?threads/help-on-sort-command-not-working-in-pending-bills-collection-bill-wise-collection.6574/
http://tdlexpert.com/index.php?threads/help-on-sort-command-not-working-in-pending-bills-collection-bill-wise-collection.6574/invalid@example.com (kishan_raval)kishan_raval
I want closing balance wise sorting, i have added the sort command but nothing happened, even i tried with $BillDate wise & $$Name wise also, they all not working,
please help, thanks in advance
the code is below

Help on Sort command not working in "Pending Bills Collection" (Bill Wise Collection)]]>10Data not showing in my reportMon, 06 May 2019 05:51:55 +0000http://tdlexpert.com/index.php?threads/data-not-showing-in-my-report.6579/
http://tdlexpert.com/index.php?threads/data-not-showing-in-my-report.6579/invalid@example.com (Partha Mondal)Partha Mondal
Can anybody help me on create this customised delivery challan. I already create but not getting value from voucher in print mode. Voucher No. & Date is show when sub form open but not shown in print mode.

I attach my code.]]>2Receipt Amount (Solved)Sun, 05 May 2019 04:23:20 +0000http://tdlexpert.com/index.php?threads/receipt-amount-solved.6572/
http://tdlexpert.com/index.php?threads/receipt-amount-solved.6572/invalid@example.com (lumos)lumosView attachment 5049
I can't get the receipt amount total right I have used the following code but cant fetch the collection totals just like the sales totals.
Experts please tell me what I am doing wrong here. The sales amount total worked but receipt does not.

Changing Date Format in TDL]]>25Load TDL only when condition is satisfied.Thu, 02 May 2019 14:02:30 +0000http://tdlexpert.com/index.php?threads/load-tdl-only-when-condition-is-satisfied.6571/
http://tdlexpert.com/index.php?threads/load-tdl-only-when-condition-is-satisfied.6571/invalid@example.com (Shreyansh Jindal)Shreyansh Jindal
Is there a way that TDL is loaded only when sepcified conditions are true.
I don't want to set condition in each specific parts.]]>2change period buttonTue, 30 Apr 2019 17:48:18 +0000http://tdlexpert.com/index.php?threads/change-period-button.6509/
http://tdlexpert.com/index.php?threads/change-period-button.6509/invalid@example.com (kosi)kosi
How will i prevent change period button from affecting a field value if u pulled a customizes report with a date range
Thanks]]>8Excel importTue, 30 Apr 2019 11:36:51 +0000http://tdlexpert.com/index.php?threads/excel-import.6164/
http://tdlexpert.com/index.php?threads/excel-import.6164/invalid@example.com (Lynch)Lynch
the following is the code for importing I'm using.

Excel import]]>7Job Required: I need help with customized reportsFri, 26 Apr 2019 19:31:51 +0000http://tdlexpert.com/index.php?threads/job-required-i-need-help-with-customized-reports.6556/
http://tdlexpert.com/index.php?threads/job-required-i-need-help-with-customized-reports.6556/invalid@example.com (Ali ND)Ali ND
I need a TDL that would export different reports at once. Examples of reports: Day Book, Cash/Bank Book(s), Outstanding Bills for a Particular Group.
I don't mind if this can be accomplished differently by importing Tally data directly into Excel through VBA (ODBC); actually, I prefer this if it is possible.
Could you please message me if you are interested in developing this TDL?
Many thanks in advance]]>help on customised invoiceFri, 26 Apr 2019 16:36:02 +0000http://tdlexpert.com/index.php?threads/help-on-customised-invoice.6549/
http://tdlexpert.com/index.php?threads/help-on-customised-invoice.6549/invalid@example.com (Johar)Johar
I have created two different invoice but there is problem it shows below ERROR --
[Form : AComInv]
No Parts

View attachment 4575]]>1Can I change default field title nameThu, 25 Apr 2019 15:30:37 +0000http://tdlexpert.com/index.php?threads/can-i-change-default-field-title-name.6551/
http://tdlexpert.com/index.php?threads/can-i-change-default-field-title-name.6551/invalid@example.com (Partha Mondal)Partha Mondal
I am new in TDL. How can I change the field title name in sales voucher. Like "Party A/c Name" to
"Customer Name "
Please tell me sir is it possible.
Please anybody help me.

Partha Mondal]]>3Month Wise Cash Receipts and bank Receipts seperatelyThu, 25 Apr 2019 10:17:44 +0000http://tdlexpert.com/index.php?threads/month-wise-cash-receipts-and-bank-receipts-seperately.6541/
http://tdlexpert.com/index.php?threads/month-wise-cash-receipts-and-bank-receipts-seperately.6541/invalid@example.com (Varadha)Varadha
I am Trying to generate a report which should show month wise Cash receipt Total and bank receipt total.
i could able to get months but i am unable to get Total of Cash Receipts Month wise. I am attaching my code and also my desired report picture for your observation and necessary suggestions.
Thanks in advance]]>4