OTBi for subject Payables Invoices>Transactions Real time>Distribution not showing correct Amount
Summary:
We are building OTBi report for Payables Invoices - Transactions Real time->Distributions->Invoice Distributions->Invoice Distribution Amount. In this when we are adding Purchase Order Created By column from Invoice Distribution Details-Purchase Order Information, in Invoice Distribution Amount column the Oracle doubles the amount and which is wrong. How to correct the same?
For another PO when we add column named Purchase Order Deliver to Person is causing double amount.
If anyone has come across such scenario please help us on the same.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Tagged:
0