Showing posts with label Accounting Period status. Show all posts
Showing posts with label Accounting Period status. Show all posts

Friday, 11 January 2019

Oracle Accounts Payables Period Close Activity

  To complete the close process in Payables:
    1. Approve all invoices and confirm all payment batches.
    2. Review and amounts you will transfer to the general ledger.
  • Submit the Expense Distribution Detail Report for unposted invoices.
    3. Transfer invoices and payments to the General Ledger and resolve any problems you see on the following reports:
    4. Move any unresolved posting exceptions to the next period(optional).
    5. Close the period in Payables.
    6. Reconcile Payables activity for the period. 
    You will need the following reports:
    7. If you use Oracle Purchasing, accrue uninvoiced receipts. 
    8. Post journal entries to the general ledger and reconcile the Trial balance to the General Ledger. 

Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...