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