Terris
  • BC
  • Canada
Share

Terris's Discussions

Delete union reports quickly
2 Replies

Hi SI folks, Is there a way to delete union reports quickly? The only way I know is to delete the main report and then delete the individual sub reports one by one. It is tedious when there are many…Continue

Started this discussion. Last reply by Terris Mar 13.

retrieve an overwritten template

Hi folks, Anyone know how to retrieve a template that was overwritten by accident? When saving a template, I saved it to the wrong report and said yes when it asked if i wanted to delete the old…Continue

Started Feb 8

Report on debit and credit movement (Sage 300 SI)?
4 Replies

Hi everyone, I did see this question posted before but was not able to find an answer applicable to my situation. I would like to find a way to report on the debit and credit movement for an account…Continue

Started this discussion. Last reply by Gabriela Yates Feb 1.

Easier way to build/edit massive reporting tree? (sage 300)
2 Replies

Hi everyone, I am going to build a reporting tree for 90+ departments. I was wondering whether there is a better way than manually typing everything in? Would be nice to be able to import a csv file.…Continue

Started this discussion. Last reply by Terris Dec 11, 2018.

 

Terris's Page

Latest Activity

Terris replied to Terris's discussion Generating reporting tree reports
"Thanks Sandra!"
Mar 28
Sandra Smith replied to Terris's discussion Generating reporting tree reports
"Hi Terris,  There is no Sage Intelligence functionality that allows it.  I don't know if anyone has any ideas on how to do this. Sandra"
Mar 26
Terris replied to Terris's discussion Delete union reports quickly
"LOLL Thanks!"
Mar 13
Doug Walker replied to Terris's discussion Delete union reports quickly
"Nope."
Mar 13
Terris posted a discussion

Delete union reports quickly

Hi SI folks, Is there a way to delete union reports quickly? The only way I know is to delete the main report and then delete the individual sub reports one by one. It is tedious when there are many sub reports such as the Report Designer reports. Is there a better way to do that? Thanks!!See More
Mar 13
Terris posted a discussion

retrieve an overwritten template

Hi folks, Anyone know how to retrieve a template that was overwritten by accident? When saving a template, I saved it to the wrong report and said yes when it asked if i wanted to delete the old template. Is there anyway I can find the old template?Thanks!!See More
Feb 8
Gabriela Yates replied to Terris's discussion Report on debit and credit movement (Sage 300 SI)?
"That makes sense. I think you are right that a simple GLPOST union should be fairly straightforward to union in. Thank you!"
Feb 1
Shwu Hua Gan replied to Terris's discussion Report on debit and credit movement (Sage 300 SI)?
"Hi Gabriela,  If I understand correctly, FRTRN above is the Financial Reporter formula in Sage 300. Report Designer in Sage Intelligence is getting data from the GL financial summary table GLAFS. So, to include GL Transaction detail debit and…"
Feb 1
Terris replied to Krissy Eide's discussion Filter Data in Report Designer
"Hi Peter,  I added the segment code as an SQL Expression instead of a data field. The SQL statement I use is: SELECT DISTINCT [GLAMF].[ACSEGVAL02] FROM [GLAMF] ORDER BY [GLAMF].[ACSEGVAL02] It seems to work fine for now!"
Jan 30
Gabriela Yates replied to Terris's discussion Report on debit and credit movement (Sage 300 SI)?
"I was also trying to figure out if this is possible in Report Designer without unioning in another report. The FR formula for this is  Debit =FRTRN("NETYTD","","TRANSAMT>0") Credit…"
Jan 22
Jim Smith replied to Terris's discussion Report on debit and credit movement (Sage 300 SI)?
"There is a report that you can get through the Report Utility called General Ledger Transaction Details Including Opening Balances that can give you this information."
Dec 17, 2018
Terris posted a discussion

Report on debit and credit movement (Sage 300 SI)?

Hi everyone, I did see this question posted before but was not able to find an answer applicable to my situation. I would like to find a way to report on the debit and credit movement for an account for certain period. For example, for my bank account, I would like to know how much I had flow in (debit movement) and how much I had flow out (credit movement).I understand for the GLActual300 formula there is an argument on balance type (debit vs credit), but that is to distinguish balance only. I…See More
Dec 15, 2018
Peter Scully replied to Terris's discussion GL Security for Sage Intelligence Reporting
"Hi Terris. What you are suggesting sounds right."
Dec 12, 2018
Terris replied to Krissy Eide's discussion Filter Data in Report Designer
"Hi Krissy,  Were you able to add the filter eventually? I am facing the same situation here. The actual reports does not have segment code as a field. I added the segment code as a data field, but when I use it as a filter, the SQL query that…"
Dec 12, 2018
Terris replied to Terris's discussion Easier way to build/edit massive reporting tree? (sage 300)
"Hi Sandra,  Thanks for your kind help!! I was looking for one for Sage 300 and couldn't find any. So I just went ahead and manually created the tree.. Wasn't too bad. Hope there will be an executable for Sage 300!"
Dec 11, 2018

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 300 ERP Intelligence Reporting (Formerly Accpac)
Where did you hear about us?
Search Engine

Comment Wall (1 comment)

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

At 9:46am on January 9, 2019, Ahmed Maris said…
Good Day,
How is everything with you, I picked interest on you after going through your short profile and deemed it necessary to write you immediately. I have something very vital to disclose to you, but I found it difficult to express myself here, since it's a public site.Could you please get back to me on:( mrsstellakhalil5888@gmail.com ) for the full details.

Have a nice day
Thanks God bless.
Stella.
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service