What is the sql statement needed to get the last full month for a pass-through variable.
Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month.
As always thanks in advance for your assistance…
When I try to filter the GL Transaction Details report for certain accounts, not all of the accounts show up in the drop down list.
For instance it only goes to account 7700, but I have hundreds of accounts after that.
Can anyone help. I feel like…
Sage 100 2019 Sage Intelligence. How do I add company code from the SYO_Company table to my joins? In Crystal we would use "Not Equal" as a join for company name. In SI, Connector, there is only Right Join, Inner, and Outer. How do I get the company name…
I am pulling from the table used in the PR_EarningsReport but not all fields are being populated in my query. For example, I can get Employee Number but not First and Last Name?
We are looking for a way to separate our YE AJE's. It was suggested to us to use a source code named AJ. We'd like to create a set of financials that shows the unadjusted trial balance, then the AJE's, and then the final balances.
So, my question is…
I have created a new database container and most of the field in the container are available for filtering, but a couple of them are not. I really need to use one of the fields to filter my report. Why are some field not allow to be used in the parameters…