You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Duplicate records in OTBI while using Payables Transaction and Payables Payments subject area

edited Jan 30, 2019 4:30PM in Payables, Payments & Cash Management 2 comments

Summary

We are on R13 and when we try to create a simple Invoice information along with Payments details using Payables Transaction and Payables Payments subject area, the records are duplicated

Content

I have created a report in OTBI with Payables Transaction and Payables Payments subject area with Invoice Number, Business Unit, Supplier Name, Site, Payment Status, Payment type, Invoice Amount, Paid Amount, Check Number and Gross Amount.  The common dimensions are Business Unit, Supplier Name and Site.  Facts chosen are Invoice Amount and Gross amount from the respective subject area.  As soon as I select the Check Number from the Payables payments subject area, I am getting duplicate records where in it tries to fetch all the invoices for the vendor in the system and stamp the respective payment date.  For

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!