ax2012 x ledgerdimension add custaccount

Up your game with a learning path tailored to todays Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.

In technical language this is called default dimension as we can also see by parameter name.

Remember there is difference between ledger and default dimensions.

AxLedgerJournalTrans class supports both kind of dimensions.

Actually the actual LedgerDimension field(s) handling happens during deserialization in AxdLedgerGeneralJournal class, here in getDimensionId method the values get stored for future processing.

Challenge: Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made some imports more complex.

In fact the data model forming General Journal was not dramatically changed and import principle remains the same populate the journal and then post the journal.

Numerous fields are available on General Journal line level in Rich client to achieve required level of detail during import.

In order to import customer transactions with required level of detail using Excel Add-in some additional work may be required.

Solution: Microsoft Dynamics AX 2012 ships with General Journal AIF Web Service (LedgerGeneralJournalService) which can be used in integration scenarios.

However General Journal AIF Web Service may not expose all fields which may be required for import such as Invoice, etc.

In this walkthrough in order to import customer transactions using Excel the appropriate tables will be used instead.

Some additional work will be done after initial import to align customer account.

Assumption: The assumption is that appropriate reference data such as customers, etc.

Data Model: Table Name Table Description LedgerJournalTable The LedgerJournalTable table contains all the defaulting and state information pertaining to a single journal.

The transaction details of a journal are managed in the LedgerJournalTrans table.

LedgerJournalTrans The LedgerJournalTrans table contains the transaction detail information that pertains to a single journal.

The individual transaction lines are also referred to as voucher lines.

Data Model Diagram: Walkthrough: AxdLedgerGeneralJournal Query General Journal AIF Web Service doesnt expose all fields which may be required for import such as Invoice, etc.

In order to bring Customer account information over to AX I introduced CustAccount field into LedgerJournalTrans table as shown below CustAccount field is based on CustAccount EDT which in its turn has relation to CustTable table After mentioned customizations will be introduced you will have to regenerate AIF Proxy classes in order to reflect changes in the data model.

I used LedgerGeneralJournalService AIF Web Service because it has LedgerJournalTable and LedgerJournalTrans tables as data sources, this is exactly the tables I need AIF Proxy classes to be regenerated for.

Update document service After you complete steps required to Update document service as its described in Import Data walkthrough you will need to generate incremental CIL.

Generate Incremental CIL Connection Add Tables Dynamics AX Error Solution: - Add replacement key to VendTrans table Field, RecId - Add replacement key to CustTrans table Field, RecId - Add replacement key to LedgerJournalTrans table Field, RecId - Add replacement key to ReasonTableRef table Field, RecId - Add replacement key to VendBankAccount table Field, RecId - Add replacement key to CustBankAccount table Field, RecId - Add replacement key to BudgetSource table Field, RecId - Add replacement key to BudgetTransactionLine table Field, RecId Field Chooser Accounting structure Dynamics AX Error When you unpress Field Chooser button you may see The number of joins in the statement is X.

As opposite to AIF Web Service where the data set is strictly defined by the Query, in the case when raw tables are being used the system is building composite data set based on relations specified on tablesEDT level In order to bypass this error you will have to change Maximum buffer size (KB) setting in Dynamics AX Server Configuration Utility and restart AX AOS Dynamics AX Server Configuration Utility LedgerJournalTable Field Name Field Description Journal batch number Name Description LedgerJournalTrans Field Name Field Description Journal batch number Voucher Date Company accounts Account type LedgerJournalTrans.CustAccount Customer account DefaultDimension.Department Description Debit Credit Currency LedgerJournalTrans.Invoice Invoice Offset company accounts Offset account type OffsetLedgerDimension OffsetLedgerDimension.Main Account OffsetLedgerDimension.Department Offset-transaction text 1) 2) 3) Please note that I added Invoice field which is not included in General Journal AIF Web Service data set by default.

Also to manipulate with Customer account I added custom CustAccount field, after initial import this field will be used in X Job to populate LedgerDimension field in LedgerJournalTrans table based on Customer account specified.

In my previous walkthroughs I used different approach which doesnt require the customization of AX data model (the structure of LedgerJournalTrans table) when I used Description field to bring Customer account info over to AX.

When you will try to publish LedgerJournalTrans table data you will see Method AxdBase.getDimensionId must be overridden error Dynamics AX Error This error occurs because theres no behavior defined in Generic document AIF document class (AxdGenericDocument) which is used when you work with raw tables as it relates to LedgerDimension field(s) processing.

Please note that General Journal AIF document class does have this behavior defined, thats why it can handle LedgerDimension field(s) fine.

Ax2012 X Ledgerdimension Add Custaccount