I'm onboarding a new team that has an extensive process for capturing PO approvals. They want to use the request queue to capture requests for new PO approvals and increases to existing POs. That's not the problem though. They are a global team and therefore need a way to track the Local Currency where the PO is being executed and convert it to USD. This wouldn't be an issue if we were tracking the PO's in a project and could use the OOTB Exchange Rates in Workfront or .... but they want the calculation on the custom form. To add another layer of complexity, they want to be able to refer to previously approved PO's on the custom form also to allow users to identify where an increase to an existing approval is being requested.
So here are the questions...
1) How does your organization track expenses that require using an Exchange Rate?
2) How do you account for the constant changes to exchange rates to ensure that the data is accurate but doesn't affect historical calculations?
For example, I'm concerned that if I create a drop down with the exchange rates and then have to change the rate, the calculation will recalc and historical data will become corrupt.
3) What method, if any, has your org utilized to represent data in the system on a custom form? I'm thinking it's a hyperlink to a report that shows all of the approvals, however, we're talking about well over 1500 line items for a years time and these will span multiple years.
I'd love to hear how others have implemented similar solutions.
Thanks!
Teale
