Journal entry batch review and approval
by Kashif Rasheed
Oracle JD Edwards EnterpriseOne 9.0: Supply Chain Management Cookbook
- Oracle JD Edwards EnterpriseOne 9.0: Supply Chain Management Cookbook
- Oracle JD Edwards EnterpriseOne 9.0: Supply Chain Management Cookbook
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Inventory Management
- 2. Inventory Transactions, Item Quantity, and Physical Inventories
- Introduction
- Issuing inventory
- Adjusting inventory
- Transferring inventory
- Item and quantity information
- Locating item and quantity information
- Defining search criteria
- Item Ledger Inquiry (CARDEX)
- Reviewing supply-and-demand information
- Physical inventory processing with cycle counts
- Processing tag counts
- 3. Updating Costs, Using Kits, and Lot Processing
- Introduction
- Updating item costs
- Updating average costs for items
- Updating detail costing
- Processing kit components
- Entering bills of material for kit items
- Creating lot processing
- Viewing lot availability
- Reviewing lot quantities
- Revising lot activity dates
- Viewing a lot transaction
- Reclassifying a lot
- 4. Understanding and Setting up Procurement
- Introduction
- Setting up Automatic Accounting Instructions
- Setting up the document type
- Setting up order activity rules
- Setting up a requisition
- Setting up Request For Quotes (RFQs)
- Setting up contract/blanket orders
- Setting up purchase orders
- Setting up Order Approval
- Setting up a receipt route
- Setting up standard receipts
- 5. Understanding Pricing in Procurement and Purchase Orders
- Introduction
- Setting up pricing in procurement
- Creating stock/non stock-based purchase orders
- Creating discount terms
- Creating tax information
- Creating substitute or replacement items
- Creating kits orders
- Change orders
- Printing orders
- Creating orders for multiple suppliers
- Creating supplier catalogs
- Entering order using order templates
- Creating order from quote order
- Setting an order on hold
- Entering and releasing order holds
- 6. Receipt Processing
- Introduction
- Setting up purchase receivers
- Printing purchase receivers
- Processing receipt information
- Entering/reversing receipts
- Review journal entry for receipt transaction
- Journal entry creation for items in receipt routes
- Defining payment eligibility for item removal
- Creating and assigning receipt routes
- Working with items in receipt routes
- Transferring items to operations
- Removing items from a receipt route
- Reviewing item history
- Purchase order template
- 7. Creating Vouchers and Landed Costs
- 8. Processing Special Orders and Approvals
- Introduction
- Creating a purchase requisition
- Generating a quote from a requisition
- Creating an RFQ from a requisition
- Creating a supplier price quote
- Generating a purchase order from an RFQ
- Reviewing order revisions
- Entering order revisions
- Stocked item reorder point
- Creating an approval route
- Approval delegation
- Setting up the Order Awaiting for Approvals application
- Working with Orders Awaiting for Approval
- 9. Sales Order Management and Additional Orders
- Introduction
- Setting up Order Activity Rules
- Setting up AAI
- Setting up a Credit Sales Order
- Setting up a Return Order
- Creating a Sales Order
- Updating and copying Sales Order Information
- Creating a Sales Order with Templates
- Reviewing an Order Revision History
- Ordering for Kits and Configured items
- Processing Recurring Sales Orders
- Sales Order for Matrix Items
- Reviewing Sales Ledger Inquiry
- Processing a Sales Transfer
- Creating Direct Ship Sales Orders
- Creating a Blanket Order
- Creating Quote Order
- 10. Holding, Releasing, and Reviewing
- 11. Order Processing, Prepayments, and Invoicing
- Introduction
- Printing pick slips
- Setting up serial number processing
- Running shipment confirmations
- Setting up bills of lading
- Printing delivery notes
- Setting up prepayment processing
- Setting up authorized credit card transactions
- Updating the transaction status
- Creating an invoice cycle
- Printing standard invoices
- 12. Updating Prices, End of Day Processes, and Sales Returns
- Introduction
- Updating the base prices
- Updating prices for a customer
- Setting the end of day processing
- Running the end of day processing
- Journal entry batch review and approval
- Reviewing electronic mail for messages
- Returned material authorization
- Interbranch and intercompany orders
- Reposting orders
- Setting up sales journal
- 13. SCM Customizations
- A. The Supply Chain Business Process
The accuracy of the sales transaction records should be verified, by reviewing the General Ledger entries that the Update Customer Sales program creates, before you post them into the General Ledger.
You should run the End of Day processing (R42800) batch application in order to review the Journal Entry created by the sales order application.
- Access the Work with Batches (P0011) application from Fast Path.
- Enter the Batch Number/Batch Type, and then click on Find.
- Select the appropriate batch type from among: Unposted Batches, Posted Batches, All Batches or Pending:
- Select the batch that you want to review, and then click on Select on the menu bar.
- Click on Select again, and review the RI sales invoices.
When the Update Customer Sales program runs in the Final mode, it creates transactions in several batches, for posting into journals such as customer sales (batch type IB). The system creates batch type IB and summarized and detailed journal entries based on the processing option set up in the Sales Update program. The system creates batch type G for inventory and COGS entries. These transactions can be reviewed from General batch review, Display batches by User ID, Batch Status, Batch Number, and Entry date range. The batch detail can display journal entry header information, such as invoice number, document type, and gross amount for a single batch. These transactions will be posted to the F0902 and F0911 tables, reviewed in th e General Ledger Post report R09801. The batch report can contain errors; the report also includes a text box, which will alert you if the program has found errors.
When you review electronic mail messages, this will provide further information that will be useful in resolving errors.
-
No Comment