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

SQL script to get Manage Intercompany Balancing Rules

in General Ledger & Intercompany 3 comments

We checked fun_bal_inter_rules and FUN_BAL_INTER_ACCOUNTS_ADDL tables.
fun_bal_inter_rules table stores FROM_LEDGER_ID, TO_LEDER_ID, FROM_LE_ID and TO_LE_ID as -1 value. TRX_TYPE_ID is -1 or -2.
FUN_BAL_INTER_ACCOUNTS_ADDL does not have JE_SOURCE, JE_CATEGORY and TRX_TYPE_ID.
We need SQL script to get ChartofAccounts, ReceivablesAccount, PayablesAccount, StartDate, EndDate, Source, Category and TrxType.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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