Automate

 View Only
  • 1.  Converting to rand value

    Posted 02-08-2019 09:23
    Hi

    I have created a form in composer for FB50. The journal is then routed to various approvers based on the rand value. However the captured currency in the journal is not always ZAR. I need to create a field that will convert the journal value to a rand value so that I can apply the rules for approval to this field. 

    Is there anyone who have done this previously and can assist?

    Thank you in advance for any response. 

    Faizee Bodha

    ------------------------------
    Faizee Bodha | Business Systems Analyst
    ------------------------------


  • 2.  RE: Converting to rand value

    Posted 03-21-2019 17:22
    Hi Faizee,

    I believe this will be possible but will need a little more detail to make sure we recommend to correct approach to address this issue.  First off, where are your conversion rates being stored today, (SAP, web, some other place)?  We would be able to crate a field on the Form that would convert the journal value to Rand Value from the other currency value but we would need to know where the currency conversion value is going to come from or create the process that is convenient for the Form to pull it from.  

    Recommendation without knowing more information:

    Setup a SharePoint or SQL table to store the conversion rates and then have that feed into the form to then convert the values into a separate field on the form and use that field for routing on the workflow.

    ------------------------------
    Bob Glitch | SOLUTIONS ENGINEER
    Winshuttle North America | 7402381807
    ------------------------------



  • 3.  RE: Converting to rand value

    Posted 03-28-2019 02:38

    Hi Bob

     

    Thanks for the response. We did do this a while ago and it worked perfectly. Thanks

     

     

    Faizee Bodha

    Business Systems Analyst

    Integrated Solutions

     

    +27 (0) 31 949 5013

    Faizee.Bodha@ttaf.co.za

    Toyota Tsusho Africa (Pty) Ltd

    15 Beechgate Crescent, Southgate Business Park, Moss Kolnik Drive,

    Umbogintwini, KwaZulu Natal, 4126 - South Africa

    www.ttaf.co.za

    image001.png@01D45BD1.3DCF1120