Knowledge Center

Knowledge Center > RevPro > Integration of Current GAAP and Future GAAP

Integration of Current GAAP and Future GAAP

This article introduces how to integrate RevPro Current GAAP and Future GAAP. To perform the integration, set up and configure in both the versions of RevPro. The detailed steps for integrating the Current and Future GAAP of RevPro are as follows.

Set Up in RevPro Current GAAP

The earlier version of RevPro is Current GAAP. To easily integrate your data from RevPro Current GAAP to Future GAAP version, perform the following steps:

Steps Procedure
1

From the RevPro Current GAAP menu, select Setups > Application Setups >IT Admin Lookups.

2 Select COMMON SETUP from the Lookup Types list. The relevant set up is displayed.
3

Select COMMON SETUP from the table, right-click and select Edit Lookup Definition.

4 Find Lookup Code ALLOW_REVPRO3_INTEGRATION and set Lookup Value to Y to enable the integration between current GAAP and future GAAP. If you want to disable the integration, set Lookup value to N.
5 Click Save.

Set Up in RevPro Future GAAP

Perform the following steps to be set up the Future GAAP.

Steps Procedure
1

From the RevPro Future GAAP menu, select Setups > Application Setups >Lookups.

2

Select RPRO_GD_INTG_METHOD, right-click and select Edit Lookup Definition. The following panel is displayed as shown in the figure below.

This figure lists the Lookup Codes that are available in RevPro. Also, you can see the detailed description of the Lookup Code. You can view the available Lookups and make your selection in the Profiles panel.

  • If the lookup value is Process Arrangement in cGAAP and interface Arrangement to fGAAP – RevPro will process the transactions in Current GAAP and then it will push the transactions to future GAAP stage table stamping with RC ID and Arrangment ID (without the prefix). All other transaction types other than SO and Invoice deleted transactions are moved to fGAAP Staging table. Revenue comparison is possible between current GAAP and future GAAP if this integration option is selected.
  • If the lookup value is Interface Transactions to cGAAP and fGAAP stage – When the transaction is pushed into Current GAAP stage, the same transactions will be pushed to future GAAP stage but the RC ID will not be stamped in the fGAAP staging table.
  • RevPro Future GAAP supports transaction types like CM, CM-C, CM-R, CM-RO, RORD, and CST. These transaction types will be deleted from the Current GAAP stage immediately after pushing the transactions to future GAAP stage.
  • In cGAAP, credit memo transactions are indicated as with the Transaction Type as INV and Cancel Flag as Yes. In such scenarios, customers can still pass the existing way of transaction type. However, on the same record of the ARR transaction stage, they need to populate the corresponding transaction type supported by fGAAP (ASC 606).
ASC 605 Type   Quantity Invoiced   Cancel Flag Return Flag ASC 606 Type
INV   Y   CM-C
INV -ve quantity   Y CM-R
INV 0   Y CM
  • TYPE is the standard column which holds the ASC 605 supported transaction types. INTG_TYPE is a new column added to the ARR stage where customers need to populate the ASC 606 corresponding transaction type.
3

From the RevPro Future GAAP menu, select Setups > Application Setups >Profiles to assign a Lookup Code for integration. The following panel is displayed as shown in the figure below.

4

Find RPRO_GD_INTG_METHOD, right-click and select Edit. The following panel is displayed as shown in the figure below. 

5 Select RPRO_GD_INTG_METHOD from the Lookup value list.
6

Select one of following items from the System Level Value list based on your requirement:

  • Process Arrangement in cGAAP and interface Arrangement to fGAAP
  • Interface Transactions to cGAAP and fGAAP stage

Note: See Step 2 for the descriptions of the Lookup values.

7 Click Save.

Set Up for Integration Mapping

To enable integration between two GAAP, do the mapping between current GAAP and future GAAP based on your requirements.

You can view the mapping of RevPro Current GAAP data mapped to Future GAAP in the Source Column and the Destination Column. You can change, enable, and disable the columns based on your requirements. You can also view what are the source data columns and how they are mapped with the destination data columns when integration is done.

Steps Procedure
1

From the RevPro Future GAAP menu, select Setups > Application Setups >Integration Mapping.

  • Source Column - Lists the names of the columns that are part of the current GAAP.
  • Destination Column – Lists the names of the columns that are part of RevPro Future GAAP.

Column Mapping for Process Arrangement in cGAAP and interface Arrangement to fGAAP

In the Integration Mapping, the source table should be selected as RPRO_ARR_TRANSACTIONS for those columns that exist in both cGAAP and fGAAP. For the columns that exist only in fGAAP, the source table should be selected as RPRO_ARR_TRANSACTIONS_STG.

For example, the column CV_ELIGIBLE_FLAG available in RPRO_ARR_TRANSACTIONS in cGAAP and RPRO_LINE_STG in fGAAP, the Source Table should be selected as RPRO_ARR_TRANSACTIONS. For those columns that are specific to fGAAP like AR_ACCOUNT, the Source Table should be selected as RPRO_ARR_TRANSACTIONS_STG.

Note: To collect Bundle lines, the bundle configuration should be set up only in cGAAP.

Column Mapping for Interface Transactions to cGAAP and fGAAP stage

In the Integration Mapping, the source table should always be RPRO_ARR_TRANSACTIONS_STG.

The column mapping for both the Integration Method remains the same.

Note: The columns prefixed with Intg in the Source Column drop down are the columns that are specific to fGAAP columns.

Data Integration Excel.csv

2 Select the Source Column, Destination Table, Destination Column, and Enabled fields to modify the values as well as enable or disable any table. 
3 Click Save.

High-Level Process Flow

Last modified
22:16, 7 Sep 2017

Tags

Classifications

(not set)