Products

b2Win Frequently Asked Questions

A standard Baan / Infor ERP Ln report will have the following:

  • The header appears once in every page.
  • The header has a dash line under it and above it.
  • The report should not include extra dash lines in other places (except the header)
  • No sub headers
  • Pipe delimited
  • No missing pipes between the columns

Example:

If you were trying to use the configure option to start "Report Customizer" and received this message (or a similar one).



You should install/update your components by clicking on "update components" in B2Win's menu 



Click yes to install. 

In step3 of B2Win's Report Customizer you can rearrange the column's order, choose your own sorting settings, choose a template which the data will be poured to, and preview your final data.



10 global templates can be saved under $BSE/B2Win6/templates so that all the users can us it. These are the default templates, and are for coloring only.

You can also get any template from the client PC by going to File-> get Local Template and this also will be saved in the user's configuration. B2Win takes from this template all your Excel settings like data types, column's width, freeze panes, conditional formatting, graphs and everything that you save in Excel. You can add columns to the template that are built from a formula that depends on other reports columns.

Ms-Excel and Ms-Word allow you to write Macros with Visual Basic. You can do that with Tools/Macro/Visual Basic Editor. Sample macros are provided with the standard package like asisconv.xls (Excel As-is Macro) and B2Win_txt.dot (Word ASCII Macro). 

These macros read file report.txt (The text file with report output coming from Baan) and run manipulations to get the desired output result. These "manipulations" may include templates, bookmarks, watermarks, different formatting and a lot more.

The following is an example of what can be done with templates and bookmarks:

 

After running the macro

 

Macro inside this template

The B2Word macro merged the quotation data coming from Baan /Infor ERP Ln into the Ms-Word template to produce a professional look of a quotation that can be edited in Ms-Word before sending it to the customer.

Once you write your own macro, you must save it in $BSE/B2Win6/macrox (for Excel) $BSE/B2Win6/macrow (for word) under the name <report code>.xls for Excel and <report code>.dot for Word (tcmcs041001000.xls and tcmcs041001000.dot are two samples of a customized macro provided with the package).

Every time B2Win is run and the custom macro is chosen, your customized macro will be copied to the B2Win local directory and will be activated. If you wish to change the macro at any point in the future, all you have to do is to update the macro in $BSE/B2Win6/macrox (for Excel) $BSE/B2Win6/macrow (for word) and the most current version of the macro will be used the next time one of the users picks the "Custom" option.

Knowledge in Visual Basic is required in order to write these macros. If you need help writing a customized macros, contact the NAZDAQ services team by filling out the "Technical Assistance Request" form:

http://nazdaq-it.com/assistance.php 

If you like to produce a report with a different look than the one automatically produced by b2Win, you can assign a customized macro for a specific report. This option is activated in b2Excel and b2Word by pressing on the "User Defined" option.

B2Excel tries to "guess" the data type of each column it is converting to Excel. Sometimes, a column is converted to Excel in a way that does not match its real data type.

As an example, an item number with leading zeros like 0000146700 will be converted to the number 146700 in Excel. In order to avoid this, the user has the option to define a data type for specific columns; if you want Excel to force items to be converted as alphanumeric fields, the B2Win system administrator should define data types using the B2Win Report Customizer.

This is an alert that appears when report with an irregular header is printed to b2Win. Use the "Configure" option to reconfigure the report.

Our dumps are delivered with language English (2). In order to let the software work in your own language, you have to copy the forms to your own language.

We like the ongoing development and the excellent customer service
Fata S.p.A.
NAZDAQ's add-on utilities for Baan have proved to be indispensable software tools
IT Director, Grindmaster
We are very satisfied with the products and reliability of NAZDAQ
Christoph Kern, MM Packaging Europe GmbH
We could reduce the cost of Baan programming
Martin Cajoos, Kistler
Our users find Baan Mail Merge to be fast, effective and easy to use
Barbara Bailey, JVK
NAZDAQ tools are simple to configure and use, and are inexpensive
Venu Cherukuri, Buckman Laboratories
It is a pleasure to have a supplier like you
Joseba Iribar, Groupo Gusacor
NAZDAQ have been producing useful tools at value for money prices for 10 years
Ed Hubbard, Automated Packaging Systems
The B2Win software is excellent value for our money
Peter Fiebeg, Maschbinenbau Kitz
Will upgrade our Baan IVc4 environment to ERP LN and our NAZDAQ's products will make that transition with us.
Jim Pogue,DPT Laboratories