ReleaseUpdateDB60_Vend.updateVendPurchOrderJour 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_Vend
Method	updateVendPurchOrderJour
Description	Finishes the processing of the staging tables that were populated in the pre-processing process. Re-creates the deleted purchase orders, including lines and miscellaneous charges. Splits the purchase order journal if the summery was updated in the previous version.

Affected Modules and Tables

Affected Modules
Accounts payable

Affected Tables
VendPurchOrderJour
PurchTable
PurchLine
MarkupTrans
PurchTableDelete
PurchLineDelete
PurchTableHistory
PurchLineHistory
MarkupTransHistory
DEL_VendPurchOrderJourSplit
DEL_VendPurchOrderDelete

Remarks

In the pre-processing process, the new history tables were populated. However, any change to the original tables is postponed until the post-processing process. Summery updates of purchase order posting, that is the confirmation, is no longer allowed, and summery updates that were processed in the previous version are split into individual journals for each purchase order. The new pattern does not allow physical deletion of purchase orders, lines, and markup after it has been confirmed. If this has been done in the previous version, the records will be recreated.

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
PurchTableVersion
PurchTableHistory
PurchLineHistory
MarkupTransHistory

Deleted Tables or Fields

Table	Field
VendPurchOrderTrans
VendPurchOrderPurchLink