Projects:APR Migration Tool/Technical Documentation/Order

Contents 1 Order Migration 1.1 Scenario 1 1.1.1 Affected Orders 1.1.2 Migration process 1.2 Scenario 2 1.2.1 Affected Payments 1.2.2 Migration Process 1.3 Scenario 3 1.3.1 Affected Payments 1.3.2 Migration Process 1.4 Scenario 4 1.4.1 Affected Payments 1.4.2 Migration Process 1.5 How to identify a migrated Order

Order Migration

Scenario 1

Affected Orders

The Orders (C_Order) that satisfy ALL the following conditions:

• Not invoiced.
• No payments (C_Debt_Payment)

Migration process

For each payment of the Order the process will create a new Payment Plan:

FIN_Payment_Schedule
Column	Value
ad_client_id	Client of the Payment.
ad_org_id	Organization of the Payment.
c_order_id	Affected Order.
c_invoice_id	null
c_order_id	null
duedate	Due date of the Payment. Duedate column of C_Debt_Payment table.
fin_paymentmethod_id	The payment method that matches with the form of payment defined in the order. It has been created in the Payment Method migration process.
c_currency_id	Currency of the Payment. C_Currency_Id column of C_Debt_Payment table.
amount	Amount of the Payment. Amount column of C_Debt_Payment table.
paidamt	0.0 Nothing has been paid.
outstandingamt	Amount of the Payment. Amount column of C_Debt_Payment table.

FIN_Payment_ScheduleDetail
Column	Value
ad_client_id	Client of the Payment.
ad_org_id	Organization of the Payment.
fin_payment_detail_id	null
fin_payment_schedule_order	The reference to the Fin_Payment_Schedule
fin_payment_schedule_invoice	null
amount	The amount of the Payment. Amount column of C_Debt_Payment table.
writeoffamt	Writeoff amount of the Payment. Writeoffamt column of C_Debt_Payment table.

The recently created records will be shown in Payment Plan tab of the Orders window.

• Sales Management || Transactions || Sales Order || Header >> Payment Plan
• Procurement Management || Transactions || Purchase Order || Header >> Payment Plan

Scenario 2

Affected Payments

All the Orders (C_Order) that satisfy ALL the following conditions:

• Invoiced.
• No payments (C_Debt_Payment)

Migration Process

They are not migrated.

Scenario 3

Affected Payments

All the Orders (C_Order) that satisfy ALL the following conditions:

• Invoiced.
• With payments (C_Debt_Payment)

Migration Process

They are not migrated.

Scenario 4

Affected Payments

All the Orders (C_Order) that satisfy ALL the following conditions:

• Not Invoiced.
• With payments (C_Debt_Payment)

Migration Process

They are not migrated.

How to identify a migrated Order

All the migrated Invoices will be flagged to easily identify then. In C_Order table the Em_Aprmt_IsMigrated column set to true. This value is only visible from the database.