Debby Beck
  • Female
  • Charlottetown
  • Canada
Share

Debby Beck's Friends

  • Kayshree Govender

Debby Beck's Groups

Debby Beck's Discussions

Sage 300 Intelligence error running GL Transactions
1 Reply

I am getting the following error when running a report for one fiscal period but not others[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from…Continue

Started this discussion. Last reply by Tesh Jan 23.

How to automatically have new GL accounts show up in Financial Statement Sage 300
3 Replies

I created a very large Financial Report (Income Statement) in Sage 300 Intelligence using Financial Report Designer (not the layout generator).  Instead of using Account Groups (in the Lists…Continue

Started this discussion. Last reply by NATE Oct 25, 2017.

GL Transaction Listing report - how to change the sign from negative to positive
4 Replies

I created a Financial Report using Financial Reporter in Sage Intelligence for my client.  I also added a sub-report to show GL Transaction Listings.  My question is - can I change the sign from…Continue

Started this discussion. Last reply by Glynnis Sep 5, 2017.

Payroll costing report
1 Reply

I have a client that runs a very cumbersome labour intensive report each month that they would like to get some or all of it done in Intelligence.This is a potato business that currently captures…Continue

Started this discussion. Last reply by Tesh May 11, 2017.

 

Debby Beck's Page

Latest Activity

Tesh replied to Debby Beck's discussion Sage 300 Intelligence error running GL Transactions
"Hey Debby This usually happens when you have an account number which looks like a date, for example if you have an account like 101217, it confuses the system into thinking it might be a date,  Try this, open your report in design mode and…"
Jan 23
Debby Beck posted a discussion

Sage 300 Intelligence error running GL Transactions

I am getting the following error when running a report for one fiscal period but not others[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.I have searched the forum, but not able to make any of the suggested solutions work.Any assistance would be appreciated.DebbySee More
Jan 10
NATE replied to Debby Beck's discussion How to automatically have new GL accounts show up in Financial Statement Sage 300
"That's great as thats what i was going to suggest to you. You can also find some helpfull information on the two below links:  https://www.youtube.com/watch?v=0iSoZx5WpWY https://www.youtube.com/watch?v=AQZtNn1VJVk Have a great day :)"
Oct 25, 2017
Debby Beck replied to Debby Beck's discussion How to automatically have new GL accounts show up in Financial Statement Sage 300
"We are using Sage 300 Version 2017.  I just found out that this version uses Dynamic Account Ranges, so that should work for me!  Thanks for the reply."
Oct 25, 2017
NATE replied to Debby Beck's discussion How to automatically have new GL accounts show up in Financial Statement Sage 300
"Good day What version of Sage 300 are you on currently?"
Oct 25, 2017
Debby Beck posted a discussion

How to automatically have new GL accounts show up in Financial Statement Sage 300

I created a very large Financial Report (Income Statement) in Sage 300 Intelligence using Financial Report Designer (not the layout generator).  Instead of using Account Groups (in the Lists section), I used Accounts.  So, now when a new GL account is added, the report doesn't pick it up (even though it is in the Actuals worksheet.  How can I get the report to automatically pick up these new accounts?See More
Oct 24, 2017

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 300 ERP Intelligence Reporting (Formerly Accpac), Sage 50-Canadian Edition Intelligence Reporting (Formerly Simply Accounting)
Website
http://excelpei.com
About Me:
I am a consultant for both Sage 300 and Sage 50
How long have you been using the above solution?
7 years
Where did you hear about us?
Sage Intelligence YouTube Channel

Comment Wall

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

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service