Automatic Offsets behavior in Accounts Payable: CM/DM with Mismatched Segments

Summary:

Hi everyone,

While the Automatic Offsets feature in Oracle Payables helps manage transactions involving multiple balancing segments, we noticed that when a credit/debit memo is applied to an invoice during payment creation, the system still allows the transaction to proceed even if the distribution combinations differ.

For Example:

Invoice Distribution:

Segment 1: Company A / Segmet 2: Building A / Segment 3: Natural Account / Amount 10,000

Credit Memo Distribution:

Segment 1: Company A / Segment 2: Building B / Segment 3: Natural Account / Amount 10,000

Although the transaction nets to zero, the mismtch in Segment 2 results in imbalances that remain open, which can lead to reconciliation issues and inaccurate segment level reporting.