Hi, I am looking for suggestions to better track expenses in Oracle cloud. My company switched to Oracle cloud from JD Edwards about two years ago and since then I have been trying to figure out a way to better track department expenses.
In JDE I was able to do an account balance inquiry and it would list each item, the date posted, the cost and quantity of the item. I could easily export the details to Excel for review and distribution. In Oracle I run an Inquire on detail balance, then I have to select the journal entry, then select each individual line in the journal entry and click view transaction before I finally get to the description of the item. A simple $400 entry takes me ten minutes to get the details and my food cost in one department is $85,000 for a month.
Is there a simple way to show the food cost, beverage cost, supply cost, etc for each department? Something that ties the GL module to the procurement and A/P modules to understand what costs are hitting the GL?
I have been trying for two years to figure out an easier way to do this with no success. Any help would be greatly appreciated