Field Service – Contract Adminstation – Wrong FX rate

  • Field Service – Contract Adminstation – Wrong FX rate

    Posted by DSC Communities on March 10, 2017 at 3:34 pm
    • Deborah Mills

      Member

      March 10, 2017 at 3:34 PM

      Hello.

      We are on GP2013 R2 and we use the field service module, contract administration for our maintenance contracts.

      When posting February contract revenue in our CDN company, an incorrect FX rate was in place, resulting in the misstatement of our revenue in the functional currency.  Of course, the revenue in the originating currency was correct.

       

      Is there any way to correct (remove this incorrect posting in the contract module data) and repost now that the rates are corrected?  I know I can correct the GL but would prefer if possible to correct at the source since now our YTD reports are inaccurate.

      Any ideas?

      ——————————
      Deborah Mills
      Controller
      Constellation Software
      Toronto ON
      ——————————

    • Elaine Barry

      Member

      March 13, 2017 at 10:33 AM

      Dear Deborah:

      There are many ways to fix this situation, however, in preserving the Audit Trail for integrity, I would recommend doing the same thing you already did in error, although this time making the FX negative, to zero out the first posting, then re-doing it with the corrected rate, all on the same date…seems like a lot of work, but will be the most safe from criticism in the long run…glad that you caught it before it got out!

      ——————————
      Elaine Barry
      ERP Business Systems Analyst
      Enterprise Business Solutions
      Orlando, FL
      ——————————
      ——————————————-

    • Thaddeus Suter

      Member

      March 13, 2017 at 11:24 AM

      In CA Contract Revenue Recognition you can reverse a posted Revenue Recognition Entry for an individual Contract under Utilities – Service – Contract Revenue Recognition Reversal.

      Open the Utility and find the contract, year and period that you want to reverse. When you Post it will create an unposted GJ. Go to the GL and find the entry and verify it is reversing the originating currency and the FX currency at the rates and date you want to exactly offset the original posting. Fix the GJ if needed before posting.

      Now go back to Contract Revenue Recognition and the Contract, Year, and Period will reappear to be posted again. Make sure your rates are correct for the dates before posting the Contract RR and all will be OK.

      ——————————
      Thaddeus Suter
      Retus, Inc
      Helotes TX
      ——————————
      ——————————————-

    • David Flowers

      Member

      March 14, 2017 at 8:39 AM

      Would this Revenue reversal utility also work to correct long term Contracts that have been posted but the ending fiscal year wasn’t set up yet?

      ——————————
      David Flowers
      System Admin -GP and Salesforce Support
      RMG Enterprise Solutions
      Addison TX
      ——————————
      ——————————————-

    • David Flowers

      Member

      March 14, 2017 at 9:26 AM

      Answering my own question – there is a Field Service Utility that’s new or I’ve never seen before called “Re Calculate Contract Revenue”. It recalculates the unposted revenue to the open fiscal years. 

      ——————————
      David Flowers
      System Admin -GP and Salesforce Support
      RMG Enterprise Solutions
      Addison TX
      ——————————
      ——————————————-

    DSC Communities replied 6 years, 11 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!