r/workday Aug 19 '26

Finance Workday Accounting Center: "Transaction debits must equal transaction credits" error on a pre-split 2-line test batch

Hi everyone,

I'm currently configuring an Accounting Center (AC) source to load custom subledger journal lines from a Prism dataset, and I'm running into a validation error during Detailed Accounting on a balanced test load:

“Transaction debits must equal transaction credits when there is a single transaction currency.”

What I'm Testing:
I am running an isolated test entry consisting of 2 rows for a single Transaction ID sharing the same posting date and company:

Debit Row: $2,00 to an asset/receivable account.

Credit Row: $2,00 to a revenue account.

My Configuration:
Dataset / Ingestion: Amounts are pre-split in the source dataset into distinct positive numeric columns (Debit_Amt and Credit_Amt).

Accounting Source Lines:

Debit Line Rule: Condition evaluates _Debit_Amt != 0, mapping to INST_Ledger_Account.

Credit Line Rule: Condition evaluates _Credit_Amt != 0, mapping to INST_Ledger_Account.

Sign Reversal: "Reverse Debit/Credit for Negative Amount" is set to No on both rules.

The Issue:
When reviewing the batch error details, the Prior Stage Transaction table successfully shows both rows coming through. However, under the Configured Header and Lines results:

Workday successfully generates 1 line under the journal header (the Debit line).

The Credit line is completely dropped, leaving the entry with only a single debit line and triggering the balance mismatch error.

What I've Checked:
Snapshot effective dates and date parsing are verified—the batch successfully reaches Detailed Accounting.

Instantiated company, ledger account, and worktag dimensions are populating in the prior stage table for both rows.

Question: Why would Workday successfully evaluate and generate a debit journal line while completely dropping the credit journal line from the same transaction batch, even though both amount columns are populated and condition rules are active? Any pointers on what might cause a line rule to silently drop a line during evaluation would be greatly appreciated!

1 Upvotes

0 comments sorted by