Skip to main content

AP: Accounts Payable Data Migration

 

Accounts Payable Data Migration                 
Transactional Data     Tools Used to Upload    Master Data   Tools Used to Upload   
Open Invoices         Suppliers       
Standard Invoices         Supplier Profile       
Credit Memos    FBDI & ADFDI    Supplier Address    FBDI  
Prepayment Invoices         Supplier Site       
          Supplier Site Assignments       
Pay Prepayment Invoice Payments     Manual   Supplier Contacts       
          Supplier Bank Accounts       
                  
                  
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