Suzy Rabb
  • Female
  • Austin, TX
  • United States
Share Twitter

Suzy Rabb's Friends

  • Linda Huff
  • Abbycrown
  • Helen Massey
  • Lloyd Smith
  • Cheryl Manmohan
  • Gary Boddington
  • Ruth Gray

Suzy Rabb's Groups

Suzy Rabb's Discussions

GL Cash Transactions-Beginning Cash Balances
3 Replies

BackgroundNeed to do various analysis, reporting on cash transaction detail and balances, so need a data container that can pull all cash account transactions.Using demo company Bellwether via Sage…Continue

Tags: Sage, 50, Balances, Beginning, Transactions

Started this discussion. Last reply by Nigel Naicker Jun 13.

Union Report-Pivot Table Field Name is Not Valid
1 Reply

Ok, hope somebody out there can help me figure this one out.I'm working on a union report with 5 sub reports, using Sage 50 US.  At one point, when running the union report, it errored out with…Continue

Tags: Report, Sub, Union, US, 50

Started this discussion. Last reply by Shwu Hua Gan Dec 16, 2013.

PR Report-How to Link to Time Ticket Data
1 Reply

I've successfully built a limited Sage 50 Payroll data container to pull and present employee and pr transaction activity.  Now I'd like to enhance it to include a link to time tickets.In this case,…Continue

Started this discussion. Last reply by Stephen Coull Nov 27, 2013.

Sage 50 Intelligence Error-It was not possible to connect to the database
4 Replies

I developed BI reports for a client on my system and successfully imported them to their system.  However upon running these reports OR any standard BI report on their system, I get this error.…Continue

Tags: Error, 50, Sage

Started this discussion. Last reply by David Polk Aug 8, 2013.

 

Suzy Rabb's Page

Latest Activity

Nigel Naicker replied to Suzy Rabb's discussion GL Cash Transactions-Beginning Cash Balances
"Wow, so essentially you are saying that the values you want arn't in the JrnlRow table, i have had some issues myself where i cant find some of  the transactions for balances listed in the ERP (for Bellwether)..  best bet is to…"
Jun 13
Suzy Rabb replied to Suzy Rabb's discussion GL Cash Transactions-Beginning Cash Balances
"Unfortunately no. I even tried to setup a single file data container and report for just the JrnlRow file with no filters, parameters.  Same result with regard to GL account beginning balances.  The same beginning balance entry came over,…"
Jun 12
Nigel Naicker replied to Suzy Rabb's discussion GL Cash Transactions-Beginning Cash Balances
"Hi, Does removing the where clause from your container help?"
Jun 12
Suzy Rabb posted a discussion

GL Cash Transactions-Beginning Cash Balances

BackgroundNeed to do various analysis, reporting on cash transaction detail and balances, so need a data container that can pull all cash account transactions.Using demo company Bellwether via Sage 50 2015 for testing.Have a data container, report that should be pulling all cash account transactions through 5/31/15.Everything working great EXCEPT data container is not pulling in ALL cash balances entered as beginning balances.  Odd…. I’m getting the beg balance for one of the cash accounts, but…See More
Jun 11
Les Allen replied to Suzy Rabb's discussion How to Lock the Container? in the group Sage 50 U.S. Edition Intelligence Reporting
"Unless someone from Sage Intelligence can confirm that the functionality will be activated sometime soon (if at all), then there's not much else I'm afraid. Anyone with Connector access would be able to review the containers unless their…"
May 1
Suzy Rabb replied to Suzy Rabb's discussion How to Lock the Container? in the group Sage 50 U.S. Edition Intelligence Reporting
"Thanks for the info.   So, there is no way to currently lock or protect a custom data container built via Sage 50 US?  Or could there some other less obvious or undocumented way that might effectively lock others out? Wanted to post a few…"
May 1
Les Allen replied to Suzy Rabb's discussion How to Lock the Container? in the group Sage 50 U.S. Edition Intelligence Reporting
"Hi Suzy, Been a while since I played with 50 US Edition, but I can provide some background. The original product (i.e. pre-Sage) did have functionality that allowed a report writer to protect the report and the container itself when exporting…"
Apr 30
Suzy Rabb added a discussion to the group Sage 50 U.S. Edition Intelligence Reporting
Thumbnail

