Finance | Project Operations, Human Resources, ...

create and post general journal using code

(0) Share

Report

Posted on by Dineshkarlekar

1,790

Hi Everyone,

I was trying to create and post general journal from ledger to vendor but in debugger i am getting the offsetledger dimension value zero can you please check my code and let me know what i am doing wrong .

public class journalPost
{
    public static void main(Args _args)
    {
        ClaimHeader journalTable;
        ClaimLine   journalTableLine;
        journalTable = _args.record();

        if (!journalTable)
        {
            throw error("No journal selected.");
        }

        LedgerJournalTable       ledgerJournalTable;
        LedgerJournalTrans       ledgerJournalTrans;
        LedgerJournalCheckPost   journalCheckPost;
        LedgerJournalName        ledgerJournalName;
        TrvParameters            trvParameters;
        Ledger                   currentLedger;
        Ledger                   ledgerFromFind;
        VendTable                vendTable;
      	ClaimType  		 claimtype;
        TransDate                transDate;
        NumberSeq                numberseq;
        ExchRate                 exchangeRate;
        Voucher                  voucher;
        RecId                    ledgerRecId;
        CurrencyCode             fromCurrency,toCurrency;


        select JournalName from  trvParameters;

        // Header
        ledgerJournalTable = null;
        ledgerJournalTable.company(curext());
        ledgerJournalTable.JournalName = trvParameters.JournalName;
        ledgerJournalTable.initFromLedgerJournalName();
        ledgerJournalTable.NumberSequenceTable = ledgerJournalName.NumberSequenceTable;
        ledgerJournalTable.insert();

        if (ledgerJournalTable.RecId)
        {
            // Line
            ledgerJournalTrans.clear();
            ledgerJournalTrans.Company = curext();
            ledgerJournalTrans.JournalNum = ledgerJournalTable.JournalNum;
            ledgerJournalTrans.TransDate = journalTable.EventDate;
            ledgerJournalTrans.LineNum = LedgerJournalTrans::lastLineNum(ledgerJournalTrans.JournalNum);

            voucher = new JournalVoucherNum(JournalTableData::newTable(ledgerJournalTable)).getNew(false);

            ledgerRecId = Ledger::current();

            ledgerFromFind = Ledger::find(ledgerRecId);
            fromCurrency = ledgerFromFind.AccountingCurrency;

            vendTable = VendTable::find("1001");
            toCurrency = vendTable.Currency;

            transDate = systemDateGet();

           exchangeRate = ExchangeRateHelper::MCRGetExchangeRate( fromCurrency,
                                                                  toCurrency,
                                                                  transDate
                                                                );

            ledgerJournalTrans.Voucher = voucher;
            ledgerJournalTrans.CurrencyCode = ledgerFromFind.AccountingCurrency;

            select Amount from journalTableLine 
                where journalTableLine.ClaimHeader == journalTable.RecId;

            ledgerJournalTrans.AmountCurDebit = journalTableLine.Amount;
            ledgerJournalTrans.ExchRate =  exchangeRate;

            select firstonly claimtype
                where claimtype.ClaimType == journalTable.ClaimType;

            ledgerJournalTrans.AccountType = claimtype.AccountType;
            ledgerJournalTrans.LedgerDimension = claimtype.LedgerDimension;

            ledgerJournalTrans.OffsetAccountType = claimtype.OffsetAccountType;

            // Get MainAccountNum
            MainAccount  mainAccount = mainAccount::findByMainAccountId(claimtype.OffsetAccount);
            RecId  vendorMainAccount = mainAccount.RecId;

            if ( claimtype.OffsetAccountType == LedgerJournalACType::Vend)
            {
                ledgerJournalTrans.OffsetLedgerDimension = LedgerDimensionFacade::serviceCreateLedgerDimension(vendorMainAccount);
                                                                                                               
            }
            else
            {
                ledgerJournalTrans.OffsetLedgerDimension = claimtype.OffsetLedgerDimension;
            }

            ledgerJournalTrans.insert();

            if (ledgerJournalTrans.RecId)
            {
                // Posting
                journalCheckPost = LedgerJournalCheckPost::newLedgerJournalTable(ledgerJournalTable, NoYes::Yes);
                journalCheckPost.runOperation();

                ledgerJournalTable.reread();
                if (ledgerJournalTable.Posted == NoYes::Yes)
                {
                    info(strFmt("Journal %1 has been created and posted.", ledgerJournalTable.JournalNum));
                }
            }

        }
    }

}

Categories:

Dynamics 365 Project Operations

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 297,242 Super User 2025 Season 2 on at

Like (0)

Report

create and post general journal using code

Hi Dinesh,

I think the ClaimType object is a custom table in your environment? Can you tell us is this is a shared table or per company? What exact value are you storing in the field OffSetLedgerDImension? Is it a main account, default dimensions, or main account with dimensions?

During the debugger, did you find a record in the ClaimTable? Are all offset ledger account values zero or only for vendors or ledger?

Was this reply helpful? Yes No
Dineshkarlekar 1,790 on at

Like (0)

Report

create and post general journal using code

thanks for reply ,

@Sagar121

I have check in sql the value for the mainAccount.OffsetLedgerDimension and vendtable.OffsetLedgerDimension is zero so if i use it , it will not hget any value to pass .

Thanks,

Was this reply helpful? Yes No
Suggested answer

Sagar121 283 on at

Like (2)

Report

create and post general journal using code

Hi , Can you please try this.

if ( claimtype.OffsetAccountType == LedgerJournalACType::Vend)

{

ledgerJournalTrans.OffsetLedgerDimension = LedgerDimensionFacade::serviceCreateLedgerDimension(mainAccount.OffsetLedgerDimension);

}

else

{ ledgerJournalTrans.OffsetLedgerDimension = claimtype.OffsetLedgerDimension;

}

1 people found this reply helpful.

Was this reply helpful? Yes No
Dineshkarlekar 1,790 on at

Like (0)

Report

create and post general journal using code

thanks for reply @Rahul T,

is it possible to create new dimension for vendor , or get dimension from vendor , i cannot pass it from claim type if i am passing it for vendor.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Rahul T 29 on at

Like (1)

Report
create and post general journal using code

Hi Dinesh,

Regarding the else part of the code, there is currently no validation to check whether the claimtype.OffsetLedgerDimension is null, unset, or outdated. If this value is null, it may lead to an invalid or incorrect offset ledger dimension on the journal entry line.

else { ledgerJournalTrans.OffsetLedgerDimension = claimtype.OffsetLedgerDimension; }

It is advisable to implement a validation step to ensure that claimtype.OffsetLedgerDimension is not null and that it accurately corresponds to a valid financial dimension before assigning it. This will help prevent potential errors in the journal posting process.

Was this reply helpful? Yes No
CU02090655-2 on at

Like (0)

Report

create and post general journal using code

The primary reason for the zero OffsetLedgerDimension is that you are passing the RecId of the vendor's main account to LedgerDimensionFacade::serviceCreateLedgerDimension(), which expects the string value of the account number. You should change the parameter to claimtype.OffsetAccount. Additionally, your code tries to use trvParameters.JournalName before you have selected the record from the database, which will cause the journal header creation to fail.

Was this reply helpful? Yes No

Community site session details

create and post general journal using code

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

create and post general journal using code

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates