Sage 100

Does anyone know whether v2018 supports multiple Rollup Codes per Rollup Type when creating a financial report with Report Designer? A Sage KB from August 2016 says that only one code/value per Rollup Type is supported but that they planned on adding more. My Intelligence has crashed so I can't determine the answer myself.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------

There are 4 Rollup Type options, however I have only used 1, so I have not tested multiple rollup codes. 



------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------

Michele, to clarify, with that one RollupTypeCode1, do you only have ONE value on the GL accounts, or do you have various values on different accounts?

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------

Original Message:
Sent: 04-22-2019 14:42
From: Michele Herzog
Subject: Intelligence Financials with Rollup Codes

There are 4 Rollup Type options, however I have only used 1, so I have not tested multiple rollup codes.



------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------

There are multiple Rollup Codes per Rollup Type.  Various GL accounts have the same Rollup Code.  On the Sage Intelligence report I created I only used 1 Rollup Type.



------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------

Original Message:
Sent: 04-22-2019 15:02
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

Michele, to clarify, with that one RollupTypeCode1, do you only have ONE value on the GL accounts, or do you have various values on different accounts?

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------


Original Message:
Sent: 04-22-2019 14:42
From: Michele Herzog
Subject: Intelligence Financials with Rollup Codes

There are 4 Rollup Type options, however I have only used 1, so I have not tested multiple rollup codes.



------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]

Sage support says that this functionality has NOT been improved. We only get ONE value per rollup code. Aargh!


------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------

Original Message:
Sent: 04-22-2019 15:02
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

Michele, to clarify, with that one RollupTypeCode1, do you only have ONE value on the GL accounts, or do you have various values on different accounts?

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------


Original Message:
Sent: 04-22-2019 14:42
From: Michele Herzog
Subject: Intelligence Financials with Rollup Codes

There are 4 Rollup Type options, however I have only used 1, so I have not tested multiple rollup codes.



------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]

And the WIN goes to @Michele Herzog​ on this one! Sage support was wrong. Intelligence recognizes all of the Rollup Codes that are set up for a Rollup Type. And for that matter, it recognizes all of the Rollup Codes that are set up for ALL four of the Rollup Types. They all get pulled into the Accounts sheet. 

Thank you, Michele!

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------

Original Message:
Sent: 04-22-2019 16:02
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

Sage support says that this functionality has NOT been improved. We only get ONE value per rollup code. Aargh!


------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------


Original Message:
Sent: 04-22-2019 15:02
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

Michele, to clarify, with that one RollupTypeCode1, do you only have ONE value on the GL accounts, or do you have various values on different accounts?

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)


Original Message:
Sent: 04-22-2019 14:42
From: Michele Herzog
Subject: Intelligence Financials with Rollup Codes

There are 4 Rollup Type options, however I have only used 1, so I have not tested multiple rollup codes.



------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]

Nice job verifying this  @Michele Herzog - this is something I'll be dealing with shortly as well​

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

Original Message:
Sent: 04-22-2019 20:30
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

And the WIN goes to @Michele Herzog​ on this one! Sage support was wrong. Intelligence recognizes all of the Rollup Codes that are set up for a Rollup Type. And for that matter, it recognizes all of the Rollup Codes that are set up for ALL four of the Rollup Types. They all get pulled into the Accounts sheet.

Thank you, Michele!

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------


Original Message:
Sent: 04-22-2019 16:02
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

Sage support says that this functionality has NOT been improved. We only get ONE value per rollup code. Aargh!


------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)


Original Message:
Sent: 04-22-2019 15:02
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

Michele, to clarify, with that one RollupTypeCode1, do you only have ONE value on the GL accounts, or do you have various values on different accounts?

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)


Original Message:
Sent: 04-22-2019 14:42
From: Michele Herzog
Subject: Intelligence Financials with Rollup Codes

There are 4 Rollup Type options, however I have only used 1, so I have not tested multiple rollup codes.



------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]

Related question about Rollup Codes.  I can make  and use Rollup Codes and my Income Statement, but I can't figure out how creating a rollup code (and assigning it to accounts or segments) can create a new income statement type, as shown below.  When this prints, it includes the title of the Rollup Code at the top of each page of the I/S, but I don't know how it was made.


------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

@Rhonda McNamara - So, it adds the name of the rollup code to the dropdown at Income Statement Type, right? Then it prints one statement per code, with the code printing on the top of each page. And that's all I know.  :-)

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------

Original Message:
Sent: 04-23-2019 09:18
From: Rhonda McNamara
Subject: Intelligence Financials with Rollup Codes

