Skip to main content

Oralce Accounts Payables Data Migration


Mandatroy Fileds to be populated in FBDI Sheet

1. Invoice ID

2. Business Unit

3. Invoice Number

4. Invoice Amount

5. Invoice Date

6. Supplier Name

7. Supplier Site

8. Invoice Currency

9. Payment Terms

10. Accounting Date

11. Payment Method

12. Liability Combination

Loading Process

1. Prepare Data File

2. Validate Data File

3. Generate CSV ZIP File

4. Review the Generated CSV File Count (Optional)

5. Upload CSV Files

6. Run ESS Job -Import Payables Invoices

7. Validated Imported Invoices

8. Run "Create Accounting" for Imported Invoices

9. Reverse and Post the Imported Journals in General Ledger

Pre-CheckList

1. Data Migration Source

2. Supplier Data

3. Period Open Status for AP & GL

4. Payment Method

5. Pay Group

6. Dummy Bank Account for Data Migration

7. Unfreeze Journal Source (To Reverse Sub Ledger Journals in GL)

8. Disable Tax Checkbox

9. Disable Invoice Approvals to Complete Data Migration

Data Migration-Reconciliation

1. Run ESS Job "Payables Trial Balance Report"

Supplier Data Migration

Loading Process

1. Prepare Data File

2. Validate Data File

3. Generate CSV ZIP File

4. Review the Generated CSV File Count

5. Upload CSV File

6. Run "Import Suppliers"

7. Run "Import Supplier Address"

8. Run "Import Supplier Sites"

9. Run "Import Supplier Site Assignments"

10. Run "Import Supplier Contacts"

11. Run "Import Supplier Bank Accounts"

 


Comments

Post a Comment

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more