My Oracle Support Banner

WS: 03: 04: 09: Posted Intercompany Settlement Automatic Entries (AEs) are Deleted When Trying to Post a Void Batch to a Prior Period (P09870) (Doc ID 2996688.1)

Last updated on JANUARY 08, 2024

Applies to:

JD Edwards World General Ledger - Version A9.4 and later
Information in this document applies to any platform.

Symptoms

Posted Intercompany Settlement Automatic Entries (AEs) are deleted when a Journal Entry is entered and posted in one period then voided in the same period, but the void submitted to post in the next period. The issue occurs when prior period posting is not allowed (Allow PBCO Posting = N in the General Accounting Constants, P000909).

Steps:

  1. Set General Accounting Constants, fast path 9K or G0941/2 (P000909):
    1. Set Allow PBCO Postings (Y/N) to N
    2. Set Intercompany Settlement (Y/D/C/1/2/3/*/N) to 1

  2. Add new companies, in Company Numbers & Names, fast path CO or G09411/2 (P00105):
    1. Add Companies 00180, 02110, 10620, 10673 and 11799 - page down to the first blank line, enter A (Add) in the Action Code field and enter the company numbers 
    2. Attach each company to a fiscal, December through November, date pattern code (create a new date pattern if this fiscal date pattern does not exist)
    3. Set each Company to Period 1 of Fiscal Year 23 (December 2023)

  3. Add a Business Unit to each company, in Business Units by Company, G09411/3 (P0006A) - inquire on each company, enter A (Add) in the Action Code field and add Business Units as follows:
    1. Company 00180, add Business Unit 18000 (this is the Intercompany Hub Company)
    2. Company 02110, add Business Unit 211000 (a subsidiary company)
    3. Company 10620, add Business Unit 1062000 (a subsidiary company)
    4. Company 10673, add Business Unit 1067300 (a subsidiary company)
    5. Company 11799, add Business Unit 1179900 (a subsidiary company)

  4. Add accounts to each Business Unit created in #3, in Copy Accounts to Business Units, G09411/18 (P09804):
    1. Copy accounts from Model Business Unit MD, to each business Unit added in Step 3, Beginning Account Object 1000 - Ending Account 9999

  5. Add Intercompany Settlement Automatic Accounting Instructions (AAIs) for the Hub and Subsidiary Companies, fast path AAI or G0941/3 and use F16 to access Multiple AAI Revisions (P00122):
    1. Hub Company - Inquire on Item Number ICH* - set with Company 00000 - Business Unit 18000 - Object 1291
    2. Subsidiary Companies - Inquire on Item Number ICCC* and add the following:
      1. Company 02110 - Business Unit 211000 - Object 1291
      2. Company 10620 - Business Unit 1062000 - Object 1291
      3. Company 10673 - Business Unit 1067300 - Object 1291
      4. Company 11799 - Business Unit 1179900 - Object 1291

  6. Enter a Journal Entry, fast path JE or G0911/2 (P09101):
    1. Action Code = A
    2. Document Type = JE
    3. Explanation (e.g. I/C AE on Void PBCO N)
    4. G/L Date 12/31/23
    5. Account No. 211000.6030             Amount 1,135.30
    6. Account No. 1062000.1105           Amount 1,135.30-
    7. Account No. 1062000.6030           Amount 11,041.85
    8. Account No. 1062000.1110.BEAR  Amount 11,041.85-
    9. Account No. 1062000.6040           Amount 15,875.25
    10. Account No. 1062000.1133           Amount 15,875.25-
    11. Account No. 1067300.6030           Amount 21,420.00
    12. Account No. 1067300.1105           Amount 21,420.00-
    13. Account No. 1067300.6170           Amount 153,179.05
    14. Account No. 1067300.1133           Amount 153,179.05-
    15. Account No. 1179900.6030           Amount 500.00
    16. Account No. 1179900.1105           Amount 500.00-


  7. Review and approve the batch created in #6, General Journal Review, G0911/7 (P00201):
    1. Enter the Batch Number in the Batch Number field, press enter
    2. Review, enter 1 in the option field, press enter
    3. Approve (if required), enter A in the App field and press enter

  8. Submit the Batch to Post, G0911/8 (P09870):
    1. Enter the Batch Number created in Step 6 in the Batch Number field and press enter

  9. Review the Posting Edit Report, R09870:
    1. Enter 33 on the command line, press enter
    2. Enter 8 in the Opt field next to Job J09870xxx, press enter
    3. Enter 5 in the Opt field next to File R09870, press enter
    4. Page down to view Error Messages: "Intercompany settlements to be made as follows:" and **NO ERRORS** batch will post"

  10. Repeat steps in #9 to review the Posting Journal, R09871, and note the JEs and four Intercompany Settlement AEs created by the Post Program (Subsidiary Companies 02110 and 10620 settle with each other and with the Hub Company, 00180)

  11. Void the batch created in #6 while still in Period 1 of Fiscal Year 23 (December 2023):
    1. Go to G0911/7 (P00201) General Journal Review 
    2. Enter the Batch Number in the Batch Number field, press enter
    3. Enter 1 in the Option field next to the JE, press enter
    4. Enter C (Change) in the Action Code field and V in the Reverse or Void field, press enter
    5. DO NOT POST THE VOID

  12. Advance all companies to period 2 of fiscal year 23 (January 2024):
    1. Go to Company Numbers & Names, Fast path CO or G09411/2 (P00105)
    2. Enter C (Change) in the action code field, and set each Company to Period 2, press enter

  13. Review and approve the Void batch, General Journal Review, G0911/7 (P00201):
    1. Enter the Batch Number in the Batch Number field, press enter
    2. Review, enter 1 in the option field next to the JE, press enter
    3. Approve (if required), enter A in the App field and press enter

  14. Submit the Void Batch to Post, G0911/8 (P09870):
    1. Enter the Batch Number created in #6 in the Batch Number field and press enter

  15. Review the Posting Edit Report, R09870:
    1. Enter 33 on the command line, press enter
    2. Enter 8 in the Opt field next to Job J09870xxx, press enter
    3. Enter 5 in the Opt field next to File R09870, press enter
    4. Page down to view Error Messages: "G/L date is PBCO, and PBCO posting is not allowed"; "** ERRORS in batch. Batch will not post."; "ERROR: Intercompany settlements will be made to a G/L date which is PBCO or PYE"

  16. Review the Batch, General Journal Review, G0911/7 (P00201):
    1. Enter the Batch Number in the Batch Number field, press enter
    2. Enter 1 in the Opt field, press enter
    3. NOTE: The Intercompany AE entries are gone

  17. Run a General Journal by Batch, G0911/20 (P09301), use data selection to select the Batch Number or use a query tool and query the F0911 Account Ledger file by the Batch Number, and note the original Intercompany Settlement AEs are gone

The F0911 Account Ledger file is now out of balance with the F0902 Account Balances file.

The issue also exists with Accounts Payable Vouchers and Accounts Receivable Invoices, and will be address in the bug referenced below.

 

Changes

Upgrade to A9.4.0.2. 

Cause

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
Symptoms
Changes
Cause
Solution
References


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