Related question about Rollup Codes.  I can make  and use Rollup Codes and my Income Statement, but I can't figure out how creating a rollup code (and assigning it to accounts or segments) can create a new income statement type, as shown below.  When this prints, it includes the title of the Rollup Code at the top of each page of the I/S, but I don't know how it was made.


------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

In my test system (2018), it didn't add that line to the types of income statements, for some reason.  But it did on the system I took the screen shot from.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Original Message:
Sent: 04-23-2019 11:24
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

@Rhonda McNamara - So, it adds the name of the rollup code to the dropdown at Income Statement Type, right? Then it prints one statement per code, with the code printing on the top of each page. And that's all I know.  :-)

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
------------------------------


Original Message:
Sent: 04-23-2019 09:18
From: Rhonda McNamara
Subject: Intelligence Financials with Rollup Codes

Related question about Rollup Codes.  I can make  and use Rollup Codes and my Income Statement, but I can't figure out how creating a rollup code (and assigning it to accounts or segments) can create a new income statement type, as shown below.  When this prints, it includes the title of the Rollup Code at the top of each page of the I/S, but I don't know how it was made.


------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com

I just tested mine and it did add the Rollup Type to the Income Statement Type (see attachment).  Did you apply the Rollup Type/Code to any Accounts?  I'm assuming the different Rollup Codes would be available at Selection Grid Level.
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Original Message:
Sent: 04-23-2019 13:00
From: Rhonda McNamara
Subject: Intelligence Financials with Rollup Codes

In my test system (2018), it didn't add that line to the types of income statements, for some reason.  But it did on the system I took the screen shot from.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------


Original Message:
Sent: 04-23-2019 11:24
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

@Rhonda McNamara - So, it adds the name of the rollup code to the dropdown at Income Statement Type, right? Then it prints one statement per code, with the code printing on the top of each page. And that's all I know.  :-)

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)


Original Message:
Sent: 04-23-2019 09:18
From: Rhonda McNamara
Subject: Intelligence Financials with Rollup Codes

Related question about Rollup Codes.  I can make  and use Rollup Codes and my Income Statement, but I can't figure out how creating a rollup code (and assigning it to accounts or segments) can create a new income statement type, as shown below.  When this prints, it includes the title of the Rollup Code at the top of each page of the I/S, but I don't know how it was made.


------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com

That's what I was expecting, too, @Nancy Hanson. But here's my setup and the report dropdown, with just the regular GL segments. I'm sure I'm overlooking something obvious. 
​




------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Original Message:
Sent: 04-23-2019 13:14
From: Nancy Hanson
Subject: Intelligence Financials with Rollup Codes

I just tested mine and it did add the Rollup Type to the Income Statement Type (see attachment).  Did you apply the Rollup Type/Code to any Accounts?  I'm assuming the different Rollup Codes would be available at Selection Grid Level.
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------


Original Message:
Sent: 04-23-2019 13:00
From: Rhonda McNamara
Subject: Intelligence Financials with Rollup Codes

In my test system (2018), it didn't add that line to the types of income statements, for some reason.  But it did on the system I took the screen shot from.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com


Original Message:
Sent: 04-23-2019 11:24
From: Karen O'Lane
Subject: Intelligence Financials with Rollup Codes

@Rhonda McNamara - So, it adds the name of the rollup code to the dropdown at Income Statement Type, right? Then it prints one statement per code, with the code printing on the top of each page. And that's all I know.  :-)

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)


Original Message:
Sent: 04-23-2019 09:18
From: Rhonda McNamara
Subject: Intelligence Financials with Rollup Codes

Related question about Rollup Codes.  I can make  and use Rollup Codes and my Income Statement, but I can't figure out how creating a rollup code (and assigning it to accounts or segments) can create a new income statement type, as shown below.  When this prints, it includes the title of the Rollup Code at the top of each page of the I/S, but I don't know how it was made.


------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com

------Original Message------

That's what I was expecting, too, @Nancy Hanson. But here's my setup and the report dropdown, with just the regular GL segments. I'm sure I'm overlooking something obvious. 
​




------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Oh for crying out loud.  All three showed up the instant I added one in slot 1!
You are brilliant! And I am facepalming!

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Original Message:
Sent: 04-23-2019 13:49
From: Nancy Hanson
Subject: Intelligence Financials with Rollup Codes

For giggles, try using the first roll up type as it's currently blank. Does that make a difference?

Nancy Hanson

Get Outlook for Android

Please excuse typos and grammatical errors.

Original Message------

That's what I was expecting, too, @Nancy Hanson. But here's my setup and the report dropdown, with just the regular GL segments. I'm sure I'm overlooking something obvious.
​




------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------