E1: 42: Sales Update (R42800) Inventory G Batch Fails Post (R09801)

(Doc ID 2358952.1)

Last updated on FEBRUARY 08, 2018

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Sales Update (R42800)
G/L Post (R42800)

When attempting to post a Summarized COGS Inventory Batch (939583 G) created by Sales Update (R42800), the batch fails with a post out of balance error.

Out of Balance Post Error Report (R09801E) PDF for G Batch 939583 shows the following:

The issue ocurred for one Sales Update (R42800) job with the following steps:

  1. The user submitted one Sales Update job to process two type of orders
    1. The sales update version selected was set to Summarize COGS and Inventory Batch 939583 G.
    2. The sales update version selected was set to update inventory
    3. The invoice RM 5064302 was a Financial Only Credit Invoice that should have bypassed inventory
    4. All other invoices were for lot controlled inventory items that should update inventory
  2. At Sales Update there was a Work Center Error for credit invoice RM 5064302 stating Lot/Serial Number required and the invoice was rejected from the Sales Batch 939581 IB.
  3. Summarized COGS Inventory Batch 939583 G had no errors at Sales Update.
  4. When the G/L Post (R09801) was run on the Sales Batch 939581 IB the post was successful because Debits equaled Credits.
  5. When the G/L Post (R09801) was run on the COGS Inventory Batch 939583 G there was a Post Out of Balance Error because the batch was -30,864.80 out of balance.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms