Invoice Sample Database - Sales Tax calculation
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