Breaking

EXCEL TO TALLY - AUTOMATION 10.0 | BEST EXCEL TO TALLY DATA TRANSFER UTILITY | EXCEL TO TALLY PRIME IMPORT | EXCEL TO TALLY ERP9 IMPORT

This is Excel to Tally Automationto automate your Data Entry with Tally. It is very helpful to import Excel Datainto Tally, easy and quickly...

Friday, 15 May 2020

Daily Collection TDL - Tally Prime TDL 2021



WITH THIS TALLY ERP9 TDL YOU CAN SEE DAILY SALES, DAILY PURCHASE AMOUNT , CONTACT NO. AND CONTACT PERSON AT INVOICE TIME AND CONTACT DETAILS AND GST NUMBER IN LEDGER ACCOUNT.
IT WILL BE VERY HELPFUL TO SEE DAILY BUSINESS AND OUTSTANDING COLLECTION


[#Line : LV Title]
Add : Field : After : LEDMailName : LWContGST

[Field : LWContGST]
Use : Name Field
Set as : $$String:"Contacts: " + $$LocaleString:($ledgermobile:Ledger:##LedgerName)+ " " + $$LocaleString:($LedgerContact:Ledger:##LedgerName) +" - Gstin: " + $$LocaleString:($Partygstin:Ledger:##LedgerName)
Color : Red
Width:50
Background:Light yellow

[#Line: EI PartyLimit]

Add : Field : After : EI CurrentBalance : TotSales 

[Field : TotSales]

Invisible : NOT ##CurBalanceFlag or NOT @@IsSales
Field : Simple Prompt, Amount Field
Local : Field : Simple Prompt : Info : $$LocaleString:"Today'sTotal Sale:"
Local : Field : Simple Prompt : Width : 14
Local : Field : Amount Field : Set as : @@TrsTotSales
Local : Field : Amount Field : Format : "Symbol,DrCr"
Local : Field : Amount Field : Set always : Yes
Local : Field : Amount Field : Color : Blue

[System : Formula]

TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales 

 ;;..........www.Learnwells.com.........;;


[#Line: EI PartyLimit]

Add : Field : After : EI CurrentBalance : TotPurch 

[Field : TotPurch]

Invisible : NOT ##CurBalanceFlag or NOT @@IsPurchase
Field : Simple Prompt, Amount Field
Local : Field : Simple Prompt : Info : $$LocaleString:"Today's Total Purchase:"
Local : Field : Simple Prompt : Width : 14
Local : Field : Amount Field : Set as : @@TrsTotPurch
Local : Field : Amount Field : Format : "Symbol,DrCr"
Local : Field : Amount Field : Set always : Yes
Local : Field : Amount Field : Color : Blue

;;..........www.Learnwells.com.........;;

[System : Formula]

TrsTotPurch : $$FromValue:$Date:$$ToValue:$Date:$DebitTotals:Group:$$GroupPurchase 


[#Line: EI PartyLimit]

Add : Field : After : EI CreditLimit : LWContact

[Field : LWContact]
Invisible : NOT ##CurBalanceFlag 
Field : Simple Prompt, Name Field
Local : Field : Simple Prompt : Info : $$LocaleString:"Contacts:"
Local : Field : name Field : Set as : $LedgerMobile:Ledger:#EIConsignee  + " " + $LedgerContact:Ledger:#EIConsignee 


;;..........www.Learnwells.com.........;;

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as - C:\Users\HP\Desktop\rec\Party Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup - Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.


No comments:

Post a Comment