Compartilhar via


ReleaseUpdateDB60_Proj.updateProjInvoiceOnAcc 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

ReleaseUpdateDB60_Proj

Method

updateProjInvoiceOnAcc

Description

Populates the new transaction invoice detail table.

Affected Modules and Tables

Affected Modules

Project

Affected Tables

ProjInvoiceOnAcc

ProjInvoiceOnAccDetail

Remarks

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.

Data Migration Section

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

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

ProjInvoiceOnAccDetail

Deleted Tables or Fields

Table

Field

ProjInvoiceOnAcc

DEL_WIPPeriod