ReleaseUpdateTransformDB40_LedgerTrx.ledgerTransGeneralJournalEntryInsert Upgrade Script
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Class |
ReleaseUpdateTransformDB40_LedgerTrx |
Method |
ledgerTransGeneralJournalEntryInsert |
Description |
Performs the live pre-processing population of records in the GeneralJournalEntry table based upon existing records in the LedgerTrans table. |
Script Type |
Preprocessing 60: Live Preprocessing 60: Delta |
Microsoft Dynamics AX Source |
Microsoft Dynamics AX 4.0 |
Affected Modules and Tables
Affected Modules |
|---|
General ledger |
Affected Tables |
|---|
LedgerTrans |
GeneralJournalEntry |
SubledgerVoucherGeneralJournalEntry |
Ledger |
FiscalCalendarYear |
FiscalCalendarPeriod |
Remarks
This is an action method that is called by the helper method which handles the creation of the GeneralJournalEntry records.
Data Migration Section
From Table: LedgerTrans |
To Table: GeneralJournalEntry |
|---|---|
JournalNum |
DEL_JournalNumber |
TransDate |
AccountingDate |
LedgerPostingJournalId |
LedgerPostingJournal |
PeriodCode |
PeriodCode |
OperationsTax |
PostingLayer |
Voucher |
DEL_Voucher |
DataAreaId |
DEL_DataAreaId |
From Table: Ledger |
To Table: GeneralJournalEntry |
|---|---|
RecId |
Ledger |
From Table: FiscalCalendarYear |
To Table: GeneralJournalEntry |
|---|---|
RecId |
FiscalCalendarYear |
From Table: FiscalCalendarPeriod |
To Table: GeneralJournalEntry |
|---|---|
RecId |
FiscalCalendarPeriod |
From Table: LedgerTrans |
To Table: SubledgerVoucherGeneralJournalEntry |
|---|---|
TransDate |
AccountingDate |
Voucher |
Voucher |
DataAreaId |
VoucherDataAreaId |