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