Release PV8.4.0 SV113

The theme for this Hotfix release is a bug fix to Account Reconciliations.

Fixed Issues

Account Reconciliations

  • You can calculate inverse rates without needing to load inverse rates for all currencies. If utilizing V9, you won’t receive a duplicate key error when retrieving FX rates. (MP1-7529, MP1-7126)

Upgrade Information

  • This solution is compatible with OneStream Platform v8.4.

  • Review the information in this section before you install, deploy, or upgrade. OneStream strongly recommends that you upgrade in a Development environment before upgrading in the Production application.

  • Uninstall UI prior to upgrading due to the migration to the OneStream Financial Close workspace.

  • Upgrade to OFC PV710 SV204 before upgrading to any OFC 8.X version.

  • Users with multiple instances will need to use the same instance number build of the current release when upgrading.

Compatibility

Component

Description

OneStream 8.4.0 or later

Minimum OneStream Platform release required to install this release of OneStream Financial Close.

See the Upgrade Guide.
Microsoft SQL Server

One of these versions of Microsoft SQL Server is required:

  • Standard Edition 2016 SP1 or later

  • Enterprise Edition 2012 or later

Contact Support

Contact OneStream Support by registering at:

Support - OneStream Software

Release PV8.4.0 SV112

The theme for this Hotfix release is bug fixes.

Fixed Issues

Account Reconciliations

  • When loading the multi-period template, you are not required to enter future FX rates. All detail items will be translated using the FX rates for the current period. (MP1-7114)

  • You can run Process with AutoRecs rules using a non-US culture. (MP1-7135)

  • You can run Prepare with the Prepare Rule using a non-US culture. (MP1-7139)

  • When you run Process, the reconciliation status remains unchanged unless you modify the stage balance or subledger balances. (MP1-7023, MP1- 7232)

  • After you decertify an account reconciliation group, the child reconciliations change status enabling you to regroup them. (MP1-7194)

Transaction Matching

  • The DataSet ID does not update when the filter criteria from one dataset overlaps with another dataset. (MP1-7033)

  • Certain date formats convert, executing the rule. (MP1-4993)

  • You can set up a one-sided match rule using condition values. (MP1-5011)

  • When you select a match from the 'Matches with Variance' or 'Matches with Comments or Attachments' reports on the Analysis page, the Transactions tab will be the default pane when Details is selected. (MP1-6499)

  • You will not encounter a timeout when no matches are found during the matching process. (MP1-7095)

  • When adding a Definition for a rule, you may include control fields from the Data Set under the Attributes section. (MP1-7141)

Upgrade Information

  • This solution is compatible with OneStream Platform v8.4.

  • Review the information in this section before you install, deploy, or upgrade. OneStream strongly recommends that you upgrade in a Development environment before upgrading in the Production application.

  • Uninstall UI prior to upgrading due to the migration to the OneStream Financial Close workspace.

  • Upgrade to OFC PV710 SV204 before upgrading to any OFC 8.X version.

  • Users with multiple instances will need to use the same instance number build of the current release when upgrading.

Compatibility

Component

Description

OneStream 8.4.0 or later

Minimum OneStream Platform release required to install this release of OneStream Financial Close.

See the Upgrade Guide.
Microsoft SQL Server

One of these versions of Microsoft SQL Server is required:

  • Standard Edition 2016 SP1 or later

  • Enterprise Edition 2012 or later

Contact Support

Contact OneStream Support by registering at:

Support - OneStream Software

Release PV8.4.0 SV111

The theme for this Hotfix release is to enhance date logic for Date Attribute fields in TXM, ensuring the source column is included and active in the data source.

Enhancements

Transaction Matching

  • Enhanced date logic for Date Attribute fields to ensure the source column is included and active in the data source, not only active in the cube. (MP1-6826)

Fixed Issues

Transaction Matching

  • Improved date logic for Date Attribute fields to ensure the source column is included and active in the data source, not only the cube. An error will occur if the field is active in both locations and the value is blank or unparseable. Refer to Appendix B in the guide, detailing how to use a complex expression in these cases. (MP1-6823)

Upgrade Information

  • This solution is compatible with OneStream Platform v8.4.

  • Review the information in this section before you install, deploy, or upgrade. OneStream strongly recommends that you upgrade in a Development environment before upgrading in the Production application.

  • Uninstall UI prior to upgrading due to the migration to the OneStream Financial Close workspace.

  • Upgrade to OFC PV710 SV203 before upgrading to any OFC 8.X version.

  • Users with multiple instances will need to use the same instance number build of the current release when upgrading.

Compatibility

Component

Description

OneStream 8.4.0 or later

Minimum OneStream Platform release required to install this release of OneStream Financial Close.

See the Upgrade Guide.
Microsoft SQL Server

One of these versions of Microsoft SQL Server is required:

  • Standard Edition 2016 SP1 or later

  • Enterprise Edition 2012 or later

IMPORTANT: Due to the significant refactoring and restructuring, any previous source code customizations will be obsolete.

