2022 best Paid and Pending Bill Details in One Sheet : Tally Prime TDL | Best Tally TDL for Bill Outstanding Detail

In business, it is often necessary to keep track of outstanding payments in order to manage cash flow. An outstanding payments report shows all of the money that a company owes to its suppliers, employees, and other creditors.

When we use Tally for accounting and want to create separate reports with Paid and Pending Bill Details, then without TDL file it is not possible in Tally. With this best Tally TDL for Bill Outstanding Detail TDL we can create outstanding payments or receipt report separately, that can be customized to show the information as per our need.

This is the best Tally Prime and Tally ERP9 TDL to see paid bills and pending bills details at one place.

Paid and Pending Bill details

Also get TDL to modify Bill wise details

Tally TDL to add Paid and Pending Bill Details – Code:

This TDL code may be changed to suit our needs. Perfectly working with Tally Erp9 and Tally Prime, and we may add or delete other fields as needed. The best simple TDL code to modify bill billwise details of Tally.

[Collection:LearnwellBillsColl]
	Type:Bill
	Child Of:$$GroupSundryDebtors or $$GroupSundryCreditors
	Belongs To:Yes	
	Cleared:Yes
[Collection:LearnwellBillsColl2]
	Type:Bill
	Child Of:$$GroupSundryDebtors or $$GroupSundryCreditors
	Belongs To:Yes	
	Cleared:No

[#Form:Bills Outstanding]
	Add:Button:LearnwellBills
	
[Button:LearnwellBills]
	Title:$$LocaleString:"Paid Pending Bills"
	Key:CTRL+W
	Action:Display:LearnwellPaidBills
	
[Report:LearnwellPaidBills]
	Variable:SVfromDate,SvToDate
	Set:SVfromDate:##SVdate
	Set:SVtoDate:##SVCurrentDate
	Form:LwBILLS
	
[Form:LwBILLS]
	Button:PrintButton,ExportButton,ChangePeriod
	Height:100 % page
	Width:100 % page
	Background:White
	Part:LWBills
[Part:LWBills]
	Part:PaidBills,PendingBills
	
[Part:PaidBills]
	Line:LWBillsTitle,LWBillsDetail
	Repeat:LWBillsDetail:LearnwellBillsColl
	Border:Thin box
	Scroll:Both
	Float:Yes
[Line:LWBillsTitle]
	Field:LWBillDate,LWBillRef,LWBillLedger,LWBillAmt
	
[Field:LWBillDate]
	Use:Name Field
	Set as:"Date"
	Style:Normal bold

[Field:LWBillRef]
	Use:Name Field
	Set as:"References"
[Field:LWBillLedger]
	Use:Name Field
	Set as:"Party Ledger"
	Style:Normal bold
[Field:LWBillAmt]
	Use:Name Field
	Set as:"Paid Amount"
	Style:Normal bold
	
[Line:LWBillsDetail]
	Field:LWBillD,LWRefD,LWPartyD,LWAmtD
[Field:LWBillD]
	Use:UniDateField
	Set as:$BillDate
	Style:Normal Bold
	Border:Thin right
[Field:LWRefD]
	Use:ShortName Field
	Set as:$Name
	Style:Normal
	Border:Thin right
[Field:LWPartyD]
	Use:Name Field
	Set as:$DSPACCName:Ledger:$Parent
	Style:Normal Bold
	Border:Thin right
[Field:LWAmtD]
	Use:Amount Field
	Set as:$OpeningBalance
	Style:Normal Bold
	Border:Thin right



[Part:PendingBills]
	Line:LWBillsTitle2,LWBillsDetail2
	Repeat:LWBillsDetail2:LearnwellBillsColl2
	Border:Thin box
	Scroll:Both
	Float:Yes
[Line:LWBillsTitle2]
	Field:LWBillDate2,LWBillRef2,LWBillLedger2,LWBillAmt2,LWBillAmt3
	
[Field:LWBillDate2]
	Use:Name Field
	Set as:"Date"
	Style:Normal bold

[Field:LWBillRef2]
	Use:Name Field
	Set as:"References"
[Field:LWBillLedger2]
	Use:Name Field
	Set as:"Party Ledger"
	Style:Normal bold
[Field:LWBillAmt2]
	Use:Name Field
	Set as:"Opening Amount"
	Style:Normal bold
[Field:LWBillAmt3]
	Use:Name Field
	Set as:"Closing Amount"
	Style:Normal bold
[Line:LWBillsDetail2]
	Field:LWBillD2,LWRefD2,LWPartyD2,LWAmtD2,LWAmtD3
[Field:LWBillD2]
	Use:UniDateField
	Set as:$BillDate
	Style:Normal Bold
	Border:Thin right
[Field:LWRefD2]
	Use:ShortName Field
	Set as:$Name
	Style:Normal
	Border:Thin right
[Field:LWPartyD2]
	Use:Name Field
	Set as:$DSPACCName:Ledger:$Parent
	Style:Normal Bold
	Border:Thin right
[Field:LWAmtD2]
	Use:Amount Field
	Set as:$OpeningBalance
	Style:Normal Bold
	Border:Thin right
[Field:LWAmtD3]
	Use:Amount Field
	Set as:$ClosingBalance
	Style:Normal Bold
	Border:Thin right

How to use Best Tally TDL for Bill Outstanding Detail TDL code:

HOW TO USE TDL CODE:
  • Copy above TDL code and make a text file.
  • Save text file then load in Tally Prime (Method provided below the code)
  • Now go in billwise details section of ledger, Here you will find Paid and Pending Bills button.
  • After clicking on Paid and Pending Bills button you can see paid bill and pending bills details.

This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime.

How to see paid bill details and pending bill details in Tally video:

Watch above video to learn :

  • How to create TDL file.
  • How to modify bill details section of Tally prime.
  • More TDL files on youtube/learnwell
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Paid Pending Bill details.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your paid bill details and pending bill details TDL is ready to use.

Leave a Comment