Forum

Period end date 7 Replies

Started by Doug Jenkins in Sage 100 and 500 ERP Intelligence Reporting. Last reply by Marilyn Connor 1 hour ago.

Subquery Returns More Than 1 Value --> How to Retrieve all values in one field? 1 Reply

Started by Rhonda Paton in General. Last reply by Rhonda Paton 2 hours ago.

How to do intercompany eliminations on consolidated reports 2 Replies

Started by Marilyn Connor in Sage 100 and 500 ERP Intelligence Reporting. Last reply by Marilyn Connor 3 hours ago.

Sage 100 Roll Up Code List 2 Replies

Started by Anna-Lisa Hunter in General. Last reply by Anna-Lisa Hunter 6 hours ago.

Latest Activity

Marilyn Connor replied to Doug Jenkins's discussion Period end date
"Thanks, Joe.  I'm not an Excel wizard, but I think I can follow what you're doing.  My customers have history going back 7+ years - I guess I would have to have a reference page for all possible periods, including future ones.…"
1 hour ago
Joe Uhl replied to Doug Jenkins's discussion Period end date
"I have a control sheet that has 3 parts: Current period and year, Date table, and format area. The current period and year is NOT the one for accounting system but for the reports. The date table has all 12 or 13 periods listed with columns for some…"
1 hour ago
Rhonda Paton replied to Rhonda Paton's discussion Subquery Returns More Than 1 Value --> How to Retrieve all values in one field?
"Sorry, I just noticed my pasted picture didn't work in the comment above. The error is: [Microsoft][ODBC SQL Server Driver][SQL Server] Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=,…"
2 hours ago
Marilyn Connor replied to Doug Jenkins's discussion Period end date
"Thanks, DougW.  Interesting, but it only works for calendar year fiscal years, and only for the current month.  Most of my customers have non-calendar fiscal years, like October to September, for instance, and they always need to report on…"
2 hours ago
 
 
 

Like Sage Intelligence?

Follow @SageAlchemex

© 2014   Created by Sage Alchemex.

Badges  |  Report an Issue  |  Terms of Service