ReleaseUpdateTransformDB50_Ledger.ledgerBudgetDeltaPreProcessing Upgrade Script [AX 2012]

Updated: June 13, 2011

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

Class

ReleaseUpdateTransformDB50_Ledger

Method

ledgerBudgetDeltaPreProcessing

Description

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

Script Type

Preprocessing 60: Delta

Preprocessing 60: Single user

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Microsoft Dynamics AX 2009

Affected Modules

General ledger

Affected Tables

LedgerBudget

This upgrade inserts records into the BudgetTransactionHeader and BudgetTransactionLine tables from the LedgerBudget table, updates existing records in the BudgetTransactionHeader and BudgetTransactionLine tables, and deletes records from the BudgetTransactionHeader and BudgetTransactionLine tables that no longer have an associated record 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

AmountMST

AccountingCurrencyAmount

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: