If you are, like the company I work at, a user of both Oracle Payables and Oracle Internet Expenses you'll realise that the line between then is incredibly blurred. Especially if you have the situation where some departments/ areas use i-Expenses but other areas have an Excel-based expenses system (that is then sent to Finance who enter the data directly into Payables).
Oracle have made the situation a little worse by licensing Internet Expenses separately to Payables and it looks very much like Noetix have continued the trend.
What makes the Noetix decision even stranger is that the majority of the data for Internet Expenses is stored in the same tables as Payables in Oracle.
After looking at what was offered by the Noetix "Internet Expenses" module and our own reporting requirements the only "gap" that could be identified was for reporting on Credit Card Transactions (primarily around AP.AP_CREDIT_CARD_TRXNS_ALL).
Our reporting requirements are pretty simple, here is a simple list (with properties) of the columns we'd like to report on related to Credit Card Transactions;
CARD_NUMBER VARCHAR2(30)
DISPUTE_DATE DATE
EMAIL_ADDRESS VARCHAR2(240)
EMPLOYEE_FULL_NAME VARCHAR2(240)
EXPENSED_AMOUNT NUMBER
LAST_UPDATE_DATE DATE
MERCHANT_NAME VARCHAR2(80)
REFERENCE_NUMBER VARCHAR2(240)
TRANSACTION_AMOUNT NUMBER
TRANSACTION_DATE DATE
TRANSACTION_ID NUMBER(15)
Converting these requirements into a Noetix View took a fair bit of trial and error but the script is available here. As it's quite a large one I won't be copy/pasting it below (as I normally would).
Any questions/ suggestions feel free to post a comment.
2 comments:
Hi
Thanks for your comment.
Noetix already has a View named 'AP_Credit_Card_Trans' which shows the credit card transactions. Please contact Noetix support to have the view for the organization you work for.
Thanks,
Jay Bhattacharyya
Noetix Corporation
Hi Jay,
Thanks for responding.
I do say in my post that there is a Noetix View for this but that it is licensed separately. Is that not correct? (i.e. can we just request it?)
At the time we were discussing putting Noetix in if we had known i-Expenses was separate then we would probably have just brought it - now we can see that the only feature gap we have is this one view it's a much harder sell to the business.
I'm sure there is other (useful) stuff in the iExpenses module for Noetix, but our feature gap is only this one view.
Andy Pellew
Post a Comment