ReleaseUpdateDB60_Proj.updateProjInvoiceOnAcc Upgrade Script [AX 2012]

Updated: July 23, 2010

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

Class

ReleaseUpdateDB60_Proj

Method

updateProjInvoiceOnAcc

Description

Populates the new transaction invoice detail table.

Affected Modules

Project

Affected Tables

ProjInvoiceOnAcc

ProjInvoiceOnAccDetail

A project transaction can now be billed to multiple customers. To support split billing, another level of tables was created. The sales amounts of billed on-account transactions will be stored in the new ProjInvoiceOnAccDetail table. This new table is related to the existing ProjInvoiceOnAcc table.

From Table: ProjInvoiceOnAcc

To Table: ProjInvoiceOnAccDetail

RecId

InvoiceRefRecId

Amount

Amount

AmountMST

AmountMST

DEL_WIPPeriod

WIPPeriod

From Table: ProjOnAccTransSale

To Table: ProjInvoiceOnAccDetail

RecId

SaleRefRecId

From Table: ProjInvoiceOnAccDetail

To Table: ProjInvoiceOnAccDetail

RecId

RefRecId

Table

Field

Extended Data Type

-or- Base Enum

ProjInvoiceOnAccDetail

Table

Field

ProjInvoiceOnAcc

DEL_WIPPeriod


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

Community Additions

ADD
Show: