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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

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

 

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.


Export Users and their athorization in a CSV file
By bonmarit at 24 Feb 2009 - 17:24

Hello

I would to know if it's possible ( and how )  to export  BAAN Users data ( and profile associated to ) in  a CSV file  

Even better. is it possible to have a sample of these files ?

Thank you

Mario


extending financial period to 15 months
By novina888 at 17 Jun 2010 - 00:17

Hi, iam new in Baan and have to extend next financial year to 15 months then change them back to normal 12 months thereafter.

How do i do this?  is it as simple as changing the period from 12 (now) to 15 then to 12 again?

Thanks

Novina


fatal error 512 in insert on session personalizations
By gruvi_navy at 14 Mar 2017 - 05:40

Hi All, 

while entry session personalizations i found error "Fatal error 512 in insert". please help my problem.

thanks 


fatal error while updating packing slip wrongly entered by user
By sandeeprana302 at 13 Jun 2014 - 05:44

HI all  ,

 i am getting fatal error while updating table tfacp245,

 User by mistake entred the wrong paking slip no (in purchase receipt )

 have to made correction(manul table level ) on all table related to whinh

 but while updating the  finace table tfacp245 i am geting fatal error 605

 

any one have idea ?

 

 

regards
sandeep 


fatal error- Error 16313 (Catalog related error) cannot continue in ottstpstdlib when lgging on
By rlochan at 20 May 2015 - 12:14

(Catalog related error) cannot continue in ottstpstdlib when lgging on


Fixed Assets Depriciation Issue
By sukhosla at 12 Jan 2010 - 16:49

We found our fixed assets calculation is not correct. We have entered initial data upto period 2009/12. System is calculating deprication for those assets too where book value is 1 or those are fully depricated before in previous year/period or going to be fully depriciated in next few more months. Our depreciation calculation method is "Fixed % of base value" with First and Last use date.

Can any one help us ,how to control this. We need following:

1. system should not calculate for those assets which are fully depricated and having book value only 1.

2. system should calculate depreciation for those assets which are going to be fully depriciated in next few months with their respective months of depriciaiton % not with full year amount.

3. Remaining other assets should have correct calculation in future years too.  

Awaiting your valueable reply as earliest..

Thanks,

Sushi  

 


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

 


freelacing
By manorit at 14 Feb 2011 - 19:34
I am available for freelancing.Please drop me an email at monicabhosale@gmail.com

FTP Issue.
By sachinbs007 at 27 Feb 2009 - 08:57

FTP - from One server Location(Windows) to other server location of different platform (Unix)

  

Hi

 

I wanted to do the FTP of an flat file from Baan server to other ERP server.

Baan server is in Windows and Other ERP server is in Unix.

I have written an code for this which is given below.

 

function ftp.ascii.file()

{

            ret.code = app_start("cmd /c e:\int\export\Item\GEPS_CS_TASK_LINE.bat", "", "", "", "")

            app_status(ret.code)

            suspend(3000)

 

            if ret.code > 0 then

                        message("Success")

                        |process.error = seq.unlink(filepath)

            else

                        message("failed")

            endif

}

  

At the given path I have an “ .bat” file which is pointing to an text file in which all the information related to server is saved from password to the path were to move the file and from were.

“.bat” file is getting trigger but the file is not getting transfer ,can any one tell were could be the issue in Code.



All times are GMT +2. The time now is 05:25.


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