Dynamics Community Forum Thread Details

Customer Payment Journal Created but Not Posted (Voucher Does Not Balance Error in X++)

Hi Everyone,

I tried to create and post a Customer Payment Journal programmatically in Dynamics 365 Finance & Operations (X++) I followed several articles and examples.

The journal is created successfully but when the posting runs, the journal is cancelled and I get the following error

Voucher CRJ-003625: The transactions on voucher CRJ-003625 do not balance as per 1/7/2026.
(Accounting currency: -1,500,000.00, Reporting currency: -1,500,000.00)

Voucher transactions:
Voucher: CRJ-003625
Date: 1/7/2026
Account: 161100..
Transaction currency amount: -1,500,000.00
Accounting currency amount: -1,500,000.00
Reporting currency amount: -1,500,000.00
Currency: IQD
Text: Create and post test customer payment journal.

The journal header and the transaction line are created but the journal does not post.

What is my mistake in the code? I want to create a normal Customer Payment Journal and create its transaction line correctly

Post the journal automatically without getting a balance error

Any guidance on what is missing or incorrectly set (offset account, debit/credit logic, dimensions, etc.) would be appreciated.

here is the code I used:

 public static void main(Args _args)
{
    Ledgerjournalname       ledgerjournalname;
    LedgerjournalTable      LedgerjournalTable;
    LedgerjournalTrans      LedgerjournalTrans;
    LedgerjournalCheckPost  LedgerjournalCheckPost;
    NumberSeq               numberSeq;
    

    
    AccountNum customerAccount = 'C-000012';

    
    select ledgerjournalname
        where ledgerjournalname.JournalName == "CRJ";

    ttsBegin;
    LedgerjournalTable.JournalName = ledgerjournalname.JournalName;
    LedgerjournalTable.initFromLedgerJournalName();
    LedgerjournalTable.JournalNum =
        JournalTableData::newTable(LedgerjournalTable).nextJournalId();
    LedgerjournalTable.insert();
    ttsCommit;

    ttsBegin;
    numberSeq =
        NumberSeq::newGetVoucherFromId(ledgerjournalname.NumberSequenceTable);

    LedgerjournalTrans.Voucher     = numberSeq.voucher();
    LedgerjournalTrans.JournalNum = LedgerjournalTable.JournalNum;
    LedgerjournalTrans.CurrencyCode =
        Ledger::accountingCurrency(CompanyInfo::current());

    LedgerjournalTrans.AccountType = LedgerJournalACType::Cust;
    LedgerjournalTrans.parmAccount(
        customerAccount,
        LedgerjournalTrans.AccountType
    );

    LedgerjournalTrans.Txt = 'Create and post test customer payment journal';

    LedgerjournalTrans.ExchRate =
        ExchangeRateHelper::exchRate(LedgerjournalTrans.CurrencyCode);

    LedgerjournalTrans.AmountCurCredit = 1500000; 

    LedgerjournalTrans.TransDate  = systemDateGet();

    LedgerjournalTrans.OffsetAccountType =
        LedgerJournalACType::Ledger;

    LedgerjournalTrans.parmOffsetAccount(
        ledgerJournalTable.parmOffsetAccount(),
        ledgerJournalTable.OffsetAccountType
    );

    LedgerjournalTrans.OffsetLedgerDimension =
        LedgerjournalTable.OffsetLedgerDimension;

    LedgerjournalTrans.DefaultDimension =
        CustTable::find(customerAccount).DefaultDimension;

    LedgerjournalTrans.OffsetDefaultDimension =
        CustTable::find(customerAccount).DefaultDimension;

    LedgerjournalTrans.insert();
    ttsCommit;

    LedgerjournalCheckPost =
        LedgerjournalCheckPost::newLedgerJournalTable(
            LedgerjournalTable,
            NoYes::Yes
        );

    LedgerjournalCheckPost.run();

    info("Customer journal has been created");
}

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

Quick Links