If you are using any of the Templates or Exports listed below from a prior release version, please update the file to reflect the new table names in the following areas:

RCM Templates Old New Location
Basic Template XFW_RCM_ReconItems [rcm].[ReconItem] A17
MultiPeriod Template XFW_RCM_ReconItems [rcm].[ReconItem] A17
MultiCurrency Template XFW_RCM_ReconItems [rcm].[ReconItem] A20
MultiCurrencyMultiPeriod Template XFW_RCM_ReconItems [rcm].[ReconItem] A20
Access Groups XFW_RCM_AccessGroups [rcm].[AccessGroup] A4
Access Group Members XFW_RCM_AccessGroupMembers [rcm].[AccessGroupMembers] A4
Export/Import Templates Old New Location
Access Groups XFW_RCM_AccessGroups [rcm].[AccessGroup] A13
Access Group Members XFW_RCM_AccessGroupMembers [rcm].[AccessGroupMembers] A16
Administration - Inventory and Groups pages XFW_RCM_ReconItems [rcm].[ReconItem] A26

NOTE: If using multiple instances, [rcm].[ReconItem] will need to be updated to the instance in use. For example, [rcm1].[ReconItem].

IMPORTANT: If you are using a Template or Export from a prior release version, you will need to unhide certain rows within the template to update to the new table names.

Please be aware that if you have made any customizations in RCM or TXM that the names of the following tables and columns have been updated:

TXM Tables

OFC PV800 SV200 OFC PV840 SV110
Old Table/View Name New Table/View Name
[dbo].[vXFW_TXM_TransactionDetail] DEPRECATED
[dbo].[vXFW_TXM_TransactionDetailMatched] DEPRECATED
[dbo].[vXFW_TXM_TransactionDetailWithSource] DEPRECATED
[dbo].[XFW_TXM_AccessGroupMembers] [txm].[AccessGroupMember]
[dbo].[XFW_TXM_AccessGroups] [txm].[AccessGroup]
[dbo].[XFW_TXM_AdvFilters] [txm].[AdvancedFilter]
[dbo].[XFW_TXM_ControlLists] DEPRECATED
[dbo].[XFW_TXM_DataSetFields] [txm].[MatchDataSetField]
[dbo].[XFW_TXM_DataSets] [txm].[MatchDataSet]
[dbo].[XFW_TXM_DataSetWorkflows] [txm].[MatchDataSetWorkflow]
[dbo].[XFW_TXM_Match] [txm].[Match]
[dbo].[XFW_TXM_MatchCommentary] [txm].[MatchComment]
[dbo].[XFW_TXM_MatchSets] [txm].[MatchSet]
[dbo].[XFW_TXM_MatchSupportDoc] [txm].[MatchSupportDoc]
[dbo].[XFW_TXM_ReasonCodes] [txm].[ReasonCode]
[dbo].[XFW_TXM_RuleDefinitions] [txm].[MatchRuleDefinition]
[dbo].[XFW_TXM_RuleFilter] [txm].[MatchRuleFilter]
[dbo].[XFW_TXM_RuleGroupFields] [txm].[MatchRuleGroupField]
[dbo].[XFW_TXM_Rules] [txm].[MatchRule]
[dbo].[XFW_TXM_SplitFilter] [txm].[DataSplitFilter]
[dbo].[XFW_TXM_SplitWorkflows] [txm].[DataSplitTarget]
[dbo].[XFW_TXM_Transaction] [txm].[Transactions]
  [txm].[vAllTransactions] (NEW)
  [txm].[vMatchedTransactions] (NEW)
  [txm].[vNonMatchedTransactions] (NEW)

RCM Tables

