How do you map a currency field in a record producer?

[e_wilber]

For Work Orders, there is an out of box Cost field which is a currency field.

I have a record producer to create a Work Order but our Cost field that is set to map back to the original Cost field is a string field. This is causing issues in the Work Order as some costs are coming through as empty.

The record producer doesn't give me an option to create the field as a currency field so I don't know how to fix this.

[Dan O Connor]

Hi.

So at the moment there is unfortunately no Currency type field available for record producers(it's a weird one, don't know why) so the issue you are encountering can be a common one, as a string field won't always map properly to a currency field.

There is the option however in Record producers to setup a Variable Validation Regex. This is basically where you set parameters for a field, and is commonly used to create a currency style field in a record producer.

This really only works in my experience though if using a single currency. 

There is a fair amount of solutions already on the community site for this, so suggest you have a search. I would normally link you to some, but there are a few issues with the new community update so posting links etc. stops from making replies 🙂