Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

 
Browse Items for 'Microsoft' (aphabetically)
By Date  
Alphabetically By Date  

 

You are browsing all items of this content category sorted alphabetically. Note that forum posts/threads are not included here.

 

If you would like to search through the content then please refer to the Site Search page.

 

3 Easy Ways to Avoid an ERP Software Project Disaster
By daldridge at 27 Dec 2014 - 18:43


Administrator (Infor LN/Baan) (w/m)
By MIGAVIS at 19 Mar 2014 - 17:03
About the recruiter
Contact Name: 
MIGAVIS International
Contact Method: 
E-mail
Contact Method: 
Phone
Contact Details: 

Mail: boztepe@migavis.de Phone: +49 30 - 258 188 85

About the position
Availability: 
Yes
Employment Type: 
Permanent
Role: 
Systems Administrator
Languages: 
English
German
Keywords: 
(System)-Administrator Baan - Infor LN, Microsoft Dynamics
Industry: 
Administration
About the location
Country: 
Germany
About the applicant
Nationality: 
Anybody may apply
Experience: 
1years

Bei einem unserer namhaften Kunden in Berlin, Tochtergesellschaft der Deutschen Telekom AG, bietet sich diese interessante Perspektive im Rahmen einer Festanstellung.

Wir suchen ab sofort erfahrene, kompetente, zuverlässige, eigenverantwortliche und motivierte Administrator für Unternehmenslösungen (Infor LN/Baan) (w/m).

 

Profil: 

  • Gute Kenntnisse und Erfahrungen in Administration und Betrieb kommerzieller Unternehmens-Applikationen (Infor/Baan, SAP, Microsoft Dynamics o.ä.)
  • Kenntnisse in der Administration professioneller Datenbanken wie Oracle, SQL Server oder Informix.
  • Erfahrungen mit der Administration von Windows- bzw. Unix/Linux-Plattformen
  • Erfahrung im Umgang mit virtuellen Umgebungen wie z.B. VMware ESXi

 

 Aufgaben: 

  • Überwachung von Systemen unter Hinzunahme von Nagios und InerMapper
  • Konzept und Implementierung von ERP-Systemen, von der Hardware bis zur Anwendung
  • Administration von virtuellen Umgebungen
  • Kunden-Support
    Wenn es Ihnen alles soweit passt, können Sie sich gerne bewerben.   Kontaktdaten: Mail: boztepe@migavis.de Tel: 030 - 258 188 85 

 


Advanced Excel Training resources
By Hitesh Shah at 20 Feb 2009 - 07:44

Advanced Excel Training blog 

Spreadsheets are great number-crunching analytical tools. Knowing it’s analytical capabilities and generating MIS speedily with such spreadsheets, is very critical to success of any manager. And it’s successful usage ensures insights unlimited, ingenuity guaranteed and intelligence free from any shackles. And this in turn leads to lean and mean system architecture least recurring costs while maximizing gains.

Here is a blog to sharpen one's MS Excel analytical skills of Baan and ERPJewels users with lots of training material for MS Excel. Though most  training material is specific to Office 2007, it can be useful for earlier (or even later) versions for most compatible features and functions. One can download this MS Excel training resources from this link. The zip file contains following documents. 


Blog: Is Infor ERP Enterprise Ready to Challenge SAP and Oracle?
By daldridge at 3 Dec 2011 - 20:39

Hello all - Wanted to share our latest blog post about Infor ERP Enterprise http://www.i-app.com/blog.html and ask a question of the group.  How important is the availability of experienced Infor ERP LN and Baan consultants for your decision to upgrade to Infor10?


Customer / Supplier financial analysis in pivot table
By Hitesh Shah at 7 Feb 2009 - 13:17

Now it is becoming increasingly clear that users need liveliness and interactivity on static data from OLTP. This is possible through multi-dimensional modeling available in free-form pivot table or cube structures. As there are not many cube applications and not many established routines to populate cubes incrementally periodically automatically, report-directly-in-excel is becoming vogue.  Though most summarized multi-dimensional modeling cab be done easily with old MS Excel 2003, with excellent enhancement in MS Excel 2007, scalability and liveliness has increased manifold in pivoting (multi-dimensional modeling using pivot table).

