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.
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.
Are you looking to do this in Sage Intelligence?
yes, Sage Intelligence
Is this for an existing report?
yes. it's a GL detail report
Does GL Period End get done before the 10th?
Does GL Period End get done before the 10th?
*Community Hub is the new name for Sage City