Hello, I am new to both this forum and relatively new to CMOD.
We are converting a COLD document from Oracle IPM to CMOD and I'm not sure how to resolve this issue.
In a remittance report, it is broken down by vendor number, but within a remittance document you can have more than one invoice number on a single page. The business users only have the invoice number to search on. In Oracle it publishes a new document for each new invoice within the report, even if it is the same page. Does anyone have any ideas how this may be solved in CMOD without rewriting the source COLD report?
Thanks
You might want to look up "transaction reports".
If the vendor numbers are sorted numerically, you can search inside a group of ranges per report. This means that you may get some false positives on searches.
Alternately, you can allow full text searches of individual reports, but you should know that this can cause a LOT of overhead on the server.
-JD.