Credit Control on Days (Free Source Code)

Discussion in 'Tally Developer' started by Maulik Patel, Nov 27, 2013.

    
  1. Maulik Patel

    Maulik Patel Active Member


    ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara


    [#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:mad:@ChkCreditDays + $$NewLine + " Bill OverDue." else "The Customer has " + $$NewLine + $$String:mad:@ChkCreditDays + $$NewLine + " Bills OverDue."
    ChkCreditDays : $$Numitems:CreditPartyPendingBills
    FltrCreditDays : $$Number:mad:@DateDiff>=1
    DueDate : $$Date:$$String:$BillCreditPeriod:UniversalDate
    DateDiff : ##SVCurrentDate - @@DueDate
    FltrCrAmt : $$IsDr:$BaseClosing

    ;;---------------------------------------------------------------------------------------------------
    [#Menu: Ledgers]

    Delete : Item : @@locCreditLimits
    Delete : Item : BLANK
    Add : Item : @@locCreditLimits :Alter Collection :Multi Ledger Limit :$$NumLedgers> 0 AND $$Allow:Alter:AccountsMasters and $$IsCmpOwner
    Add : Item : BLANK

    ;;---------------------------------------------------------------------------------------------------
    ;;E.O.F.
     
    Manoj Garg and Basha like this.


  2. NMS

    NMS Member


    Thanks for Sharing....
     


  3. laxman

    laxman Member


    how to work sir please explain ....
     


  4. Arup Chakraborty

    Arup Chakraborty New Member


    It is not preventing the entry where credit days are over but credit limit is under the limit.
     


  5. nagaraju

    nagaraju New Member


    It is not preventing the entry where credit days
     


  6. nagaraju

    nagaraju New Member


    It is not preventing the entry where credit days are over due
     


  7. Maulik Patel

    Maulik Patel Active Member



  8. Bikash Shaw

    Bikash Shaw Member


    i am getting the warning only but it is not restricting the entry in sales order
     


Share This Page