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.
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:
- Make a Text file of above code
- Save it in to your computer
- Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Paid Pending Bill details.txt)
- Open Tally Prime Software
- Click on Help and click on TDL & Addon (for Tally Prime)
- Press F4 (to open a Box)
- Set Load TDL file on Startup – Yes
- Paste The path in blank space
- Press enter and save
- Now your paid bill details and pending bill details TDL is ready to use.
DEAR SIR I WANT ADD FEILD IN Paid Pending Bill details.TXT FILE VOUCHER NUMBER.