नमस्कार दोस्तों आज हम एक ऐसे tdl फाइल के बारे में चर्चा करेंगे ,जिसकी मदद से आप अपने Tally Prime में credit limit के आधार पर credit control कर सकते है । This TDL does not allow the user to enter another sales entry for the same customer, if the credit days are due. तो चलिए देखते हैं कि हम कैसे उपयोग कर सकते हैं इस tdl फ़ाइल का tally prime में ?
TDL code For Credit Control
[#Field: EI Consignee]
Control : CtrlCreditDays : @@ChkCreditDays>0 and $$InCreateMode and $$IsSales:##SVVoucherType
[Collection: Credit PartyPending Bills]
Type : Bills
Child of : #EIConsignee
Unique : $$Name
Format : @@DateDiff
Format : $BillDate, 8 : Universal Date
Format : $$Name, 10
Format : $BaseClosing,-30 : "AllSymbols, DrCr"
Format : @@DueDate
Format : ##SVCurrentDate
Filter : FltrCreditDays, FltrCrAmt
[System : Formula]
CtrlCreditDays : if @@ChkCreditDays = 1 then "The Customer has " + $$NewLine + $$String:@@ChkCreditDays + $$NewLine + " Bill OverDue." else "The Customer has " + $$NewLine + $$String:@@ChkCreditDays + $$NewLine + " Bills OverDue."
ChkCreditDays : $$Numitems:CreditPartyPendingBills
FltrCreditDays : $$Number:@@DateDiff>=1
DueDate : $$Date:$$String:$BillCreditPeriod:UniversalDate
DateDiff : ##SVCurrentDate - @@DueDate
FltrCrAmt : $$IsDr:$BaseClosing
;;---------------------------------------------------------------
;;---------------------------------------------------------------
;;E.O.F.
Step 2: अब above code को Save करने के बाद Tally Prime पर TDL File अपलोड करें ( और अगर आपको Tally Prime पर TDL File upload करने का तरीका नहीं पता है तो नीचे दिए गए Link पर Click करें जो आपको Tally Prime पर TDL File अपलोड करने के लिए Guide करेगा )
Step 3: Select Ledger from Create from Gateway of Tally>then Create New Ledger > Press F12 and Enable the ‘Provide Credit Limits’ as “Yes”
Step 4: Create a Ledger under Sundry Debtors and set the Default Credit Period and
Set Credit Limit as shown below:
Step 5: Enter a Sales Invoice. Go to Gateway of Tally > Vouchers >Press F8.
Step 6: Pass the Sales Invoice once again after credit days as shown, When you are trying to enter the sales voucher for the same party, it will not allow you to enter further. If you have selected the same party then the message
appears as shown:
और इस तरह से आप Tally prime में Credit control कर सकते है ।
धन्यवाद दोस्तों! अगर आपको ये आर्टिक्ल पसंद आया हैं तो इसको सोशल मीडिया पर अपने दोस्तो के साथ जरूर से शेयर कीजिए, जिससे उनको भी ये जानकारी प्राप्त हो सके।
Download Button पर Click कर के फ़ाइल डाउनलोड करें
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
Dear Sir
Credit control days k hisab se karna he. uss k liye app k pass koi TDL he.
we want to block sales invoices, If customer due more then 45 days. amount any