My Oracle Support Banner

Intracompany Balancing Not Doing Summary Net as expected, More then one line Created for a BSV (Doc ID 1533359.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

intracompany balancing has been defined to use Summary net.. but the following journal posting resulted which
appears to be incorrect:

Where the second segment is the BSV value - all are assigned to the same Legal Entity

Line Account Entered:                                  Debit Entered:          Credit           Description
1 T090827.XX.000.4010100.46109110.9230       350.00                          Bank Charges
2 T090827.XX.000.6011000.46109110.9230     3,300.00                          Bank Charges
3 T090827.XX.000.1013000.46109110.9230                           43,250.00  Bank Charges
4 T090827.XX.000.4010100.46109110.9230  17,750.00                           Bank Charges
5 T090827.XX.000.5053990.46109110.9230       300.00                           Bank Charges
6 T090827.XX.000.7018600.46109110.9230    4,974.00                           Bank Charges
7 T090827.XX.000.7018700.46109110.9230    1,226.00                           Bank Charges
8 T090827.XX.000.4012050.46109110.9230  15,350.00                            Bank Charges
9 T090827.XX.000.6000000.81101110.1080                             3,300.00   Intracompany balancing line added by Posting
10 T090827.XX.000.4000000.81101110.1080                         15,350.00   Intracompany balancing line added by Posting
11 T090827.XX.000.4000000.81101110.1080                             350.00   Intracompany balancing line added by Posting
12 T090827.XX.000.4000000.81101110.1080                         18,050.00   Intracompany balancing line added by Posting
13 T090827.XX.000.7000000.81101110.1080                           6,200.00   Intracompany balancing line added by Posting

14 T090827.XX.000.1000000.81101110.1080  3,300.00                            Intracompany balancing line added by Posting +++
15 T090827.XX.000.1000000.81101110.108015,350.00                            Intracompany balancing line added by Posting +++
16 T090827.XX.000.1000000.81101110.1080     350.00                            Intracompany balancing line added by Posting +++
17 T090827.XX.000.1000000.81101110.1080 18,050.00                            Intracompany balancing line added by Posting +++
18 T090827.XX.000.1000000.81101110.1080  6,200.00                            Intracompany balancing line added by Posting  +++
#Expectation is that these lines should all be on one line +++

 

Per the AGIS user guide the following behavior is what is expected:
• Summary Net: If you select Summary Net, the Balancing API summarizes the
debits and credits for each balancing segment value on the journal, determines the
overall net debit or net credit for each balancing segment value, balances using the
net amounts for each balancing segment value, and produces a summary balancing
line for each balancing segment value.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.