Results 1 to 3 of 3

Thread: Fixed Assets - Uploaded with Wrong Date Acquired

  1. #1
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    675

    Fixed Assets - Uploaded with Wrong Date Acquired

    While using the Fixed Asset interop inbound process to upload assets, the date acquired field was blank and the system took transaction date ( current system date) and uploaded. And I used JE to update the asset balance table without knowing the date issue.

    Now, the depreciation is not working properly ( sure it will not).

    I have tried updating the date using the same interop application and it successfully changed the Date Acquired field but still "Date - Beginning Effective " is the old date, so still the depreciation is not working.

    How should I manage this case. Can I use SQL to update the date and it will give anything meaningful to my issue ?
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

  2. #2
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    675
    Or...
    Can I remove all the fixed assets uploaded and upload again ?
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

  3. #3
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    675
    I have found the solution.

    1. Update the SP flag to blank, and Transaction code to 03 ( Delete)
    2. Run the interop report. It will remove all assets uploaded. It will also remove the balances.
    3. Uploaded again the assets and balances.

    Now, working fine.
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

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.