E9.0 Assets and invoices

[Knamburi]

Hello All,

I am looking for help on finding Assets information along with invoices or costs.

Our company decommissioned JDE long back, we had a backup of all data and now company want historical data.

None of the current team know JDE and exploring before going for external help

Thank you

 

[Mike Mackinnon]

Look in General Ledger by asset number:

Example: select GLASID as 'Asset Number',* from crpdta.F0911 where GLDGJ > 123001 and GLASID <> ''
Then look in FA table F1201 for asset information.