3,015
Hi, we've created an aging report from the ReceivablesTransactions view. The problem is that it is displaying information that has been posted and information that has not been posted.
We do not want it to show anything that has not yet been posted. It should be only showing posted transactions.
Any help is appreciated!
*This post is locked for comments
That SQL statement will tell you how many transactions you have for each status: history, posted and unposted/work. You said you are seeing that every invoice is "posted", so I wanted to confirm this.
We are using GP2010. That screenshot is from report builder. Do you know why it isn't showing? Is it just a problem with the wizard I'm using in report builder?
If I create a SQL statement using 10101,10201 or 10301 will it find those tables?
----
I don't think I have access to SQL server mgmt studio. Our admin is out of town. What will running that script do? What is the result going to tell me? Thanks!
Are you able to get to SQL Server Management Studio? If so, can you run the following script against your company database and let us know the results?
select [Document Status], count(*) [Number of Docs] from ReceivablesTransactions
group by [Document Status]
order by [Document Status]
What GP version are you on? Here's an excerpt from the table listing for GP2010:
RM Distribution Work File RM_Distribution_WORK RM10101
RM Cash Receipts Work File RM_Cash_WORK RM10201
RM Sales Work File RM_Sales_WORK RM10301
Frank, I am not seeing RM10101, RM10201, or RM10301.
Hmmm...I placed the document status in my report but for some reason it is showing every invoice as "posted" even though some are not posted.
Do you know why this might be the case?
Looking through the columns available in the ReceivablesTransactions view, there is a Document Status column that you should be able to use for this - you would want to exclude any results where the Document Status is "Work".
I haven't looked at that view but it's apparently pulling data from the Work as well as the Open transaction tables. You'll either need to determine how to filter the Work transactions out of the results or create another view that doesn't pull the Work transactions in (RM10101, RM10201, RM10301).
Also, we are using Report Builder 2.0. Thanks! 3.0 won't connect to our server for some reason.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (