/
UBT journal was posted twice

UBT journal was posted twice

Description of Issue

UBT Journal duplicated, needs one reversed

Context
  • Utility Billing

  • Journal Reversal

  • Journal Export

Cause

UBT Journal was posted twice

Resolution

Please contact the Utility Billing Support Team for assistance.


To correct the duplicate entry:

Financials > General Ledger Menu > Journal Entry/History > Export Journals

  1. Click Define

  2. Complete the appropriate fields needed (Click the checkbox next to: Omit automatically-generated lines)

  3. Click Accept

  4. Click Select

  5. Type in the Journal Year, Period, Journal number, etc

  6. Click Accept

  7. Click Journal Export

  8. In the pop up window check off every field that should display in the export

  9. Click Accept

  10. In the Excel export file, change the Debits to Credits and Credits to Debits (this will create the offsetting journal that is needed)

  11. Use the journal import program to import the excel file into the Year and Period that the corrective journal is needed (for Prior years only prior year period 13 can be posted to)

How to import a journal - Knowledge Assistant - Confluence

Additional Information










Related content

Journal Reversal - GRV - Duplicated additional lines included need to be corrected
Journal Reversal - GRV - Duplicated additional lines included need to be corrected
More like this
How to reverse a chargeback work order journal
How to reverse a chargeback work order journal
More like this
Reversal journal created incorrectly when removing existing match with multiple items in Bank Reconciliation Manager
Reversal journal created incorrectly when removing existing match with multiple items in Bank Reconciliation Manager
More like this
How to reverse a posted GEL Journal
How to reverse a posted GEL Journal
More like this
UB bills created in different fiscal year than journal entries created during Generate AR step of bill run
UB bills created in different fiscal year than journal entries created during Generate AR step of bill run
More like this
Reverse journals created by a Chargeback Work Order
Reverse journals created by a Chargeback Work Order
More like this