Skip to main content

AR: Receivables Data Migration

 

Receivables Data Migration                   
Transactional Data    Tools Used to Upload Data     Master Data    Tools Used to upload Data    
Invoices    FBDI     Customers   4 Sheets FBDI Template    
Standard Invoices    ADFDI     Customer Party   19 Sheets FBDI Template    
Credit Memos          Customer Accounts        
Receipts (Unapplied and unidentified)          Customer Sites        
           Customer Bill-To and Ship-To Details        
           Customer Contacts        
                    
Cutoff Date: 31-Jan-2023                   
Go-Live Date: 07-Feb-2023                   
                    
                    
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. Validated Imported Invoices                   
7. Run ESS Job - Create Accounting for Imported Invoices                   
8. Reverse and Post the Imported Journals in General Ledger                   
9. Run GL Trial Balance to review the balances are zero                   
                    
Data Migration - Reconciliation                   
1. Run - Receivables Aging by General Ledger Account Report                    
2. Prepare Receivables to General Ledger Reconciliation                   
                    
Pre-Check List    Tasks              
1. Data Migration Source    1.Manage Transaction Sources              
2. Auto Invoice DFF    2. Manage Receivables Descriptive Flexfields              
3. Customer Data                   
4. Period Open Status for AR & GL                   
5. Receivables Payment Terms                   
6. Receipt Source                   
7. Receipt Class & Receipt Method                    
8. Unfreeze Journal Source (To Reverse Sub Ledger Journals in GL)                   
9. Disable Tax Check box                   

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