Item Ledger Inquiry (CARDEX)
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 Item Ledger Inquiry (CARDEX) program contains transaction history such as sales, receipts, or transfers for each item in the inventory. Each entry represents a transaction that affects the on-hand quantity of an item. You can review a transaction to determine both the item quantities and the related costs in any branch, location, or lot as of a particular date. You can also see any transactions for that item that have taken place as of a specific date, and locate information about quantities that are deducted from the On-Hand quantity.
Before you complete the tasks in this section, you must:
- Set up the system to calculate availability for manufacturing processes if you are using the JD Edwards EnterpriseOne product data management system
- Set up location segments for information to be available
- Verify that the system is set up to calculate availability for inventory items
- Set up processing options for Item Ledger Inquiry (P4111)
- Enter a code from UDC 00/DT that specifies document type. If you leave this processing option blank, * is the default value and all document types appear.
- In the Load and Delivery Ledger Inquiry (FUTURE) , enter the application or batch version to be used for each program, or leave this processing option blank.
- Enter 1 on the Display tab to show the quantity in the primary units of measure.
The Item Ledger Inquiry (CARDEX) contains transaction history, such as sales, receipts, and transfers for each item in inventory. Each entry represents a transaction that affects the on-hand quantity of an item.
You can compare the inventory balances to the GL at the end of a period. Because inventory transactions continue after GL periods close, the system provides a method for you to reconcile the inventory balances to the GL for any fiscal period. The Item Ledger fetches the data from the F4111 table for the Item Ledger Inquiry program.
Now, let's talk about some other options, or possibly some pieces of general information that are relevant to this task.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.