How to Lock the Container?

I have a report manager and connector license and am accessing Sage 50 US with an administrator level logon. While it is very straightforward on how to lock a Sage Intelligence report, I'm not yet finding clear directions on how to lock a data container that I've written. I see help directions on unlocking the container, but nothing yet on how to initially lock it.  I read some older posts that indicated I could right click on the container name via the connector and see an option to lock…See More
Apr 28
Linda Huff left a comment for Suzy Rabb
"Thank you...This is a place I am finding very useful. Much appreciated!"
Feb 24
Shwu Hua Gan replied to Suzy Rabb's discussion Union Report-Pivot Table Field Name is Not Valid
"Hi Suzy, If I understand correctly, you get the error when having the Pivot Table in Sheet 1, which is normally the data sheet?   What if you include the Pivot Table in a non-data worksheet?  "
Dec 16, 2013
Suzy Rabb posted a discussion

Union Report-Pivot Table Field Name is Not Valid

Ok, hope somebody out there can help me figure this one out.I'm working on a union report with 5 sub reports, using Sage 50 US.  At one point, when running the union report, it errored out with "Pivot table field name is not valid". I eliminated one report from the union at a time and reran the report until I found the report causing the error.  Without it in the group, I do not get the error.At one point, there was a pivot table on sheet 1 to the far right of the data range for the pivot table…See More
Dec 16, 2013
Stephen Coull replied to Suzy Rabb's discussion PR Report-How to Link to Time Ticket Data
"Great question Suzy, sorry I cannot help but would suggest you try an obtain a Sage 50 US data dictionary from their Product Manager, as this should contain the info you are looking for. Good luck!"
Nov 27, 2013
Suzy Rabb posted a discussion

PR Report-How to Link to Time Ticket Data

I've successfully built a limited Sage 50 Payroll data container to pull and present employee and pr transaction activity.  Now I'd like to enhance it to include a link to time tickets.In this case, I want to show some employee and paycheck info, together with that check's related time, by day, from the time ticket record. (BTW: I'm only considering employees with a pay method of "Hourly-Time Ticket Hours").My problem is I'm not seeing how to link a given time ticket back to a given paycheck. I…See More
Nov 26, 2013
David Polk replied to Suzy Rabb's discussion Sage 50 Intelligence Error-It was not possible to connect to the database
"Hi Suzy,   Glad to hear this was resolved with tech support and your client's IT team.    dP"
Aug 8, 2013
Suzy Rabb replied to Suzy Rabb's discussion Sage 50 Intelligence Error-It was not possible to connect to the database
"Thanks.  I'll have the user try to run BI reports from the server and let you know. ? The workstation does "see" the database in order to run Sage 50---no problems with that side....just the BI part. "
Aug 5, 2013
David Polk replied to Suzy Rabb's discussion Sage 50 Intelligence Error-It was not possible to connect to the database
"Reviewing the response, it would appear the workstation cannot see the database.  You may wish to reinstall the workstation Sage 50 (rather than the server).  There may be network permissions involved, that is the workstation/user does not…"
Aug 5, 2013

Profile Information

Alchemex Powers the Following BI Solution, Pick Yours
Sage Peachtree Intelligence
Website
http://121-business.com
About Me:
I'm a Peachtree Certified Consultant and Sage Solution Provider. I'm interested in learning all I can about Peachtree BI
How long have you been using the above solution?
1995
Where did you hear about us?
Invitation
If other, please specify
Peachtree BI Webcast

Comment Wall (2 comments)

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

Join The Sage Intelligence Community

At 3:58pm on February 24, 2014, Linda Huff said…

Thank you...This is a place I am finding very useful. Much appreciated!

At 4:00pm on June 3, 2011, Ruth Gray said…
Welcome to the BI Community Suzy.
 
 
 

© 2014   Created by Sage Alchemex.

Badges  |  Report an Issue  |  Terms of Service