Block Invoicing After Credit Day Overdue Free Tally TDL

As we all know that Tally.ERP9 software as the functionality of setting up Credit days and Credit based on Amount in Ledger Master but does not block billing even if Credit days are over due.

Below Code will help you in blocking the billing if any bill is overdue of a particular customer. 

;;;;; In below code we have found the field were we want our code to check and block the entry and have applied the 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 

Common Troubleshooting....

1. After attaching the code to Tally ( http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html ) it is blocking all the invoice even if credit period is not over ?

Answer:- Go to Display-> Statement of Accounts-> Outstanding-> Select Ledger for which you are facing issue-> and check that there is not no of days in overdue column.