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

 
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.

 

Creating a PDF INVOICE to disk with Invoice number in the file name for archiving purposes.
By genehunter at 14 Jul 2009 - 16:32

I have been working on a way to archive invoices and to automatically label the file name with the invoice number. This is the code I have so far. It uses Ghost script pdf converter and it seems to work. If you have questions send me an email at ghunter@immucor.com

 

This is the print driver. the code near the middle (findstr) is what finds the string with the INVOICE number and labels the pdf file. 

 

gswin32c -q -dNOPAUSE -dBATCH -sPAPERSIZE=a4 -sDEVICE=pdfwrite -sOutputFile=e:\baan\tmp\archive_pdf.pdf e:\baan\tmp\archive_pdf.txt

copy e:\baan\tmp\archive_pdf.pdf e:\archive_invoice\archive_pdf.pdf
copy e:\baan\tmp\archive_pdf.txt e:\archive_invoice\archive_pdf.txt
rem -- ren e:\archive_invoice\archive_pdf.pdf invoice%date:~4,2%%date:~7,2%%date:~10,4%%time:~1,1%h%time:~3,2%m%time:~6,2%s%.pdf
findstr /C:"45 444" archive_pdf.txt >e:\archive_invoice\results.txt
set /P test=<e:\archive_invoice\results.txt
ren e:\archive_invoice\archive_pdf.pdf invoice-%test:~49,3%-%test:~72,8%.pdf
del e:\archive_invoice\results.txt

:end


intrigation purchase LOT result
By Diwakar Nayak at 13 Jul 2009 - 11:48

how to get the financial entry of trasaction origin purchase and financial transaction lot result in intrigation where there is a variance between actual cost and std cost of the purchased lot item.


Scheduling and drafting email for Baan Report / Excel Analysis
By Hitesh Shah at 28 May 2009 - 15:05

Scheduling emails of Analyses and Reports in Baan

 

It’s very important to be able to schedule the reports / analyses in Baan and email the same to the user in a meaningfully crafted message. This enables system to PUSH the intelligence and rather than requiring users to PULL the same.

Scheduling for Unequal periods and numeric periods

In Baan, Job management is the instrument of task / process scheduling. The same can be useful for scheduling report also. However there are following problems.


Delete Millions Of Records with Less Time and Performance
By bhuvaneshwari at 28 May 2009 - 06:57

Hi,

We have Millions of Baan records . And now we need to delete all the records.

But it takes very long time to do the same.

Can anyone suggest how to delete the records with less time.

 

Thanks,

Bhuman 


CORRUPT INVENTORY
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

Regards,

 

 

 


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

Hi

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

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.

 


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???  

 Thanks



All times are GMT +2. The time now is 20:44.


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