E1: 41: Request to Charge Inventory Issue (P4112) Costs to the Asset Responsible Business Unit

(Doc ID 2314684.1)

Last updated on OCTOBER 06, 2017

Applies to:

JD Edwards EnterpriseOne Inventory Foundation - Version 9.0 and later
Information in this document applies to any platform.

Goal

When performing an Inventory Issue (P4112) transaction, is there a way to select the cost center for the G/L Account from the Asset ID that is entered in the issue transaction?

Below is an explanation of the Business Requirement:

  1. The client is a water company and has field personnel in Trucks/Vehicles that consume fuel while they make their rounds and perform their maintenance work
  2. They stop at company owned fuel stations and fill up their vehicles
  3. The Branch Plant is the Fuel Pump that stores the fuel
    1. For Example: Branch Plant 30 = Fuel Pump 30
  4. The Truck/Vehicle (Asset ID) is associated with a Department that is a different Cost Center than the Branch Plant (Fuel Pump)
    1. WATER is the cost center that owns the asset TRUCK 10
    2. SEWER is the cost center that own the asset TRUCK 20
  5. When the driver fills up they send their truck number (asset id) and how much fuel they consumed to the inventory people in the office
  6. The fuel gets reduced in the branch plant they enter in the header of the Inventory Issues Program (P4112)
    1. TRUCK 10 receives 100 Gallons at $300.00
  7. The client wants the cost center in the G/L account number to come from the Department that owns the truck and not the Business Unit of the Branch Plant (Fuel Pump)
    1. The AAI 4122 Inventory G/L Entry should be 30.1411 to reduce the inventory for Fuel Pump 30   (-$300 Credit)
    2. The AAI 4124 Fuel Expense G/L Entry should be WATER.6310 to charge the costs to the WATER department (+$300 Debit)
  8. They would like the issues program to look at the Asset ID and look up the Department that owns the Asset and use that Cost Center in the G/L Account that is charged for the fuel
  9. Currently they are using a work order to manage the issues and they are able to charge the account they want, but it is too much work to setup workorders and manage issues in that fashion

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms