Skip to main content

AP: Invoice Creation via SpreadSheet (ADFDI)

 

Invoice Creation Via Spreadsheet (ADFDI)             
Creation of Invoice Via Spread Sheet PathPayables >> Invoices >> Taskpane >> Create Invoice From Spread Sheet          
To create Invoices Via Spread Sheet you have to install one file             
The spread sheet will directly Connect to the instance              
The Invoice will be created when you check the source of the invoice we can see that it was created by spread sheet             
Invoice will be created with unvalidated status and we have to validate the invoice manually             
To create Accounting Entries for payment you have to create Accounting Entries For Invoice First             
If you want to make a payment to any invoice Accounting Entry is not mandatory             
In payments there is a field called Quick whenever you make the payment and you want a print of the check you can select as Quick             
In payments there is a field called Manual whenever you returned the check and you want to process the payment outside of the system and you want to record in the system             
Whenever you make the payment to invoice. System will run a job in Background    JobFormat Payment Files       
Process in Excel after installing ADFDI Application             
1.After installing the ADFDI Application we have to do some excel options >> Goto Files >> More >> Options >> Add-ins >> In Manage, Select COM Add-ins              
here verify whether we can see Oracle ADF Desktop Integration Add-ins for excel.             
2. After checking that goto trust center >> Trust Center Settings >> Macro Settings >> Enable the radio button Enable all macros             
Mandatory Columns to fill in spreadsheet when we are creating an invoice through spreadsheet             
Invoice Header Identifier             
Business Unit             
Invoice Number  * When you create Invoice through spreadsheet system will run job           
Invoice Currency 1. Import Payables Invoices           
Invoice Amount * After successful completion system will run Import Payables Invoices Report.           
Invoice Date             
Supplier              
Supplier Number             
Supplier Site             
Invoice Type             
In Line level we have to provide              
Type             
Amount             
Distribution Combination             
When you create a Standard Invoice              
Item ExpenseDebit            
LiabilityCredit            
              
When you make the payment of Standard Invoice and Accounted             
Liability Debit            
Cash ClearingCredit           

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