OFC PV800 SV200 OFC PV840 SV110
Old Table/View Name New Table/View Name
[dbo].[XFW_RCM_AccessGroups] [rcm].[AccessGroup]
[dbo].[XFW_RCM_AccessGroupMembers] [rcm].[AccessGroupMember]
[dbo].[XFW_RCM_ControlListAging] [rcm].[AgingPeriod]
[dbo].[XFW_RCM_AuditRecon] [rcm].[AuditRecon]
[dbo].[XFW_RCM_AuditReconTimeAttribute] [rcm].[AuditReconTimeAttribute]
[dbo].[XFW_RCM_AutoRecRules] [rcm].[AutoRecRule]
[dbo].[XFW_RCM_BalanceCheckLevels] [rcm].[BalanceCheckLevel]
[dbo].[XFW_RCM_Certifications] [rcm].[Certification]
[dbo].[XFW_RCM_ControlListCloseDates] [rcm].[CloseDate]
[dbo].[XFW_RCM_ControlLists] [rcm].[ControlList]
[dbo].[XFW_RCM_ControlListCustomAttributes] [rcm].[CustomAttribute]
[dbo].[XFW_RCM_ControlListCustomAttributesDropdownValues] [rcm].[CustomAttributeDropdownValue]
[dbo].[XFW_RCM_EntityTrackingLevel] [rcm].[EntityTrackingLevel]
[dbo].[XFW_RCM_NotificationMethods] [rcm].[NotificationMethod]
[dbo].[XFW_RCM_Recon] [rcm].[Recon]
[dbo].[XFW_RCM_ReconBalance] [rcm].[ReconBalance]
[dbo].[XFW_RCM_ReconCommentary] [rcm].[ReconCommentary]
[dbo].[XFW_RCM_ReconDefinition] [rcm].[ReconDefinition]
[dbo].[XFW_RCM_ReconGridColumnSettings] [rcm].[ReconGridColumnSetting]
[dbo].[XFW_RCM_ReconItems] [rcm].[ReconItem]
[dbo].[XFW_RCM_ReconItemTransactions] [rcm].[ReconItemTransaction]
[dbo].[XFW_RCM_ReconMatchSets] [rcm].[ReconMatchSet]
[dbo].[XFW_RCM_ReconStateLog] [rcm].[ReconStateLog]
[dbo].[XFW_RCM_ReconSupportDoc] [rcm].[ReconSupportDoc]
[dbo].[XFW_RCM_ReconSupportDocInstance] [rcm].[ReconSupportDocInstance]
[dbo].[XFW_RCM_ReconTemplates] [rcm].[ReconTemplate]
[dbo].[XFW_RCM_ReconTimeAttribute] [rcm].[ReconTimeAttribute]
[dbo].[XFW_RCM_TrackingLevels] [rcm].[TrackingLevel]

TXM Columns

OFC PV800 SV200 OFC PV840 SV110
TableName.OldColumnName NewColumnName
AccessGroupMember.FKGroupName FkGroupName
AdvancedFilter.FilterID FilterId
AdvancedFilter.FKDataSetID FkMatchDataSetId
DataSplitTarget.FKDataSetID FkMatchDataSetId
DataSplitTarget.SplitID SplitId
Match.FKMatchSetID FkMatchSetId
Match.FKReasonCodeID FkReasonCodeId
Match.FKRuleID FkMatchRuleId
Match.MatchID MatchId
MatchComment.CommentID CommentId
MatchComment.FKMatchID FkMatchId
MatchDataSet.DataSetID MatchDataSetId
MatchDataSet.FKMatchSetID FkMatchSetId
MatchDataSetWorkflow.FKDataSetID FkMatchDataSetId
MatchRule.FKMatchSetID FkMatchSetId
MatchRule.FKReasonCodeID FkReasonCodeId
MatchRule.RuleID MatchRuleId
MatchRule.Type RuleType
MatchRuleFilter.FKDataSetID FKMatchDataSetId
MatchRuleFilter.FKRuleID FKMatchRuleId
MatchRuleGroupField.FKDataSetID FKMatchDataSetId
MatchRuleGroupField.FKRuleID FKMatchRuleId
MatchSupportDoc.DocID DocId
MatchSupportDoc.FKMatchID FkMatchId
ReasonCode.FKMatchSetID FkMatchSetId
ReasonCode.ReasonCodeID ReasonCodeId
TransactionComment.CommentID CommentId
TransactionComment.FKTransactionID FkTransactionId
Transactions.FKDataSetID FkMatchDataSetId
Transactions.FKMatchID FkMatchId
Transactions.FKReasonCodeID FkReasonCodeId
Transactions.TransactionID TransactionId
TransactionSupportDoc.DocID DocId
TransactionSupportDoc.FKTransactionID FkTransactionId

RCM Columns

OFC PV800 SV200 OFC PV840 SV110
TableName.OldColumnName NewColumnName
CloseDate.CloseDate CloseDateLocal

Migration

If you have reconciliations with a frequency other than monthly that migrate to OneStream Financial Close Release PV710 SV201 or later, you may need to mark these reconciliations as required in the current period and then run Discover for the current period. (MP1-4614, MP1-4688)

Contact Support

Contact OneStream Support by registering at:

Support - OneStream Software

Release PV8.4.0 SV110

The theme for this Minor release is maintenance and bug fixes to improve overall functionality.

Fixed Issues

Account Reconciliations

  • When you move an account from Group 1 to Group 2, Group 1 does not acquire the frequency of Group 2. (MP1-6487, MP1-6392)

  • A modification was made to improve T-Doc import performance. (MP1-6674)

  • Preparers receive an upcoming reconciliation notification when the reconciliation does not belong to the period. (MP1-6484, MP1-5975)

  • The reconciliation status displays "FrequencyChanged" and is only visible in the grid when using the Miscellaneous filter. (MP1-6480, MP1-3414)

  • Aging Pivot report captures Item Amount regardless of whether the detail item is assigned at the individual reconciliation or group reconciliation level. (MP1-6716)

  • A deleted R-doc will no longer be automatically pulled forward as reconciliation support when associated with an AutoRec rule. (MP1-6151)

