[JCirocco]

I have a customer who is starting to sell to a dealer network in Canada. Their standard base currency is US Dollars but all of these customer are in Canadian Dollars. They would like to show not only their selling price on the invoices (which default to Canadian Currency because of the Custom Record) but also include the current MSRP which is their Base Price in Canadian.

I have tried to source a custom field on the item record so I could grab it on the invoice. Base Price was available but couldn't find a way to get it in Canadian.

Is scripting a better idea (I don't script…)
This is a cached copy. Click here to see the original post.

[k_dunc]

You shouldn't need scripting from the perspective of an HTML form. You will, however, need to access the Canadian Base Price and I'd suggest that the best way to do this would be through a Custom Item Field. Where you able to get the Custom Field that you created to show on your HTML form? That should be fairly easy to do.

Once that is working, the trick will be to work out how to populate this Custom Item Field – ideally in an automated fashion – and regrettably, this may require scripting (unless someone else has a better idea). Could you populate this Custom Item Field through the Search (Saved Search) field in the Validation & Defaulting subtab? Can you create a Saved Search that can access the Base Price in Canadian Dollars?

[JCirocco]

Originally posted by k_dunc

View Post

…the trick will be to work out how to populate this Custom Item Field – ideally in an automated fashion – and regrettably, this may require scripting (unless someone else has a better idea). Could you populate this Custom Item Field through the Search (Saved Search) field in the Validation & Defaulting subtab? Can you create a Saved Search that can access the Base Price in Canadian Dollars?

Unfortunately you need a summary transaction search (at least as far as I can tell) for it to appear in the selection of searches. I have tried MANY ways to create the custom field and have it populate but with no luck.

[k_dunc]

Bugger. If that's the case, then maybe a script is the only way to populate this Custom Item Field. It shouldn't be too hard just in case you need the User Group to help walk you through it.

[JCirocco]

Thanks. Hopefully one of the folks I work with can help. If not, I will definitely ask the group.

[JCirocco]

We ended up with a small script. Works now. Thanks to all

[Author]

Posts