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

Visit Redwood Community
User Defined Formula in Accounting Hub — 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

User Defined Formula in Accounting Hub

Received Response
13
Views
1
Comments
edited Aug 13, 2021 5:28PM in Subledger Accounting & Accounting Hub 1 comment

Summary

User Defined Formula in Accounting Hub

Content

We want to use the User Defined Formulas for the below scenario

The Journal Line value is of Credit in nature. However, when the source file is generated, it is generated as (1351). Since the Journal Line is of Credit in Nature and the source file has (1351), when the transaction is imported, the JE line value will be 1351. How to define the rule, when the Accounting Category is XXXXXX, the output should be "value of account category) multiplied with -1, so that the value is shown as credit.

Version

11.13.21.07.0

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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