Transaction Matching

  • The logic for date parsing has been updated. Dates that fail date parsing will no longer default to 1/1/1900. (MP1-6669)

  • The Where Clause component can be used and will no longer be overridden. (MP1-6717)

  • Attribute conditions (Left/Right) will no longer throw an error on Process when the condition value is larger than the length of any value. (MP1-6719)

  • Selecting Entity OR IC as an option under Administration > Data Sets > Security Type will no longer display incorrect results in the respective data set. (MP1-6735)

Upgrade Information

  • This solution is compatible with OneStream Platform v8.4.

  • Review the information in this section before you install, deploy, or upgrade. OneStream strongly recommends that you upgrade in a Development environment before upgrading in the Production application.

  • Uninstall UI prior to upgrading due to the migration to the OneStream Financial Close workspace.

  • Upgrade to OFC PV710 SV203 before upgrading to any OFC 8.X version.

  • Users with multiple instances will need to use the same instance number build of the current release when upgrading.

Compatibility

Component

Description

OneStream 8.4.0 or later

Minimum OneStream Platform release required to install this release of OneStream Financial Close.

See the Upgrade Guide.
Microsoft SQL Server

One of these versions of Microsoft SQL Server is required:

  • Standard Edition 2016 SP1 or later

  • Enterprise Edition 2012 or later

IMPORTANT: Due to the significant refactoring and restructuring, any previous source code customizations will be obsolete.

If you are using any of the Templates or Exports listed below from a prior release version, please update the file to reflect the new table names in the following areas:

RCM Templates Old New Location
Basic Template XFW_RCM_ReconItems [rcm].[ReconItem] A17
MultiPeriod Template XFW_RCM_ReconItems [rcm].[ReconItem] A17
MultiCurrency Template XFW_RCM_ReconItems [rcm].[ReconItem] A20
MultiCurrencyMultiPeriod Template XFW_RCM_ReconItems [rcm].[ReconItem] A20
Access Groups XFW_RCM_AccessGroups [rcm].[AccessGroup] A4
Access Group Members XFW_RCM_AccessGroupMembers [rcm].[AccessGroupMembers] A4
Export/Import Templates Old New Location
Access Groups XFW_RCM_AccessGroups [rcm].[AccessGroup] A13
Access Group Members XFW_RCM_AccessGroupMembers [rcm].[AccessGroupMembers] A16
Administration - Inventory and Groups pages XFW_RCM_ReconItems [rcm].[ReconItem] A26

NOTE: If using multiple instances, [rcm].[ReconItem] will need to be updated to the instance in use. For example, [rcm1].[ReconItem].

IMPORTANT: If you are using a Template or Export from a prior release version, you will need to unhide certain rows within the template to update to the new table names.

Please be aware that if you have made any customizations in RCM or TXM that the names of the following tables and columns have been updated:

TXM Tables

OFC PV800 SV200 OFC PV840 SV110
Old Table/View Name New Table/View Name
[dbo].[vXFW_TXM_TransactionDetail] DEPRECATED
[dbo].[vXFW_TXM_TransactionDetailMatched] DEPRECATED
[dbo].[vXFW_TXM_TransactionDetailWithSource] DEPRECATED
[dbo].[XFW_TXM_AccessGroupMembers] [txm].[AccessGroupMember]
[dbo].[XFW_TXM_AccessGroups] [txm].[AccessGroup]
[dbo].[XFW_TXM_AdvFilters] [txm].[AdvancedFilter]
[dbo].[XFW_TXM_ControlLists] DEPRECATED
[dbo].[XFW_TXM_DataSetFields] [txm].[MatchDataSetField]
[dbo].[XFW_TXM_DataSets] [txm].[MatchDataSet]
[dbo].[XFW_TXM_DataSetWorkflows] [txm].[MatchDataSetWorkflow]
[dbo].[XFW_TXM_Match] [txm].[Match]
[dbo].[XFW_TXM_MatchCommentary] [txm].[MatchComment]
[dbo].[XFW_TXM_MatchSets] [txm].[MatchSet]
[dbo].[XFW_TXM_MatchSupportDoc] [txm].[MatchSupportDoc]
[dbo].[XFW_TXM_ReasonCodes] [txm].[ReasonCode]
[dbo].[XFW_TXM_RuleDefinitions] [txm].[MatchRuleDefinition]
[dbo].[XFW_TXM_RuleFilter] [txm].[MatchRuleFilter]
[dbo].[XFW_TXM_RuleGroupFields] [txm].[MatchRuleGroupField]
[dbo].[XFW_TXM_Rules] [txm].[MatchRule]
[dbo].[XFW_TXM_SplitFilter] [txm].[DataSplitFilter]
[dbo].[XFW_TXM_SplitWorkflows] [txm].[DataSplitTarget]
[dbo].[XFW_TXM_Transaction] [txm].[Transactions]
  [txm].[vAllTransactions] (NEW)
  [txm].[vMatchedTransactions] (NEW)
  [txm].[vNonMatchedTransactions] (NEW)

RCM Tables

