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

Suzy Rabb's Friends

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

Suzy Rabb's Groups

Suzy Rabb's Discussions

Sage 50 US-Need Help Setting up an Alias Table
1 Reply

Anyone know of any documentation for setting up Alias Tables with Sage Intelligence?  Situation: I'm working with Sage 50 US.  I need both the Salesperson Employee ID (sales invoice) as well Employee…Continue

Tags: SQL, Alias, US, 50, Sage

Started this discussion. Last reply by Peter Scully Aug 22.

Sage 50 US-Need Help Setting up an Alias Table
3 Replies

Anyone know of any documentation for setting up Alias Tables with Sage Intelligence?  Situation: I'm working with Sage 50 US.  I need both the Salesperson Employee ID (sales invoice) as well Employee…Continue

Tags: SQL, Alias, US, 50, Sage

Started this discussion. Last reply by David Bryant Aug 25.

Report Designer Task Pane Questions-Sage 50 US 2015.1
5 Replies

We just got the Report Designer Task Pane feature in late July (2015.1) for Sage 50 US, so giving it a whirl for a new project.  Overall I'm liking what I see, but running into a a few issues I'm…Continue

Tags: Accounting, Periods, Accounts, Zero, Pane

Started this discussion. Last reply by Suzy Rabb Aug 5.

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.

 

Suzy Rabb's Page

Latest Activity

David Bryant replied to Suzy Rabb's discussion Sage 50 US-Need Help Setting up an Alias Table
"Sorry Suzy, I thought I had responded to your earlier message. Glad you found a solution, and thanks for helping out, Shwu. "
Aug 25
Peter Scully replied to Suzy Rabb's discussion Sage 50 US-Need Help Setting up an Alias Table
Aug 22
Suzy Rabb replied to Suzy Rabb's discussion Sage 50 US-Need Help Setting up an Alias Table
"But of course!  Just tried it and works like a charm!  Thanks so much!"
Aug 21
Shwu Hua Gan replied to Suzy Rabb's discussion Sage 50 US-Need Help Setting up an Alias Table
"Have you tried LEFT JOIN “Employee” as “LaborEmployee” ON “JrnlRow”.”EmpRecordNumber” = “LaborEmployee”.”EmpRecordNumber”"
Aug 21
Suzy Rabb posted discussions
Aug 20
Suzy Rabb replied to Suzy Rabb's discussion Report Designer Task Pane Questions-Sage 50 US 2015.1
"Ok, I'll do that.  I did some more testing here.  Ran financial designer with sample data and it worked here.  I created a company with 13 4 week periods and that worked too.  I took a closer look at this client's…"
Aug 5
Peter Scully replied to Suzy Rabb's discussion Report Designer Task Pane Questions-Sage 50 US 2015.1
"Hi Suzy. Try using the ZeroingII add-in in the Report Manager to hide zero rows. You might just need to play with the configuration a bit to get the desired results."
Aug 5
Suzy Rabb replied to Suzy Rabb's discussion Report Designer Task Pane Questions-Sage 50 US 2015.1
"Peter, Thanks sooo much for looking at this! Please send me your email address and I'll get it to you fast!  BTW .... the key thing different with this company is that it does not have accounting periods that match months.…"
Aug 4
Peter Scully replied to Suzy Rabb's discussion Report Designer Task Pane Questions-Sage 50 US 2015.1
"Hi Suzy. Add-ins like Hide Zero Rows were designed to work with old report types and so have not been included in the new Report Designer, i.e. the Financial Report Designer report. Some of these old report types are still included in Sage 50 and…"
Aug 4
Suzy Rabb replied to Suzy Rabb's discussion Report Designer Task Pane Questions-Sage 50 US 2015.1
"Update: Digging through the hidden sheets and found one that looks like it should hold all the info I need, but no data is coming through to this sheet.  See attached.  FiscalYearDetails Anyone know why?  Is this bug? "
Aug 3
Suzy Rabb posted a discussion

Report Designer Task Pane Questions-Sage 50 US 2015.1

We just got the Report Designer Task Pane feature in late July (2015.1) for Sage 50 US, so giving it a whirl for a new project.  Overall I'm liking what I see, but running into a a few issues I'm hoping the more experienced Task Pane users can easily address.  Here's the first two.1.  Hide Zero Accounts.  The help screens indicate I should have this option on the BI Tools Tab. I have this tab and several options, but not the Hide Zero Accounts option.   Why?2. Period Ending Dates rather than…See More
Aug 3
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

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.
 
 
 

Like Sage Intelligence?

Follow @SageAlchemex

© 2014   Created by Sage Alchemex.

Badges  |  Report an Issue  |  Terms of Service