How to Stop Duplication of Billed Amount in Analysis

Ashley Dore

I am attempting to build a report which will combine corporate card data and expenses data. The goal is to track corporate card transactions to the expense report level. In the example below, the transaction was coded to two different cost centers, so there are two separate lines for the transaction on my report. However, the billed amount is reporting twice. I set the billed amount to "suppressed" rather than "repeat" and that did not correct this issue. Is there a way to only report the billed amount once per transaction?

John Hung-Oracle

Hi Ashley, To better serve you, please post this question in the Reporting and Analytics for ERP forum since its specific to financial subject areas/use cases. Thank you.