OFC PV800 SV200 OFC PV840 SV110
Old Table/View Name New Table/View Name
[dbo].[XFW_RCM_AccessGroups] [rcm].[AccessGroup]
[dbo].[XFW_RCM_AccessGroupMembers] [rcm].[AccessGroupMember]
[dbo].[XFW_RCM_ControlListAging] [rcm].[AgingPeriod]
[dbo].[XFW_RCM_AuditRecon] [rcm].[AuditRecon]
[dbo].[XFW_RCM_AuditReconTimeAttribute] [rcm].[AuditReconTimeAttribute]
[dbo].[XFW_RCM_AutoRecRules] [rcm].[AutoRecRule]
[dbo].[XFW_RCM_BalanceCheckLevels] [rcm].[BalanceCheckLevel]
[dbo].[XFW_RCM_Certifications] [rcm].[Certification]
[dbo].[XFW_RCM_ControlListCloseDates] [rcm].[CloseDate]
[dbo].[XFW_RCM_ControlLists] [rcm].[ControlList]
[dbo].[XFW_RCM_ControlListCustomAttributes] [rcm].[CustomAttribute]
[dbo].[XFW_RCM_ControlListCustomAttributesDropdownValues] [rcm].[CustomAttributeDropdownValue]
[dbo].[XFW_RCM_EntityTrackingLevel] [rcm].[EntityTrackingLevel]
[dbo].[XFW_RCM_NotificationMethods] [rcm].[NotificationMethod]
[dbo].[XFW_RCM_Recon] [rcm].[Recon]
[dbo].[XFW_RCM_ReconBalance] [rcm].[ReconBalance]
[dbo].[XFW_RCM_ReconCommentary] [rcm].[ReconCommentary]
[dbo].[XFW_RCM_ReconDefinition] [rcm].[ReconDefinition]
[dbo].[XFW_RCM_ReconGridColumnSettings] [rcm].[ReconGridColumnSetting]
[dbo].[XFW_RCM_ReconItems] [rcm].[ReconItem]
[dbo].[XFW_RCM_ReconItemTransactions] [rcm].[ReconItemTransaction]
[dbo].[XFW_RCM_ReconMatchSets] [rcm].[ReconMatchSet]
[dbo].[XFW_RCM_ReconStateLog] [rcm].[ReconStateLog]
[dbo].[XFW_RCM_ReconSupportDoc] [rcm].[ReconSupportDoc]
[dbo].[XFW_RCM_ReconSupportDocInstance] [rcm].[ReconSupportDocInstance]
[dbo].[XFW_RCM_ReconTemplates] [rcm].[ReconTemplate]
[dbo].[XFW_RCM_ReconTimeAttribute] [rcm].[ReconTimeAttribute]
[dbo].[XFW_RCM_TrackingLevels] [rcm].[TrackingLevel]

 

TXM Columns

OFC PV800 SV200 OFC PV840 SV110
TableName.OldColumnName NewColumnName
AccessGroupMember.FKGroupName FkGroupName
AdvancedFilter.FilterID FilterId
AdvancedFilter.FKDataSetID FkMatchDataSetId
DataSplitTarget.FKDataSetID FkMatchDataSetId
DataSplitTarget.SplitID SplitId
Match.FKMatchSetID FkMatchSetId
Match.FKReasonCodeID FkReasonCodeId
Match.FKRuleID FkMatchRuleId
Match.MatchID MatchId
MatchComment.CommentID CommentId
MatchComment.FKMatchID FkMatchId
MatchDataSet.DataSetID MatchDataSetId
MatchDataSet.FKMatchSetID FkMatchSetId
MatchDataSetWorkflow.FKDataSetID FkMatchDataSetId
MatchRule.FKMatchSetID FkMatchSetId
MatchRule.FKReasonCodeID FkReasonCodeId
MatchRule.RuleID MatchRuleId
MatchRule.Type RuleType
MatchRuleFilter.FKDataSetID FKMatchDataSetId
MatchRuleFilter.FKRuleID FKMatchRuleId
MatchRuleGroupField.FKDataSetID FKMatchDataSetId
MatchRuleGroupField.FKRuleID FKMatchRuleId
MatchSupportDoc.DocID DocId
MatchSupportDoc.FKMatchID FkMatchId
ReasonCode.FKMatchSetID FkMatchSetId
ReasonCode.ReasonCodeID ReasonCodeId
TransactionComment.CommentID CommentId
TransactionComment.FKTransactionID FkTransactionId
Transactions.FKDataSetID FkMatchDataSetId
Transactions.FKMatchID FkMatchId
Transactions.FKReasonCodeID FkReasonCodeId
Transactions.TransactionID TransactionId
TransactionSupportDoc.DocID DocId
TransactionSupportDoc.FKTransactionID FkTransactionId

 

RCM Columns

OFC PV800 SV200 OFC PV840 SV110
TableName.OldColumnName NewColumnName
CloseDate.CloseDate CloseDateLocal

Migration

If you have reconciliations with a frequency other than monthly that migrate to OneStream Financial Close Release PV710 SV201 or later, you may need to mark these reconciliations as required in the current period and then run Discover for the current period. (MP1-4614, MP1-4688)

