Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
20D Manage Dependencies Between Chart of Accounts Segments Using Related Value Sets — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

20D Manage Dependencies Between Chart of Accounts Segments Using Related Value Sets

Received Response
37
Views
4
Comments
edited Mar 8, 2021 5:37PM in General Ledger & Intercompany 4 comments

Summary

This validation is bypassed by SLA. Is this intended feature?

Content

We are looking for similar feature that is currently only available for natural account segment i.e restrict manual journals. We want to use this feature on another segment of COA i.e fund type and we want to restrict certain fund types for manual entry including expense reports. So, while testing this related value sets feature, we found that our requirement can be met by this feature (to our surprise!).

In our test case we added a related value set for the company segment and added related department values. As per the rule only departments 1010 to 1018 are valid with company 100. We have SLA rules in projects that uses department 1019 with certain projects and after enabling the related value set, we verified we can't create any manual journals or use department 1019 in expenses with company 100. However when we generated accounting for project costs, it generated a combination using company 100 and department 1019 and posted successfully to GL. Even though this is the exactly the

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!