I am working on a sales tax calculation/report app in FileMaker Pro version 16. The data is coming from our accounting software (Great Plains). Great Plains treats all data as unsigned positive numbers, but labels it to the type of transaction it is (invoice, return, debit memo, credit memo, payment). But all are positive numbers.
I set up an auto-enter calculation:
Document Type = "Return"; -Round(Sales Amount;2);
Document Type = "Credit Memo", -round(Sales Amount;2);
When I imported the numbers, I do not see that returns are showing as negative numbers. Will this not work? Do I need to use another field for converting the numbers?