Contact Support

Contact OneStream Support by registering at:

Support - OneStream Software

Release PV8.4.0 SV100

The theme for this release is a comprehensive redesign of the of the Transaction Matching (TXM) solution, delivering enhanced functionality, a user friendly interface and efficiency gains. This release also includes bug fixes.

Prerequisites

  • This solution is compatible with OneStream Platform v8.4.

  • Review the information in this section before you install, deploy, or upgrade. OneStream strongly recommends that you upgrade in a Development environment before upgrading in the Production application.

  • Uninstall UI prior to upgrading due to the migration to the OneStream Financial Close workspace.

  • Upgrade to OFC PV710 SV201 before upgrading to any OFC 8.X version.

  • Users with multiple instances will need to use the same instance number build of the current release when upgrading.

Compatibility

Component

Description

OneStream 8.4.0 or later

Minimum OneStream Platform release required to install this release of OneStream Financial Close.

See the Upgrade Guide.
Microsoft SQL Server

One of these versions of Microsoft SQL Server is required:

  • Standard Edition 2016 SP1 or later

  • Enterprise Edition 2012 or later

IMPORTANT: Due to the significant refactoring and restructuring, any previous source code customizations will be obsolete.

If you are using any of the Templates or Exports listed below from a prior release version, please update the file to reflect the new table names in the following areas:

RCM Templates Old New Location
Basic Template XFW_RCM_ReconItems [rcm].[ReconItem] A17
MultiPeriod Template XFW_RCM_ReconItems [rcm].[ReconItem] A17
MultiCurrency Template XFW_RCM_ReconItems [rcm].[ReconItem] A20
MultiCurrencyMultiPeriod Template XFW_RCM_ReconItems [rcm].[ReconItem] A20
Access Groups XFW_RCM_AccessGroups [rcm].[AccessGroup] A4
Access Group Members XFW_RCM_AccessGroupMembers [rcm].[AccessGroupMembers] A4
Export/Import Templates Old New Location
Access Groups XFW_RCM_AccessGroups [rcm].[AccessGroup] A13
Access Group Members XFW_RCM_AccessGroupMembers [rcm].[AccessGroupMembers] A16
Administration - Inventory and Groups pages XFW_RCM_ReconItems [rcm].[ReconItem] A26

NOTE: If using multiple instances [rcm].[ReconItem] will need to be updated to the instance in use. For example, [rcm1].[ReconItem].

IMPORTANT: If you are using a Template or Export from a prior release version, you will need to unhide certain rows within the template to update to the new table names.

Please be aware that if you have made any customizations in RCM or TXM that the names of the following tables and columns have been updated:

TXM Tables

OFC PV800 SV200 OFC PV840 SV100
Old Table/View Name New Table/View Name
[dbo].[vXFW_TXM_TransactionDetail] DEPRECATED
[dbo].[vXFW_TXM_TransactionDetailMatched] DEPRECATED
[dbo].[vXFW_TXM_TransactionDetailWithSource] DEPRECATED
[dbo].[XFW_TXM_AccessGroupMembers] [txm].[AccessGroupMember]
[dbo].[XFW_TXM_AccessGroups] [txm].[AccessGroup]
[dbo].[XFW_TXM_AdvFilters] [txm].[AdvancedFilter]
[dbo].[XFW_TXM_ControlLists] DEPRECATED
[dbo].[XFW_TXM_DataSetFields] [txm].[MatchDataSetField]
[dbo].[XFW_TXM_DataSets] [txm].[MatchDataSet]
[dbo].[XFW_TXM_DataSetWorkflows] [txm].[MatchDataSetWorkflow]
[dbo].[XFW_TXM_Match] [txm].[Match]
[dbo].[XFW_TXM_MatchCommentary] [txm].[MatchComment]
[dbo].[XFW_TXM_MatchSets] [txm].[MatchSet]
[dbo].[XFW_TXM_MatchSupportDoc] [txm].[MatchSupportDoc]
[dbo].[XFW_TXM_ReasonCodes] [txm].[ReasonCode]
[dbo].[XFW_TXM_RuleDefinitions] [txm].[MatchRuleDefinition]
[dbo].[XFW_TXM_RuleFilter] [txm].[MatchRuleFilter]
[dbo].[XFW_TXM_RuleGroupFields] [txm].[MatchRuleGroupField]
[dbo].[XFW_TXM_Rules] [txm].[MatchRule]
[dbo].[XFW_TXM_SplitFilter] [txm].[DataSplitFilter]
[dbo].[XFW_TXM_SplitWorkflows] [txm].[DataSplitTarget]
[dbo].[XFW_TXM_Transaction] [txm].[Transactions]
  [txm].[vAllTransactions] (NEW)
  [txm].[vMatchedTransactions] (NEW)
  [txm].[vNonMatchedTransactions] (NEW)

RCM Tables

