Archive for the ‘ERP’ Category

Payables: Payments by Method by Supplier (& Site)

Tuesday, April 4th, 2017

You can use this SQL statement to review the setup of the supplier payment options by site, and the remittance preference and if specified email address.

This SQL statement could be useful if you ware looking to validate or extract lists of contacts and look for opportunities to streamline processes.

  SELECT COUNT(aca.check_number)            “Number of Payments”,
asa.segment1                       “Supplier Number”,
asa.vendor_name                    “Supplier Name”,
st.vendor_site_code                “Supplier Site Name”,
aca.PAYMENT_METHOD_CODE            “Payment Method (At Payment)”,
ieppm.payment_method_code          “Site Payment Method (Current)”,
iepa.remit_advice_delivery_method  “Site Remit Delivery Method”,
iepa.remit_advice_email            “Site Remit Advice Email”
FROM ap_checks_all aca,
ap_suppliers asa,
iby_external_payees_all iepa,
iby_ext_party_pmt_mthds      ieppm,
ap.ap_supplier_sites_all     st
WHERE     1=1
AND aca.vendor_id = asa.vendor_id
and iepa.payee_party_id = asa.party_id
and iepa.supplier_site_id = aca.vendor_site_id
and iepa.ext_payee_id = ieppm.ext_pmt_party_id
AND iepa.supplier_site_id = st.vendor_site_id
–and iepa.supplier_site_id = aca.vendor_site_id
group by asa.segment1, asa.vendor_name, aca.PAYMENT_METHOD_CODE, remit_advice_delivery_method, remit_advice_email, ieppm.payment_method_code, st.vendor_site_code
ORDER BY COUNT(aca.check_number) desc;

AIM to OUM Mapping

Monday, June 6th, 2016

AIM to OUM

Implementation Question: Should I turn on Dynamic combination creation?

Wednesday, June 1st, 2016

Oracle recommend turning on the setting for dynamic combinations creation (cloud) or dynamic inserts (11i/R12) at least until all setup related activities are finalised. Turning off dynamic creation / inserts limits the code combinations allows and can hinder implementations.

Many UK businesses unhappy with their ERP… Really, WHY?

Wednesday, September 17th, 2014

A recent ERPNews article really made my blood boil. LINK: http://www.erpnews.net/622/uk-businesses-unhappy-erp/

Taking the systems implementer approach to this issue, regardless of your chosen flavor (you did pick Oracle eBusiness Suite didn’t you?), you generally find many of the whizzy, snazzy or down right useful features are delayed until later releases. Generally it I’ve found that they’re scoped planned and then shelved as excellent ideas that just haven’t got off the ground because;

  1. They cost to much in this years budget
  2. They don’t deliver returns quickly enough
  3. Leaders don’t have or haven’t had the vision communicated well enough to them to see the benefits
  4. Quite simply… I didn’t know it did that?

Most of the time, your ERP was chosen for all the right reasons, you may have changed, adapted or grown. This doesn’t mean the your application isn’t suitable, it just means that you may need to explore different ways to exploit it. Unless your using a ERP platform from the ark, most new functionality could easily be within your reach. If its not, have you looked at using Oracle eBusiness suite, I understand its really good.

If you are using technology from the ark, then your justified in your unhappiness, you may want to talk to these people? LINK  (Remember other vendors are available).

How to get to those benefits

  1. Undertaking a review of your current processes is a excellent start to understanding how you operate, what you actually “do”, and how you go about it.
  2. Measure it… how can you justify something has worked unless you can measure it. Sometimes the measurement may be in resource harmony, most of the time you expect a performance or process improvement, but make sure you have some kind of metric to understand what success looks like.
  3. Talk to your vendor, read up on new releases since you’ve implemented the solution, visit user groups. Yes this may require effort, it may be that you’ve had someone in support interested for years in resolving the issues, they’ve just not been aware you wanted to do something about it.
  4. Too big, or too much to do yourself? Don’t be afraid to ask others for information and experience, you may have to invest in some consulting time, but if the goals worth and you’ve measured it, the justification might just pay for its self.
  5. Don’t forget your ERP. Stick with the times, you’ve invested significantly in the application, you should ensure you’ve got the right level of support and improvement projects on going – staying up to date helps, enables you to more easily exploit new functionality.