Skip to main content
Skip table of contents

Revenue Accounting - Journal Results missing Adjustment/Reversal Records

🤔 Problem

For client CHS (Jayhawk Pipeline), the Journal Results Screen did not match the invoices for multiple shippers. The issue was first noticed with Valero Marketing (the smallest invoice), but affected all shippers/invoices. The root cause was missing “A” (Adjustment) and “R” (Rebook) codes in the Row Code for the PPA (Purchase Price Adjustment) timelines.

🌱 Solution

Root Cause:
A glitch in the application prevented the PPA timeline from setting journal records to ‘closed’, which is required to trigger adjustments and reversals in Journal Results. When the records are not marked closed, A/R records will not generate in Journal.

Resolution Steps:

  1. Database Correction:
    The following SQL script was used to set the relevant records to closed for the affected asset and accounting date:

    CODE
    update moments set closed = 1 where asset_id = 1 and accounting_date = '2025-08-01'
    update batch_groups set closed = 1 where id in (471,477,478,479)
    update allocated_results set closed = 1 where asset_id = 1 and accounting_date = '2025-08-01' and closed != 1
    update shipper_allocations set closed = 1 where asset_id = 1 and accounting_date = '2025-08-01' and closed != 1
    update movements set closed = 1 where asset_id = 1 and accounting_date = '2025-08-01' and closed != 1
    update accounting_results set closed = 1 where asset_id = 1 and accounting_date = '2025-08-01' and closed != 1
    update journal_results set closed = 1 where asset_id = 1 and accounting_date = '2025-08-01' and closed != 1
  2. Process Control Steps:

    • Navigate to Asset Process Control → Accounting Dates.

    • “Reopen” the 9/1/25 accounting date.

    • Select ‘View Production Dates’ for 9/1/25 and reopen all production dates.

    • Go back to Process Control and run the Journal Interface process for all open dates (April through August), in chronological order.

    • Verify Journal Results match expectations.

    • Re-close all batch processes associated with the 9/1/25 accounting date.

Outcome:
After running the script and following the process steps, the Journal Results matched the invoices as expected.

📎 Related Tickets

WESS-16742

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.