Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

 
Items for 'Baan' (by date)
By Date  
Alphabetically By Date  

 

You are browsing all items of this content category sorted by date (most recent first). 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.

 

ERP Planning Tip #5: The Importance of Accurate Inventory Data
By Jonathan Gross at 29 Aug 2011 - 21:23

In our previous ERP planning tip, we discussed routings, the final data set-up requirement for making an item. In this tip, I dig deep into another critical data requirement – the need to maintain timely and accurate inventory counts and movements.

 

If inventory counts and movements aren’t accurately reflected in the planning engine, MRP will issue inaccurate recommendations. This might mean that replenishment order recommendations are issued to soon – which could lead to unnecessary increases in operating costs and constraints to cash flow. It might also mean that replenishment order recommendations are issued too late – which could create customer churn caused by avoidable order delays. Finally, it might mean that replenishment order recommendations are made for the wrong items or quantities – which could result in unnecessary orders of depreciating inventory.

 

The key, therefore, is to ensure that the planning engine issues planning recommendations for the correct items and quantities at the appropriate times. To issue just-in-time, time phased replenishment orders, the planning engine requires five basic data elements:


Infor ERP LN and Baan Planning Tip #4: Routings - The Final Data Requirement
By Jonathan Gross at 27 Jul 2011 - 21:56

In our previous ERP planning tip, we discussed the bill of materials (BOM), which discussion answered the following questions: which and how many components are needed to produce an item. This tip deals with routings, the final data set-up requirement. <--break->

Routings

Routings are the – manufacturing methods – the sequence of steps and related times that are needed to make an item. Production routings specify the ordered list of tasks used to manufacture a product. In addition to the standard routing, a product might have alternate routings (the selection of which depends on the situation). When a production work order is created to manufacture the product, one of the possible routings is chosen.

A typical routing is represented by a series of operation steps. Each step contains a task, various times related to the task (and other parameters), as well as the next operation step in the sequence.

For example:

Routing Table



Infor ERP LN and Baan Planning Tip #2: Get Quantity and Lead Time Right
By Jonathan Gross at 8 Jun 2011 - 15:58

In this series of bi-weekly tips, we break down the secrets to effective replenishment planning and shop scheduling. Pemeco Consulting is a leading vendor-agnostic provider of Supply Chain and ERP services to companies running Infor LN and Baan ERP systems. Learn about our niche speciality Infor LN and Baan ERP services and our Planning Dashboard for ERP LN and Baan.

 

In our previous ERP planning tip, we discussed the importance of feeding an MRP system - or a planning engine - accurate and timely data. In this tip, we start to dig a bit deeper into the types of data that a planning engine needs to make meaningful recommendations.

 

Though obvious to many, it’s important to mention that a planning engine generates supply recommendations relating to both existing orders and new orders.

 


ERP M&A: Do Infor Users Win or Lose? It Depends
By Jonathan Gross at 28 Apr 2011 - 16:03

In my February article, ERP Buyer’s Corner: Making 2011 the Year of Success, I predicted that “some of the bigger ERP vendors [would] go acquisition hunting to quickly fill strategic gaps in their product repertoires.” This prediction has come true in spades.

 

A few days ago, GC Software Holdings, Inc. – an affiliate of Golden Gate Capital and Infor – agreed to acquire Lawson, another Tier II ERP vendor for about $2 billion (U.S.). The intention is to integrate the Lawson ERP suite (M3 and S3) into Infor's software suite. This acquisition follows Infor's recent integration of SunSystems, financial management software.

 

This recent M&A activity is likely to have both positive and negative effects on Infor's ERP LN and Baan users.

 

In terms of the positive – and assuming that Infor/GC Software can successfully pull off the integration – Infor's ERP LN and Baan users could achieve the following benefits:


How long does it take your company to run a Full Regenerative run of MPS/ MRP (Initialize & Roll, Gen Order Pln & Gen Item Pln)?
By kphipps at 19 Nov 2010 - 16:09
Less than 1 hour
33% (30 votes)
Between 1 & 2 hours
13% (12 votes)
Between 2 & 3 hours
11% (10 votes)
Between 3 & 4 hours
9% (8 votes)
Between 4 & 5 hours
9% (8 votes)
Between 5 & 6 hours
2% (2 votes)
Between 6 & 7 hours
2% (2 votes)
Between 7 & 8 hours
4% (4 votes)
Over 8 hours
17% (16 votes)
Total votes: 92

Tips for Multi-company / Calculated items in MS SQL query
By Hitesh Shah at 23 May 2009 - 11:18

Tips for Multi-company / Calculated items in MS SQL query

If one is using SQL 2000/2005 and one wants to access the same from outside (say MS Excel or .net application or any other application) , one can use the SQL client in conjunction with  following SQL tips.

 

Multi-company query

Though baan driver let’s user access data from same table from multiple companies using compnr specification, in the MS SQL backend the tables are separate with company suffix . If one is to combine the data from multiple companies for same table, Union operator is SQL query is the key. Using this operator also one may need to know from which company the data has originated . In Baan 4GL one can get this with ._compnr field selected . In MS SQL one needs to  hard code the company constant expression in each SQL  query  combined with UNION operator . An example will illustrate this clearly.

 

Select t_leac as Ledger ,t_dbcr ‘Debit/Credit’,t_year as Year ,t_fprd as Period, t_amth as Amount , ‘300’ as company – Constant for company

From ttfgld106300

UNION

Select t_leac as Ledger ,t_dbcr ‘Debit/Credit’,t_year as Year ,t_fprd as Period, t_amth as Amount, ‘301’ as company – Constant for company

From ttfgld106301

 

This example will select data from tfgld106 of 300 and 301 company.

 


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.

 


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. 


Ovet chooses the Ometa Integrator solution to integrate SharePoint and BaaN
By baanlude at 28 Jan 2009 - 11:47
OVET, a company in the south of the Netherlands specialized in the transshipment, storage and processing of bulk products, chooses the Ometa Integrator solution to build Portals in SharePoint integrated with BaaN IV. For more information read the customer case: http://sharepoint.ometa.net/en/Pages/CustomerCaseOvet.aspx


All times are GMT +2. The time now is 17:37.


©2001-2018 - Baanboard.com - Baanforums.com