Marius Yung
  • Male
  • Taipei City
  • Taiwan
Share

Marius Yung's Friends

  • vanessa Herbert
  • Howard Whiting

Marius Yung's Groups

Marius Yung's Discussions

Sage 300 Web Screen

Other than Financial Report, is it possible to design other Intelligence report and able to run in Web screen? Any Document or Material?Continue

Tags: webscreen

Started Mar 1

Sage Intelligence Analysis with MSSQL

Any body have document or video about how to using Sage Intelligence Analysis with MSSQL?Continue

Started Dec 11, 2018

Sage300 Backup Container only.
2 Replies

Other than create a report.Would you kindly let me know how can I my specific Container only?Continue

Started this discussion. Last reply by Marius Yung Dec 11, 2018.

External Database with Report Designer
4 Replies

Is it possible to define a external Database, Container & Report......and use report designer finally?Continue

Tags: designer, Report

Started this discussion. Last reply by Marius Yung Dec 7, 2018.

 

Marius Yung's Page

Latest Activity

Marius Yung posted a discussion

Sage 300 Web Screen

Other than Financial Report, is it possible to design other Intelligence report and able to run in Web screen? Any Document or Material?See More
Mar 1
Marius Yung replied to Bob Beaucage's discussion Distribution Settings and Scheduler
"You have to create 2 different reports for different distribution settings."
Feb 18
Marius Yung replied to Prakash's discussion Sage 300 Intelligence Reporting : An Unexpected Error Occurred Error Number : [-2147217865] Description : [[Microsoft][ODBC SQL Server Driver][
"Can you show your expression?"
Jan 30
Marius Yung replied to Prakash's discussion Sage 300 Intelligence Reporting : An Unexpected Error Occurred Error Number : [-2147217865] Description : [[Microsoft][ODBC SQL Server Driver][
"If you join your table CSCRD correctly. Your expression should be [CSCRD].[RATE], why you want to RTRIM it?"
Jan 30
Marius Yung replied to Prakash's discussion Sage 300 Intelligence Reporting : An Unexpected Error Occurred Error Number : [-2147217865] Description : [[Microsoft][ODBC SQL Server Driver][
"Which version of Sage 300 do you using?if v6.5, you should add your data container under ODBC Driver SQL Server > Sage Accpac (Auto Connect)."
Jan 29
Marius Yung replied to Howard Whiting's discussion Adding a field to the Detailed AP Aged Payables container
"do you just want to add a expressions from this container (AP Aged Payables)? if so, just add a SQL Join with [Table].[Field] in Expression Source is fine."
Jan 19
Marius Yung replied to Carol Nunkovich's discussion Date ranges in Sage Intelligence
"add the where in your container statement i.e. Where DATEDIFF(day, SHIPDATE, Getdate()) <7"
Dec 24, 2018
Marius Yung posted discussions
Dec 11, 2018
Marius Yung replied to Marius Yung's discussion Sage300 Backup Container only.
"Thanks."
Dec 11, 2018
Sandra Smith replied to Marius Yung's discussion Sage300 Backup Container only.
"Hi Marius,  We don't have a backup feature for just the Container however, you can make a copy of the Container and then use the Backup Metadata and template feature.  You can find the instructions by going to the View Help icon in…"
Dec 10, 2018
Marius Yung posted a discussion

Sage300 Backup Container only.

Other than create a report.Would you kindly let me know how can I my specific Container only?See More
Dec 10, 2018
Marius Yung replied to Marius Yung's discussion How Pass though Parameter collect as an array
"We are using Sage300.  It is because record too much, Select parameter before report generate become important. Usage range as parameter cannot fit customer requirement.  Customer needs multiple selection."
Dec 10, 2018
Marius Yung replied to Marius Yung's discussion External Database with Report Designer
"Actually, we have added sub-ledger & external data to different data sheets, which related to customer from CRM. We wish we able to add similar function as GL.  Anyway, Thanks your information."
Dec 7, 2018
Jim Smith replied to Marius Yung's discussion External Database with Report Designer
"You would have to replicate the data sheets (and there are numerous data sheets) to match those that you would get from a Sage 300 database. Same sheet names, same column names, same named ranges, maybe a few other things. You would basically have…"
Dec 6, 2018
Marius Yung replied to Marius Yung's discussion External Database with Report Designer
"Thanks your reply. Report designer able to generate figure by function followings:  GLActualYTD300(,$D$4,$D$5,$D$6,,$C$12,,,$D$7,$D$8) What I mean is....Can I create similar function for my new external data? "
Dec 6, 2018
Sandra Smith replied to Marius Yung's discussion External Database with Report Designer
"Hi Marius, I'm not sure I understand your question. You can connect to a database outside of Sage (or tables within Sage) using the Connector module then create a container (joining tables) then you can create a report using Report Manager.…"
Dec 5, 2018

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
SAP Business One, Sage Accpac Intelligence
How long have you been using the above solution?
1 year for Alchemex
Where did you hear about us?
Other

Comment Wall (1 comment)

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

Join The Sage Intelligence Community

At 11:23am on June 24, 2011, Ruth Gray said…

Hello and welcome to the BI Community. For access to videos, user guides, data dictionaries and much more. Join the Sage ERP Accpac Intelligence Group. http://community.alchemex.com/group/sageaccpacintelligence

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service