Enabling Mandatory flag on accounting dimension make account combination duplicate

Description

  1. Create a transaction in GL with different accounting combination say Account, Business partner, Project

  2. Create a transaction in GL with same values as in # for Account, Business Partner, Project and here add Activity.

  3. So in c_validcombination table there would be 2 lines as below

Account

BP

Project

Activity

A1

BP1

P1

A1

B1

P1

AC1

  1. Now got to accounting schema and made Activity dimension as mandatory and select default activity as AC1.

  2. System updates account combinations and facts with selected default activity in dimension where its NULL through update query. Being said that, below would be the combination table after update

Account

BP

Project

Activity

A1

BP1

P1

AC1

A1

B1

P1

AC1

Now try to create a GL with dimension as Account= A1, Business partner = BP1, Project = P1 and Activity as AC1, it will give an error "QueryMoreThanOneRecordsFound" because due to update combinations are not duplicate

Environment

None

Status

Assignee

Carlos Ruiz

Reporter

Pritesh Shah

Labels

None

Tested By

None

Priority

Critical
Configure