Working with the LedgerGeneralJournalService AX 2012

Hi There!

I hope everyone had a good week and that you are ready for an excellent weekend.

As you may well be aware by now, in AX 2012 you can import data by using services. You can use these services to import Customers, GL transactions, Products, etc.

You can learn more about services and AIF in one of my posts called Microsoft Dynamics AX 2012 Services and (Application Integration Framework) AIF architecture , and you might want to take a look into Services and Application Integration Framework .

On this post, I would like to share with you some code to import GL transactions into AX 2012 using the LedgerGeneralJournalService available in AX 2012.

static void ImportGLTransWithLedgerGeneralJournalService(Args _args)

{

    // Set these variables.

    LedgerJournalNameId                     journalName = 'GenJrn';

    SelectableDataArea                        company = 'CEU';

    TransDate                                     transactionDate = 10\10\2012;

    str                                     line1MainAccount = '256369';

    str                                     line1FullAccount = '256369--';

    str                                     line2MainAccount = '400090';

    str                                     line2FullAccount = '400090-10-';

    str                                     line2Dimension1Name = 'BusinessUnit';

    str                                     line2Dimension1Value = '10';

    LedgerGeneralJournalService             ledgerGeneralJournalService;

    LedgerGeneralJournal                       ledgerGeneralJournal;

    AfStronglyTypedDataContainerList              journalHeaderCollection;

    LedgerGeneralJournal_LedgerJournalTable   journalHeader;

    AifEntityKeyList                                         journalHeaderCollectionKeyList;

    RecId                                                       journalHeaderRecId;

    AfStronglyTypedDataContainerList                   journalLineCollection;

    LedgerGeneralJournal_LedgerJournalTrans       journalLine1;

    AifMultiTypeAccount                                       journalLine1LedgerDimension;

    LedgerGeneralJournal_LedgerJournalTrans       journalLine2;

    AifMultiTypeAccount                                       journalLine2LedgerDimension;

    AifDimensionAttributeValue                             journalLine2Dim;

    AfStronglyTypedDataContainerList                   journalLine2DimCollection;

    ;

    ledgerGeneralJournalService = LedgerGeneralJournalService::construct();

    ledgerGeneralJournal = new LedgerGeneralJournal();

    // Create journal header.

    journalHeaderCollection = ledgerGeneralJournal.createLedgerJournalTable();

    journalHeader = journalHeaderCollection.insertNew(1);

    journalHeader.parmJournalName(journalName);

    // Create journal lines.

    journalLineCollection = journalHeader.createLedgerJournalTrans();

    // Line 1

    journalLine1 = journalLineCollection.insertNew(1);

    journalLine1.parmLineNum(1.00);

    journalLine1.parmCompany(company);

    journalLine1.parmTransDate(transactionDate);

    journalLine1.parmAccountType(LedgerJournalACType::Ledger);

    journalLine1.parmTxt('AX Wonders Journal Import test');

    journalLine1.parmAmountCurDebit(235.00);

 

    // Define Ledger Dimensions

    journalLine1LedgerDimension = journalLine1.createLedgerDimension();

    journalLine1LedgerDimension.parmAccount(line1MainAccount);

    journalLine1LedgerDimension.parmDisplayValue(line1FullAccount);

    journalLine1.parmLedgerDimension(journalLine1LedgerDimension);

    // Line 2

    journalLine2 = journalLineCollection.insertNew(2);

    journalLine2.parmLineNum(2.00);

    journalLine2.parmCompany(company);

    journalLine2.parmTransDate(transactionDate);

    journalLine2.parmAccountType(LedgerJournalACType::Ledger);

    journalLine2.parmTxt('AX Wonders Journal Import test');

    journalLine2.parmAmountCurCredit(500.00);

    journalLine2LedgerDimension = journalLine2.createLedgerDimension();

    journalLine2DimCollection= journalLine2LedgerDimension.createValues();

    journalLine2Dim= new AifDimensionAttributeValue();

    journalLine2Dim.parmName(line2Dimension1Name);

    journalLine2Dim.parmValue(line2Dimension1Value);

    journalLine2DimCollection.add(journalLine2Dim);

      // Define Ledger Dimensions

    journalLine2LedgerDimension.parmAccount(line2MainAccount);

    journalLine2LedgerDimension.parmDisplayValue(line2FullAcct);

    journalLine2LedgerDimension.parmValues(journalLine2DimCollection);

    journalLine2.parmLedgerDimension(journalLine2LedgerDimension);

    // Insert records.

    journalHeader.parmLedgerJournalTrans(journalLineCollection);

    ledgerGeneralJournal.parmLedgerJournalTable(journalHeaderCollection);

    journalHeaderCollectionKeyList =

        LedgerGeneralJournalService.create(ledgerGeneralJournal);

    journalHeaderRecId =

        journalHeaderCollectionKeyList.getEntityKey(1).parmRecId();

    info(strFmt("LedgerJournalTable.Recid = %1", int642str(journalHeaderRecId)));

}

That's all for now folks!