All that one need is accurate, reliable and relevant figures side-by-side in CSV format for all dimensions / measures to follow report-directly-in-excel-with-data-dict-advantages strategy. For example, here is a baan report which gives all important dimensions/measures related to customer financial behavior.

 

Here is the list of dimensions:

 


Emerging concurrence on BI
By Hitesh Shah at 23 Jun 2010 - 18:23

There appears to be some concurrence emerging on BI front in the BI community. Such concurrence can be like

 

1. MS office (and MS excel in particular) integration with application is identified as important first & foremost component of BI for large and small enterprise equally.

 

2. As the company BI requirements grow, people can explore and deep dive into collaborative software Sharepoint , data warehouses , reporting tools and services etc .

 

Here are the links from where above conclusions seems to be emerging.

 

Office 2010 heeds BI propagation

 

Don’t dismiss Excel in your BI strategy

 

Microsoft Promises BI For The Masses With PowerPivot For Excel

 

 

Even Infor is buddying up with MS . So users may not have to worry for office integration at all and depend on any 3rd party products !!

 


Excel Assisted reporting strategy for Baan customers
By Hitesh Shah at 1 Mar 2009 - 10:25

Here is a blog on a reporting strategy for baan complemented with Excel load clients. This blog discusses various approaches to reporting in Excel and ingredients of successful Excel assisted baan reporting.

 

WHO SHOULD READ THIS  

One should read this blog if:

  1. one is very much comfortable with existing authorizations and semantic layer in Baan (Read baan data dictionary ) technically ( table/domain /field codes ) and functionally (descriptions )  and
  2. one wishes to capitalize on  existing learning and knowledge of existing semantic layer in Baan (technically as well as functionally )  and do not wish to invest (or waste??) in learning / migrating /adopting / translating / maintaining new semantic layer for reporting
  3. one is very much adept at using Baan reporting and programming for routine documents  and
  4. one’s users enjoy the freedom, flexibility and functionality of spreadsheets (which may be freeware also) for analytical purposes.
  5. there are sufficient Office licenses already with company on PCs with high CPU and memory ( far exceeding basic Excel requirements and which have become norm rather than exceptions ) in one’s place and there is high need to optimally utilize  these resources  and to reduce the load on servers .

WHO SHOULD NOT READ THIS  

One whose objectives are different OR who don’t have any objectives only OR who is extremely satisfied with their current reporting already.

 


Excel based dashboards Sample
By Hitesh Shah at 17 Jan 2010 - 19:00

Online dashboards are frequent user queries / reports with set of all inter-related questions capable of being answered by the dashboard under user control (and not the user under control of dashboard).

 

Online Multi-dimensional modeling, online slicing & dicing ,charting & graphical analysis (thermostat, speedometer ,charts etc ) , drill-down to details for exceptional item etc are some of the essential features of dashboards.

 

Here is a sample of an excel based dashboard which gives online trial balance in multi-dimensional format with possibility to drill down to details from any database through ADODB.

 

Here are the links one can use to study , understand ,develop and use XL based dashboards.

http://www.erpjewels.com/Excel based Trial balance dashboard report.docx

http://www.erpjewels.com/trialbalance.xlsm

 

Getting graphs /charts with symbols like thermostat / speedometer etc are very easy. One can see umpteen online resource like following in the internet.


Free Excel Add-ins from Oracle / Microsoft & others
By Hitesh Shah at 21 Mar 2009 - 17:47

While working on analysis services found certain good Excel add-ins available freely. Though some of the add-ins are not useful to us as we already have long established smart programs to accomplish much more than these add-ins do , I indicate the same here for those who may wish to use such approach for their excel integration with their database ( whatever it be ).

 


Funds Flow statement in Excel Pivot Table directly from Baan
By Hitesh Shah at 30 Jan 2009 - 04:54

Just-do-it-in Excel has been long time successfully deployed strategy deeply embedded in ERPJewels tool of Jewelex. Now  there are many takers and followers for the same. One can vouch this in Just-do-it-in-excel. Reasons for this are not far to seek.



All times are GMT +2. The time now is 08:39.


©2001-2017 - Baanboard.com - Baanforums.com