3 Replies Latest reply on Dec 18, 2011 11:35 PM by RayCologon

    Invoice

    mendico

      In my Invoice I have an a field Balance Owing and a buttons Yes/No for all Payments

      eg If the Deposit is paid and . I would like the Balance Owing to show the outstanding amount

       

      How do I right this CalcuIation ? Can anyone help me please

        • 1. Re: Invoice
          RayCologon

          mendico wrote:

           

          In my Invoice I have an a field Balance Owing and a buttons  Yes/No for all Payments

          eg If the Deposit is paid and . I would like the Balance Owing to show the outstanding amount

           

          How do I right this CalcuIation ?  Can anyone help me please

           

          Hi Mendico,

           

          As oer my reply to you on another thread, the flat structure you're working with is not necessarily ideal for the kind of invoice lines and payments system you're creating - you would probably be better to place the amounts due and payments in their own separate tables.

           

          That said, if you're certain you want to persist with the approach you're currently taking, you can calculate the Balance Owing using a formula such as:

           

          Invoice Total -

          Deposit * (Deposit Paid = "Yes") -

          Second Instalment * (Second Instalment Paid = "Yes") -

          Third Instalment * (Third Instalment Paid = "Yes") -

          Final Payment * (Final Payment Paid = "Yes")

           

          Doing it this way, you'll require separate radio buttons for each of the instalments, which is one (among many) of the awkward aspects of a flat data structure. ;)

           

          Regards,

          Ray

          ------------------------------------------------

          R J Cologon, Ph.D.

          FileMaker Certified Developer

          Author, FileMaker Pro 10 Bible

          NightWing Enterprises, Melbourne, Australia

          http://www.nightwingenterprises.com

          ------------------------------------------------

          • 2. Re: Invoice
            mendico

            Once again Ray thank you so much for you formula it real works well, I am sure there would be a better way to do this

            But I am new to all this and I am trying to get my mind around the very simply things.

             

            Thanks very much

            Tony Mendico

            • 3. Re: Invoice
              RayCologon

              Hi Tony,

               

              No problem, glad you're getting things in place.

               

              As an aside, it's probably worth going back and marking your forum threads as answered once your issue is solved, as they are currently still showing up as "Not Answered".

               

              Cheers,

              Ray

              ------------------------------------------------

              R J Cologon, Ph.D.

              FileMaker Certified Developer

              Author, FileMaker Pro 10 Bible

              NightWing Enterprises, Melbourne, Australia

              http://www.nightwingenterprises.com

              ------------------------------------------------