Robin Saacks Male Los Angeles United States: Share on Facebook

Share Twitter

Blog Posts
Discussions (3)
Groups (1)
Photos
Photo Albums
Videos

Robin Saacks's Friends

View All

Robin Saacks's Groups

Sage ERP MAS Intelligence

124 members

View All

Robin Saacks's Discussions

An overflow occurred while converting to datetime
1 Reply

Started this discussion. Last reply by Keith Govender Jan 25.

Current Period

Probably the most important column in financial reporting is the Current period. How can one create a column that has only the Current Period Activity?Continue

Tags: Period, Current

Started Dec 30, 2011

How do you run / filter a financial report by department in MAS200?
1 Reply

How do you run / filter a standard financial report by department in MAS200?Continue

Started this discussion. Last reply by Stephen Coull Dec 12, 2011.

View All

Robin Saacks's Page

Latest Activity

Keith Govender replied to Robin Saacks's discussion 'An overflow occurred while converting to datetime'

A syntax error is caused when you put values in wrong places when converting or trying to convert a value to a date value. You will need to get a consultant to show you how to convert to Date format correctly. CUSTOMISED REPORTS For the list…

Jan 25

An overflow occurred while converting to datetime

I am getting this error: An overflow occurred while converting to datetimeWhen I create a new user-defined field in MAS in the GL_Posting table and try and add this field to the GL Transactions 2-1 table in the SMI connector module, I get this error when running test data. I suspect the date type from MAS UDF does not comply with the SMI date format. Does anyone know how I can get this resolved?See More

Discussion posted by Robin Saacks Jan 11

1 Comment

Current Period

Probably the most important column in financial reporting is the Current period. How can one create a column that has only the Current Period Activity?See More

Discussion posted by Robin Saacks Dec 30, 2011

0 Comments

Stephen Coull replied to Robin Saacks's discussion 'How do you run / filter a financial report by department in MAS200?'

You would need to add the relevant segment that constitutes the department as a parameter from within the Report Manager. You could choose the "comparator method" to be "IS IN" which would allow you to choose a single department…

Dec 12, 2011

How do you run / filter a financial report by department in MAS200?

How do you run / filter a standard financial report by department in MAS200?See More

Discussion posted by Robin Saacks Dec 12, 2011

1 Comment

Sage ERP MAS Intelligence

Robin Saacks joined Stephen Coull's group Nov 18, 2011

9 Comments

Robin Saacks is now a member of The BI Community - Powered by Alchemex Jul 10, 2011

Welcome Them!

Profile Information

Alchemex Powers the Following BI Solution, Pick Yours: Sage MAS Intelligence, Excel On Steroids

Website: http://www.timacsolutions.com

About Me:: Sage ERP MAS 90 200 reseller in Los Angeles, CA

How long have you been using the above solution?: 7 years

Where did you hear about us?: Other

Comment Wall

You need to be a member of The BI Community - Powered by Alchemex to add comments!

Join The BI Community - Powered by Alchemex

No comments yet!

Welcome to
The BI Community - Powered by Alchemex

Sign Up
or Sign In

You can also sign up with:

Follow Alchemex on twitter

Follow @alchemex

Like Alchemex on facebook

This Weeks Top Content

1	Sage MAS Intelligence Report Designer and 13 fiscal periods
2	SQL Join using 2 fields
3	Create and Link does not save account mapping
4	SMI Consolidating companies w/different fiscal years
5	Pivot table from sheet 1 and sheet 3