while using pic purchase invoice corrections,fc gets updated knowked off correctly but hc remains as it is. result appearing in open entry in hc, though no fc balance to support it.

• shankar's blog

In LN ''The estimated materials" is frozen when the Production orders becomes 'Active' status and does not allow any items to add or delete in this status.

Our requirement is we should be able to add or delete some items in Estimated materials of any Production orders in 'Active' status also.Where we have to set the Parameters to enable this option.

Request the manufacturing consultants to give the solution for this.

regards

Ramaswamy

Baan board member

• Ramaswamy's blog
• 2 comments

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.

• Hitesh Shah's blog
• Read more

Can anyone provide me a manual as to how to use GTM in Baan 4 c4

• Shahed's blog
• 3 comments

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  

• sukhosla's blog

We create, in a report script files with code like below:

        IF code.login = "davenon" THEN
  idfac = seq.open(FICFACDV,"w")
 ELSE
  idfac = seq.open(FICFAC,"w")
        endif
 IF idfac < 1 THEN
  |*Ouverture rapport impossible
  mess("spsls4404055.1",1,FICFAC)
 endif

and write with :

  mntbrut  = sprintf$("%@9999999,99@",( -1 * transport.forfait))
  enrcpt = "VTE" & CSV
   & dat6factur & CSV & nopiece & CSV
   & tdsls045.ttyp & SLASH & nofactur & CSV
   & "708" & nucompte708.SAGE & CSV
   & "" & CSV
         & facturavoir & nofactur & " " & raisocpt & CSV
   & "" & CSV
   & "" & CSV
   & mntbrut & CSV
   & mntbrut & CSV
   & "0,00"
         retour = seq.puts(enrcpt,idcpt)

Now , we are using in Windows and SQL server environnement. The files created with this code are in format Unix and we need to convert  them in Windows Format.

How can we obtain files in windows format ?

Thanks to all. I'm sure to obtain a good respons by you 

Daniel VENON .

• davenon's blog
• 2 comments

In new site (www.infor365.com) where can i get activation key for demo license.

 SAURIN

• saurin710's blog
• 1 comment

How to find database name & server name from Baan IV Tools session. Please help me.

Regards,

Arumugam

• arumugam2505's blog
• 2 comments

Dear all,

 I have a problem with the reservation of parent item vs. child (sub item).

Out of an article we make other items our selves. Our database is Dutch, but I made some screen shots and attached them.

Problem is that if we sell a sub article (child) it shows the reserved quantity.

In my oppinion it should reserve stock on the above laying part (parent) as well.

Only in that case I know how many pieces of parent parts I have to buy.

Is it possible to change something in Baan to let it reserve automatically on parent item?

Thanks,

Jeroen

• JJansen75's blog
• 1 attachment

Does anybody have and good solutions for satisfying SOX audit of object changes in Baan 5c?  There are no automated tools to track and report what objects have been changed and by whom.

• lwatson's blog