Microsoft_MVP_banner

AX 2012 – Create and Post hour journal through X++

Following job can be used to create, validate, and post hour journal in Project Management and Accounting module in AX 2012 R3.


static void createHourJournal(Args _args)
{
    ProjJournalTableData    JournalTableData;
    ProjJournalTransData    journalTransData;
    ProjJournalTable        journalTable, journalTableUpdate;
    ProjJournalTrans        journalTrans;
    ProjTable               projTable;
    ProjInvoiceTable        projInvoiceTable;
    NumberSeq               numberSeq;
    ProjJournalCheckPost    jourPost;
    ProjQtyEmpl             qty;
    JournalNumOfLines       numOfLines;
    ttsBegin;
    journalTableData = JournalTableData::newTable(journalTable);
    journalTransData = journalTableData.journalStatic().newJournalTransData(journalTrans, journalTableData);
    // Init JournalTable -- header
    journalTable.clear();
    journalTable.JournalId      = journalTableData.nextJournalId();
    journalTable.JournalType    = ProjJournalType::Hour;
    journalTable.JournalNameId  = MROParameters::find().JournalHour;
    journalTable.initFromProjJournalName(ProjJournalName::find(journalTable.JournalNameId));
    journalTable.insert();
    // Init JournalTrans -- lines
    journalTableData.initFromJournalName(journalTableData.journalStatic().findJournalName(journalTable.JournalNameId));
    journalTrans.clear();
    journalTransData.initFromJournalTable();
    projTable           = ProjTable::find('000057');
    projInvoiceTable    = projTable.projInvoice();
    journalTrans.setTransDate();
    journalTrans.TransDate      = systemDateGet();
    journalTrans.ProjTransDate  = systemDateGet();
    journalTrans.ProjId         = projTable.ProjId;
    journalTrans.Qty            = 7.5;
    journalTrans.CategoryId     = 'Category ID';
    journalTrans.LinePropertyId = 'Line property ID';
    journalTrans.Worker         = DirPersonUser::currentWorker();
    journalTrans.ActivityNumber = 'Activity number';
    journalTrans.Txt            = 'Sample Text';
    if (projInvoiceTable.CurrencyId)
        journalTrans.CurrencyId = projInvoiceTable.CurrencyId;
    else
        journalTrans.CurrencyId = CompanyInfo::standardCurrency();
    journalTrans.DefaultDimension   = projTable.DefaultDimension;
    journalTrans.TaxGroupId         = ProjParameters::taxGroupInvoice(projTable.ProjId);
    if (journalTrans.Worker)
    {
        journalTrans.setHourPrices();
        journalTrans.setPeriodDate();
    }
    numberSeq = NumberSeq::newGetVoucherFromId(journalTable.VoucherNumberSequenceTable, false);
    journalTrans.Voucher        = numberSeq.voucher();
    journalTransData.create();
    ttsCommit;
   
    // Validating the journal
    jourPost = ProjJournalCheckPost::newJournalCheckPost(true,true,JournalCheckPostType::Check,tableNum(ProjJournalTable),journalTable.JournalId);
   
    // Posting the journal
    jourPost = ProjJournalCheckPost::newJournalCheckPost(true,true,JournalCheckPostType::Post,tableNum(ProjJournalTable), journalTable.JournalId);
    jourPost.run();
}

Share:

Related Posts

Microsoft Copilot
admin

Exploring Microsoft Copilot Architecture

Microsoft Copilot isn’t just another AI tool; it’s a comprehensive platform designed to be your indispensable companion, enhancing productivity, fostering creativity, and facilitating information comprehension all through a user-friendly chat interface. The concept of Copilot emerged two years ago when Microsoft introduced GitHub Copilot, aiming to assist developers in writing

Read More »
How to enable new Microsoft teams - Public Preview!
Microsoft Teams
Faisal Fareed

How to enable new Microsoft teams – Public Preview!

New Microsoft Teams is just AWESOME, quick but useful post below shows how you have this preview feature to make your life EASY!  Open Microsoft Teams admin center [Ask admin in your organization if you don’t have access] and follow path Teams > Teams update policies > Click on an existing

Read More »

Send Us A Message

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Post

Exploring Microsoft Copilot Architecture

Exploring Microsoft Copilot Architecture

Microsoft Copilot isn’t just another AI tool; it’s a comprehensive platform designed to be your indispensable companion, enhancing productivity, fostering creativity, and facilitating information comprehension all through a user-friendly chat interface. The concept of Copilot emerged two years ago when Microsoft introduced GitHub Copilot, aiming to assist developers in writing…

How to enable new Microsoft teams – Public Preview!

How to enable new Microsoft teams – Public Preview!

New Microsoft Teams is just AWESOME, quick but useful post below shows how you have this preview feature to make your life EASY!  Open Microsoft Teams admin center [Ask admin in your organization if you don’t have access] and follow path Teams > Teams update policies > Click on an existing…

Electronic Reporting: Send vendor payments to external azure storage via X++

Electronic Reporting: Send vendor payments to external azure storage via X++

Electronic Reporting module in Microsoft Dynamics 365 Finance Operation lets you archive file generated by ER at SharePoint location and in Azure Storage as per this link Archive ER destination type – Finance & Operations | Dynamics 365 | Microsoft Learn. APIs can be used to check message status and read…

FaisalFareed@2025. All rights reserved

Design by T3chDesigns