OFC PV800 SV200 OFC PV840 SV100
Old Table/View Name New Table/View Name
[dbo].[XFW_RCM_AccessGroups] [rcm].[AccessGroup]
[dbo].[XFW_RCM_AccessGroupMembers] [rcm].[AccessGroupMember]
[dbo].[XFW_RCM_ControlListAging] [rcm].[AgingPeriod]
[dbo].[XFW_RCM_AuditRecon] [rcm].[AuditRecon]
[dbo].[XFW_RCM_AuditReconTimeAttribute] [rcm].[AuditReconTimeAttribute]
[dbo].[XFW_RCM_AutoRecRules] [rcm].[AutoRecRule]
[dbo].[XFW_RCM_BalanceCheckLevels] [rcm].[BalanceCheckLevel]
[dbo].[XFW_RCM_Certifications] [rcm].[Certification]
[dbo].[XFW_RCM_ControlListCloseDates] [rcm].[CloseDate]
[dbo].[XFW_RCM_ControlLists] [rcm].[ControlList]
[dbo].[XFW_RCM_ControlListCustomAttributes] [rcm].[CustomAttribute]
[dbo].[XFW_RCM_ControlListCustomAttributesDropdownValues] [rcm].[CustomAttributeDropdownValue]
[dbo].[XFW_RCM_EntityTrackingLevel] [rcm].[EntityTrackingLevel]
[dbo].[XFW_RCM_NotificationMethods] [rcm].[NotificationMethod]
[dbo].[XFW_RCM_Recon] [rcm].[Recon]
[dbo].[XFW_RCM_ReconBalance] [rcm].[ReconBalance]
[dbo].[XFW_RCM_ReconCommentary] [rcm].[ReconCommentary]
[dbo].[XFW_RCM_ReconDefinition] [rcm].[ReconDefinition]
[dbo].[XFW_RCM_ReconGridColumnSettings] [rcm].[ReconGridColumnSetting]
[dbo].[XFW_RCM_ReconItems] [rcm].[ReconItem]
[dbo].[XFW_RCM_ReconItemTransactions] [rcm].[ReconItemTransaction]
[dbo].[XFW_RCM_ReconMatchSets] [rcm].[ReconMatchSet]
[dbo].[XFW_RCM_ReconStateLog] [rcm].[ReconStateLog]
[dbo].[XFW_RCM_ReconSupportDoc] [rcm].[ReconSupportDoc]
[dbo].[XFW_RCM_ReconSupportDocInstance] [rcm].[ReconSupportDocInstance]
[dbo].[XFW_RCM_ReconTemplates] [rcm].[ReconTemplate]
[dbo].[XFW_RCM_ReconTimeAttribute] [rcm].[ReconTimeAttribute]
[dbo].[XFW_RCM_TrackingLevels] [rcm].[TrackingLevel]

TXM Columns

OFC PV800 SV200 OFC PV840 SV100
TableName.OldColumnName NewColumnName
AccessGroupMember.FKGroupName FkGroupName
AdvancedFilter.FilterID FilterId
AdvancedFilter.FKDataSetID FkMatchDataSetId
DataSplitTarget.FKDataSetID FkMatchDataSetId
DataSplitTarget.SplitID SplitId
Match.FKMatchSetID FkMatchSetId
Match.FKReasonCodeID FkReasonCodeId
Match.FKRuleID FkMatchRuleId
Match.MatchID MatchId
MatchComment.CommentID CommentId
MatchComment.FKMatchID FkMatchId
MatchDataSet.DataSetID MatchDataSetId
MatchDataSet.FKMatchSetID FkMatchSetId
MatchDataSetWorkflow.FKDataSetID FkMatchDataSetId
MatchRule.FKMatchSetID FkMatchSetId
MatchRule.FKReasonCodeID FkReasonCodeId
MatchRule.RuleID MatchRuleId
MatchRule.Type RuleType
MatchRuleFilter.FKDataSetID FKMatchDataSetId
MatchRuleFilter.FKRuleID FKMatchRuleId
MatchRuleGroupField.FKDataSetID FKMatchDataSetId
MatchRuleGroupField.FKRuleID FKMatchRuleId
MatchSupportDoc.DocID DocId
MatchSupportDoc.FKMatchID FkMatchId
ReasonCode.FKMatchSetID FkMatchSetId
ReasonCode.ReasonCodeID ReasonCodeId
TransactionComment.CommentID CommentId
TransactionComment.FKTransactionID FkTransactionId
Transactions.FKDataSetID FkMatchDataSetId
Transactions.FKMatchID FkMatchId
Transactions.FKReasonCodeID FkReasonCodeId
Transactions.TransactionID TransactionId
TransactionSupportDoc.DocID DocId
TransactionSupportDoc.FKTransactionID FkTransactionId

RCM Columns

OFC PV800 SV200 OFC PV840 SV100
TableName.OldColumnName NewColumnName
CloseDate.CloseDate CloseDateLocal

Migration

