Modifying a report
Hi,
I found this report on the Enginatics website.
Blitz Report™ – GME Material Usage and Substitution Variance (enginatics.com)
It has a lot of valuable information, but I was hoping to tweak it some so that it gives me more data points to analyze. I believe this was a default Oracle EBS report, so if you have something better that works with OPM I would love to try other options out as well.
Can the following parameters be created
- Org
- Batch Close Date (will need this added to the report. Currently only batch completion date is a field)
Can the report layout be adjusted as followed
- Add a column that shows Batch Close date/time
- Create a column that lists the row type by product, ingredient, byproduct (see example below)
- Have a transacted quantity column for product/ingredient/byproduct
- Have a transacted UOM column for bullet point B
- Have a primary UOM quantity column for product/ingredient/byproduct
- Have a primary UOM column
Remove all the variance & cost columns except for the following
- Keep – Row accounting cost (standard cost) @ Primary UOM
- Add – Row transaction value (primary UOM amount * standard cost) example report column Z
- Add – Row planned value (Planned Primary Quantity * standard cost) example report column Y
- Add – Calculated column for above bullet points C minus B

- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.