Updating average costs for items
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
This recipe demonstrates how you can update the average cost by using an interactive application and batch application Average Cost Update (R41811).
Before you run the Average Cost Update program, you should be familiar with the cost level of the items that you want to update. You should consider that:
- For all items with a cost level of 1, it is required to specify the branch/plant and locations
- For all items with a cost level of 2, it is required to specify the locations only
- If you select to run the update for items from all three cost levels, you should select by item number only
- You need to set up UDC 40/AV to specify the programs that update the Average Cost Work File (F41051)
- Upload the item cost information into the F41051 table.
- Select Inventory Price & Cost Updates (G4123) | Update Average Cost batch application.
- Set the data selection, if you want to update the cost for a specific item, and then click Submit.
When you run the Average Cost Update program, the system accesses current cost information from the F41051 Average Cost Work file table. It then calculates the average cost for each item and updates the F4105 table. Each time a transaction affects the current cost of an item, the system updates the Average Cost Work File, and then deletes the transaction work file. To specify that the system updates Average Costs interactively, use the System Constants program. To update average costs in batch mode, use the Average Cost Update program. You specify the items, branches/plants, locations, and lots for which to update average costs.
You can update item costs through an interactive process. Set up the Update Average Cost Online option in the branch plant system constants. The system then calculates a new average cost for an item immediately after any transaction occurs that affects the average cost of the item.
- Setting up branch/plant constants in Chapter 1,Inventory Management
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.