ReleaseUpdateTransformDB40_Ledger.ledgerBudgetPreProcessing Upgrade Script [AX 2012]

Updated: June 10, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateTransformDB40_Ledger

Method

ledgerBudgetPreProcessing

Description

Transforms data from the LedgerBudget table to the BudgetTransactionHeader and BudgetTransactionLine tables.

Script Type

Preprocessing 60: Live

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Affected Modules

General ledger

Affected Tables

LedgerBudget

Inserts records into the BudgetTransactionHeader and BudgetTransactionLine tables from the LedgerBudget table.

From Table: LedgerBudget

To Table: BudgetTransactionHeader

RecId

TransactionNumber

ModelNum

BudgetModelId

StartDate

Date

Active

TransactionStatus

From Table: LedgerBudget

To Table: BudgetTransactionLine

StartDate

Date

Currency

TransactionCurrency

Qty

Quantity

Price

Price

Amount

TransactionCurrencyAmount

Cov

IncludeInCashFlowForecast

TaxGroup

TaxGroup

Comment

Comment

ProjTransId

ProjTransBudgetTransId

Table

Field

Extended Data Type

-or- Base Enum

BudgetTransactionHeader

BudgetTransactionLine

Table

Field

LedgerBudget

*


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: