6 Replies Latest reply on Mar 4, 2009 10:03 AM by comment_1

    Invoice and many VAT

    Serdom71

      Title

      Invoice and many VAT

      Post

      Hello everyone,

      I need help to solve a problem that I worry for days.
      I created a table "Invoice" and  "Invoice lines" whit the join IDInvoice.
      Each line can have a different VAT.
      I need to create a summary of the different VAT, but I can not do it.

       

      Please Help Me!



        • 1. Re: Invoice and many VAT
          TSGal

          Serdom71:

           

          Thank you for your post.

           

          Make sure you create a Summary field to total/count/average the VAT.

           

          How do you mark the different VAT?  Assuming the field name is VATName, you could create a new Layout/Report as a List/Report and group by VATName.  Be sure to have the Summary field in the trailing sub-summary by VATName.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Invoice and many VAT
            Serdom71
               Thanks for your reply.
            My problem is this:
            Bills I have two tables containing the general data of the invoice (number, date, code reviews, etc.) and rows of bill, which contains the detail of items sold (item code, description, price and VAT code).
            The two tables are related to invoice number.
            In press reports, there must be total suddivos for VAT.
            How can I do this.

            Thanks



            • 3. Re: Invoice and many VAT
              TSGal

              Serdom71:

               

              Thank you for your post.

               

              Since you have the two table related, you can use the Sum () function in the Invoice table to retrieve the rows of bills in the Detail table.

               

              A sample calculation would be:

               

              Sum (Invoice::Extended Price)

               

              TSGal

              FileMaker, Inc. 

              • 4. Re: Invoice and many VAT
                Serdom71
                  

                Thank you for your answer. I have tested as you you told me, but I sum all either not dividing the total for VAT. patience.

                Many thank's for your help.

                • 5. Re: Invoice and many VAT
                  TSGal

                  Serdom1:

                   

                  If you need to divide, then include that in the calculation.  That is,

                   

                  Sum ( Invoice::Extended Price ) / <VAT field>

                   

                  TSGal

                  FileMaker, Inc. 

                  • 6. Re: Invoice and many VAT
                    comment_1
                       I think what  Serdom71  is trying to say is that a line item can be assigned one of several VAT types (with a different rate for each type). The invoice needs to have a summary of the VAT collected, broken down by type. I believe it's the legal requirement in some European countries (I've ran into this a few years ago on another forum).

                    Unfortunately, the answers are too complex to explain without a demo file.