Go Back

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 43

Baanboard at LinkedIn

Reference Content

Items for 'How-to' (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.


By rajeshkrsaini at 26 May 2009 - 17:52

Dear All ,

We are facing the Problem of Corrupt Inventory in few of the item .

Whenever we issue the item Message "Corrupt Inventory " comes

Anybody has resolve this problem

Thanks in advance





Redundant payment terms
By Pradeepsachdeva at 25 May 2009 - 13:13


Can i disable / deactivate the redundant payments terms ?




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


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.


BaanIVc4/Oracle 10g/Migration issues
By jsbrouse at 8 May 2009 - 19:11

We recently migrated our Baan IVc4 system from Oracle 9i to Oracle 10g and upgraded to porting set 6.1c.07.21 on a HP-UX 11:31 system.


We are having problems with 3 customized sessions we developed for processing records from an external system.  The sessions poll external table (Baan views) and process records to try and make Baan real time. The problems we are experiencing didn’t happen prior to the migration.  Nothing with the sessions changed for the migration.


Only one session actually errors (see below).  Our DBA said this error isn’t an Oracle 10g error.  We did have our programmer put the session in debug to figure out where the problem is happening.  It is happening on a simple select statement.


OpenWorld Connector
By sipotis at 2 Apr 2009 - 09:10

Please can someonone point me to any documentation relating to Openworld Java Connector installation instructions.

I'm trying to determine what I need to get installed on our legacy HP-UX server to be able to communicate to Baan using openworld. Openworld has been installed on our Baan Server.

Apologies if this question has been asked before but I couldn't find an answer & thanks in advance.

SFC Parameters asking for defaults and defaults asking for SFC parameters
By fertena at 30 Mar 2009 - 18:36

When I am trying to setup the "series" for planning in the SFC parameters tisfc0100s000, the system is asking for SFC defaults tisfc0102m000, but when I am trying to create them then system is asking for SFC parameters.  This is like what is first the egg or the chicken??

This is in LN FP3

Do you know how to fix this? is this an error or there is a procedure to fix this???  


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 ).


Print Replenishment Picking List for Shortages Item
By edo_limbat at 20 Mar 2009 - 10:47

Dear All,

 I would like to ask about print RPL Picking List in Baan IVc4.

Does anybody know how to print RPL Picking List for shortages item?

If you all know the process in Sales Order, when we print Picking List for Sales Order, the print out will show us all item include the shortages item (show with dots mark).

Can I print RPL Picking List with the same way like SO? I need to print the shortages item also.

Thanks for your help.

Best Regards,



Calculate Due Date
By chub64 at 4 Mar 2009 - 15:49

I would like to know if there is u function in BAAN Vc, which permit to calculate the due date giving her like parameters, a date and code of payment condition.

Exemple : duedate = calculate.duedate(date, cpay)




Best regards

Change company command in Triton 3.1b
By baanlearner at 3 Mar 2009 - 08:48

Does any one know how to change of company in Triton 3.1b? What is command should i use so that i will get the dialog box for change company.

Thanks in advance.

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

©2001-2017 - -