ReleaseUpdateTransformDB50_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	ReleaseUpdateTransformDB50_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 Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules
General ledger

Affected Tables
LedgerTrans
GeneralJournalEntry
SubledgerVoucherGeneralJournalEntry
Ledger
FiscalCalendarYear
FiscalCalendarPeriod

This is an action method that is called by the helper method which handles the creation of the GeneralJournalEntry records.

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