E1: 42: Sales Update (R42800) Creates Out of Balance G Batch When Bypassing Accounts Receivable for Sales Order with Stock and Freight Lines (Doc ID 2517067.1)

Last updated on JULY 09, 2021

Applies to:

Symptoms

Sales Update Not Creating Appropriate G/L Records . The G Batch created by Sales update running over "Freight" records (Line type FA) has an imbalance error and the system does not create an A/R Trade line for the last freight line. It creates the appropriate G/L records for all prior FA lines. 

Steps:
The issue can be reproduced at will with the following steps:
1. Create a line type 'FA' or similar; in the P40205, the option to interface with AR is unchecked.  
2. Create Item Master "Freight" and assign line type "FA"
3. Create multiple Sales orders - combination of "S" - stock and "FA" freight lines.
4. Run R42800 for the "S" lines of the orders created in #3.
5. Run R42800 for the "FA" lines of the orders created in #3 - with the R42800 set to 'Bypass A/R' and with Summarization set (first two options)
6. Post the G Batch using R09801 and an Out Of Balance report is generated.

Changes

Cause

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