It’s been a day of testing work/data flow from Paperless to DevonThink. Solved most of it.
The one thing I haven’t fixed is making sure the data from amount and sales tax categories ends up as a currency field in DT.
Using the above script, it will only work if the amount metadata field is set as one line text, in which case the Create Expense Report tool doesn’t see it as a value. I think it won’t populate the amount field as a currency value if the dollar sign is in the string being entered using that script.
So I have to find away to strip off the dollar sign from the string.
P.S.
Doing this work is reminding me why I want to get my data out of Paperless. It’s really awkward to use and I only ended up using it because Neat turned into a flaming pile of what seemed like Hedge-Fund-acquisition based customer mining and feature removal.