AXXPSMAN - "unbalanced accounting entries" Translation Error in AX Inventory for Intransit Shipments with FOB Point=Shipment
Last updated on DECEMBER 20, 2017
Applies to:Oracle Global Accounting Engine - Version 22.214.171.124 and later
Information in this document applies to any platform.
Executable:AXXPSMAN - Posting Manager
Executable:AXXPSETR - Event Translation Report
On release 126.96.36.199:
Find stuck events in AX Inventory with the following error in the Event Translation Report (AXXPSETR).
Related Inventory transaction type is Int Order Intr Ship.
Issue originally reported for INV_EVENT_211TO AX Event type (profile "CST: Transfer Pricing Option" is set to No), but the problem would occur with other Event Types like "INV_EVENT_211..."
At shipping network level, transfer type is Intransit and FOB is set to Shipment.
"The translation of the event ... has generated unbalanced accounting entries in the posting set of books ..."
The issue can be reproduced at will with the following steps:
1. Select the AX Inventory responsibility for the problematic set of books.
2. Go to Submit Posting Manager form.
AX Inventory: (N) Accounting Close Cycle > Post Transactions
3. Press button Submit.
4. Close the form.
5. Go to View Requests window.
6. Once the AX Posting Manager completed, review the Event Translation Report.
Due to this issue, a large and increasing amount of accounting data are missing in AX Inventory and then in General Ledger.
The problem started to occur after patching AX Inventory, for instance after applying <Patch:12579221>. Same kind of events were successfully translated prior to applying the patch.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms