Convert a CreditAmount into a positive value ?
I'm trying to do an integration from Expensify into Dynamics GP by using SmartConnect.. So far I was able to figure out how to generate the master UserIdentity and secret key, but that was it.
I've created a custom Excel Export format that I want to pull thru the API by submitting a JSON request, but only have vague theoretical idea on how to do this with SmartConnect. If anyone has done this in the past, help would be greatly appreciated.
Also, my format uses a DEBIT & CREDIT column for the amounts as the ERP system is easier to feed so, but the ouput result returns a negative sign in front of the CREDIT amounts.. I wanted to remove that by adding *-1 to the formula, but now the field remains empty.. ??