Results 1 to 3 of 3

Thread: Loading Equipment Repair Costs into E1 without affecting G/L

  1. #1

    Question Loading Equipment Repair Costs into E1 without affecting G/L

    We implemented E1 for our financials on 01/01/16 and are running 9.1 on servers, plus we have a homegrown application on our iSeries that outputs costs which we would like to load into E1 to update the repair costs on specific Equipment.
    These costs been processed through the A/P application in E1, but are not assigned to Equipment because it is not known which piece of equipment the 'purchased product' will be used on and charged to.
    The costs are also tracked in our iSeries application and when the 'purchased product' is used on a piece of Equipment in this application a detail record is written to a flat file charging the cost of the product to the piece of equipment it was put on.
    Since the cost has already been processed through A/P and updated the proper 'Equipment Repair' G/L account in E1, we do not want to have the costs from the iSeries to update the G/L account again.

    Is it possible to add Costs in E1 from a third party system, assigning it as Repair Cost to a piece of equipment, but not affecting G/L?
    Or am I looking at this wrong and there is a proven solution?

  2. #2
    The easiest and cleanest method would be to effectively put the 'purchased product' expense to an unallocated repair costs account on PO receipt in JDE. Then, when the costs are determined in your custom solution you can journal the costs into an allocated repair costs account in JDE with the equipment identifier information completed using the Z table interface.

    The only issue you need to deal with is timing in terms of which financial period the journals occur in but basically you're just doing a cost reallocation.
    Russell Codlin
    Capital Asset Management & Manufacturing Specialists
    REST Integration, IoT, Mobile Applications and Job Scheduling for all E1 releases from 9.2 back to 8.11SP1

  3. #3
    Thank you Russell, I will review your suggestion with our financial people to see if it is workable and acceptable to them

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.