Back

Receivables Transaction SmartView report does not show unposted cash receipts

Published: Jan 03, 2024
Post Author Written by Pat Roth

Issue

I’m using SmartView and running the Receivables Transaction SmartList. While the report does show the Cash Receipts that are both Posted & History, none of documents that are Unposted show on the report. Is this a bug?



Resolution

No, the Receivables Transaction SmartView should look exactly like the out of the box GP Receivables Transaction SmartList report shows. While the out of the box GP Receivables Transaction SmartList does have cash receipts – for whatever reason, it does NOT display the unposted cash receipts from the RM10201 table. The only cash receipts that appear on the GP SmartList are the Posted ones in the RM20101 table and the History ones from the RM30101 table. Since the SV version should display the same data as the GP SmartList version – it also does not include Unposted cash receipts on the report by design.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.