can someone tell me a sql formula to use in a Sales Order container to drop the leading zeros.
I need to match / index to files where the sales order number is entered without the leading zeros.
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…
I'm hitting a wall. My client wants a column in Sage Intelligence to pull only total of net activity for a specific day instead of a period. It has to do with accruals. They don't want to enter accrual journal entries. They want to keep the expenses dated…
When I run my BI reports, I am only given the option to select a month to display. How can I run the report for a prior fiscal year?
The fact that I can only run reports for the current fiscal year, causes me great concern at year end. As soon as I…
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…