If you have reconciliations with a frequency other than monthly that migrate to OneStream Financial Close Release PV710 SV201 or later, you may need to mark these reconciliations as required in the current period and then run Discover for the current period. (MP1-4614, MP1-4688)

New Features

Account Reconciliations

None

Transaction Matching

None

Enhancements

Account Reconciliations

None

Transaction Matching

Watch to learn more (3:23).

  • The navigation pane has been redesigned and is now positioned on the left side of the solution. (MP1-4871)

  • Cancel option added to revert changes. (MP1-5034, MP1-5037)

  • Defer Refresh on Transactions page has been added to the User Preferences page. (MP1-5023)

  • The Reason Codes page is its own dedicated section under the Administration tab. (MP1-5073)

  • Clone has been updated to Copy. (MP1-4912)

  • Redesign of the Settings Page with sub-pages displayed horizontally and the selected sub-page underlined. Administrators will see Global Options as their default page and Non-Administrators will see User Preferences. (MP1-4892)

  • Addition of the Type column to the Match Sets subpage specifies the number of data sets to be created for each match set. (MP1-5039)

  • Scorecard and Analysis are now on separate pages. (MP1-4883, MP1-5996)

  • Redesign of the Rules page under Administration. (MP1-5087)

  • Redesign of the Fields section on the Data Sets page. (MP1-5081)

  • Redesign of the Rules Page filters under Administration. (MP1-4899)

  • Redesign of the Rules page Grouping functionality under Administration. The fields added under Definition are automatically added to Grouping. (MP1-5084)

  • Redesign of the Data Set Information on the Data Sets page. (MP1-4874)

  • The count of selections in Data Sets is displayed to verify information for each potential match prior to creating the match. (MP1-5020)

  • The Match Reason Code defaults back to unassigned enabling users to quickly make matches with different reason codes. (MP1-5021)

  • Require Match Reason Code was added to the Options page. (MP1-5022)

  • Enable Save State on Filtering on Transactions Table. (MP1-5024)

  • Tree view as added to the Rules page. (MP1-5086)

Fixed Issues

Account Reconciliations

  • Exponential values are allowed for decimals. (MP1-5066)

  • Past Due dates are calculating correctly. (MP1-6009)

  • Accounts were not being discovered if attributes were not active in the cube. (MP1-5019)

  • If Entity was numeric, the comma was removed in the template which created an error when uploading the template. (MP1-4964)

  • The user encountered an error during the export process, which was tracked back to a reconciliation associated with a workflow profile that has since been deleted. (MP1-4761, MP1-6445)

  • Amount was not being converted properly when uploading a multicurrency template due to a combination of comma/period handling which varies based on user's culture code. (MP1-4949)

  • Item Type was disabled and displaying as blank on the UI and Template, allowing the user to save the detail item when a validation should have displayed: Item Type is a required field. (MP1-5977, MP1-6004)

  • User and the Timestamp cannot be altered or saved when creating or editing detail items. (MP1-5074)

  • Users with multiple instances of OFC were unable to download audit packages for 2 or more recs upon selecting Audit. (MP1-5256)

  • If both Account and Entity were numeric values, the comma was removed in the template which created an error when uploading the template. (MP1-4964)

Transaction Matching

  • Text column displays the full field when exporting from the Transactions or Matches page. (MP1-4907)

  • Users can use Tm and TmT in match rule definition. (MP1-6307)

  • Copy Match Set is functional. (MP1-6324)

  • Admins and Approvers are able to Unmatch approved matches from Matches page. (MP1-5028)

  • Preparers and above can edit transactions for fields marked as editable unless transaction is matched. (MP1-5093)

  • When accessing a rule in TXM, when a Custom Filter is checked it becomes unchecked if the process sequence is altered and saved. (MP1-4742)

  • Filters not consistently applying on the export transactions page. (MP1-5063)

  • Validation error does not occur when making edits in the Notes field on transactions. (MP1-5840)

  • Users can edit the Notes field while the matching process is running. (MP1-5894)

Known Issues

Account Reconciliations

  • Users unable to download audit package for two or more reconciliations upon selecting Audit when more than one OFC instance is installed. Contact support if using MST copies to have multiple instances. Instructions will be provided to troubleshoot the issue for versions: OFC PV710 SV201, OFC PV710 SV202, OFC PV800 SV100, OFC PV800 SV200, OFC PV800 SV201.(MP1-5256, MP1-6010)

  • Preparers receive upcoming reconciliation notification when not belonging to the period. (MP1-5975)

  • The reconciliation status shows as "FrequencyChanged" and is only visible in the grid when utilizing the Miscellaneous filter. (MP1-3414)

  • Group 1 is not acquiring the frequency of Group 2 when moving an account from Group 1 to Group 2. (MP1-6392)

Transaction Matching

  • Custom events are no longer supported in this release (OFC PV840 SV100). If you are currently using custom events in your version of TXM, please contact OneStream Support. We are interested in learning about your use cases to inform potential enhancements in the future.

Contact Support

Contact OneStream Support by registering at:

Support - OneStream Software