Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    386

    Unanswered: Can anyone help please how to calculate late payment fee on invoices on a query?

    Dear All,

    I am currently using the following code in a query for charging interest which is working fine but not what my boss has asked me to do.

    Quote:
    InterestCharge: IIf(Date() - [InvoiceDate]>50,1.02*[ClientAmountLessVAT],[ClientAmountLessVAT])
    Basically, I want the InterestAndLatePaymentFee to be charged as following:

    if invoice is date is greater than 40 days, then InterestAndLatePaymentFee should be charged as 15%, then for every other 10 days in addition to the first 40 days, an extra 5% InterestAndLatePaymentFee should be accrued to the invoice.

    Any help would be highly appreciated.
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    If my interpretaion of your requirements is correct, then I think this should do it

    InterestCharge:IIf(Date() - [InvoiceDate]<40,0,0.15+Int((Date() - [InvoiceDate]-40)/10)*0.05)

    ??

    Note this is the interest to be charged not the Interest Value !!

    That would be:-

    InterestAndLatePaymentFee:IIf(Date() - [InvoiceDate]<40,0,0.15+Int((Date() - [InvoiceDate]-40)/10)*0.05)*[ClientAmountLessVAT]

    ??



    HTH


    MTB

  3. #3
    Join Date
    May 2006
    Posts
    386
    Thank you very much for your response. I will get it a try and will update you accordingly
    Emi-UK
    Love begets Love, Help Begets Help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •