AnsweredAssumed Answered

Invoice Sample Database - Sales Tax calculation

Question asked by JayHall on Jan 22, 2011
Latest reply on Feb 9, 2012 by JayHall

Title

Invoice Sample Database - Sales Tax calculation

Post

Hello FM Pro Support,

I am new to Filemaker and I was using the INVOICE sample database project and added some product sample data and noticed that after so many products (45 items) the sales tax was not being automatically calculated anymore and I have not modified any calculation.

The default calculation for Sales Tax in the invoice layout is this:

If ( (Sum ( Line Items::Taxable Amount ) - (Sum ( Line Items::Taxable Amount ) * Discount Rate))  ≥ 1 ; Round((Sum ( Line Items::Taxable Amount ) - (Sum ( Line Items::Taxable Amount ) * Discount Rate)) * Sales Tax Rate; 2) ; 0)

Can you let me know what I am missing?  Or is there an alternative way to calculate the Sales Tax calculation?  I like using the button on the invoice layout "Taxable" checkbox to determine taxable items.  I notice is doesn't seem to be working?  How do I get it to work?

Another question is that on the Products layout wether I select the check box "Taxable" doesn't seem to impact or affect the line items Taxable check box in invoice layout.  Is this the way it should behave?

Thanks for you help

Jay

Outcomes