TKnTexas55

Importing and Auto-Enter

Discussion created by TKnTexas55 on Apr 20, 2018
Latest reply on Apr 20, 2018 by TKnTexas55

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:

Case (

Document Type = "Return"; -Round(Sales Amount;2);

Document Type = "Credit Memo", -round(Sales Amount;2);

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?

Outcomes