Assignment – Baan Report

1. Generate a report based on the customer table. The report should print a report of type1. Generate another report of type 2 on the same table. Attach the report to the same session in the group 1. Execute the session, enter parameters. Note what happens.

2. For the same session as in case 1, attach the report to group 2, delete it from group 1. Check if the report is accessible.

3. Check the help for the pre-defined variable ‘REPORTGRP’. For the above session make the group 2 as the default group, note down which report gets executed.

4. Generate a session for printing a report on sales orders. The sales orders should get printed by customers. The name of the customer should appear only once for the group. For each order, the order date should get printed only once. All the details for the order should get printed in the order of line numbers. At the end of each order, the sum of line amounts should get printed. For each customer, the number of orders placed should be printed. Note the name of the session.

5. In the above session, get the cumulative amount for each order for a customer(this means for first orders for a customer, this amount will be total amount for this order, for the second order, this should be the current amount + prev orders total amount and so on). Is it possible to do it using the aggregate functions?

6. Generate a report based on sales order lines table. Maintain a sort field item with sort mode ‘ascending’. Maintain a after.field layout for the field and print the item code, description and the total amount for the item on this layout. Make the detail layout invisible using the output expression. Note the effect on the report. Delete the detail layout. Check the effect on the report.

7. Generate a session to print report based on order header table. It should have two reports attached: 1) for printing the orders by customer, 2) for printing the orders by order number. Note the name of the session.

8. Read the help for the functions ‘brp.*’, that deal with printing reports. Generate a session to print a report of sales orders. It should generate two reports simultaneously. One report should print the report type 3 with customer as group field, and the other report should print a summary report that shows summary of order amount by customer. Note the name of the session.

9. Observe the effect of the margins, repeat expression, page length using a simple report.

10. Generate a report based on customer table. The report should print the code, name, city and it should print the phone number or a string “No Phone” if the number is not maintained. The report should print “*****” at the end of the record if it is a ‘Special Customer’. Also, for the special customer, the additional text should get printed starting from the next line. Note the name of the session.

11. Generate a report to print labels for customers with name, address, city and pin. Three labels for a customer should get printed. Note the name of the session.


Baan Developer Position – Pune, INDIA

Job Description

Special Experience: 1.  Analysis and development of solutions in Infor (BaaN)
2.  Identify potential needs for optimizing processes
3. Development of new business processes
4. Development and implementation of a business Process Management (BPM) system
5. Implementation of Software projects
Job Description: 1. University degree in computer science
2. Extensive experience and knowledge of programming in the ERP environment, particularly with the software solution Baan IV and Infor LN (with focus on financial module)
3. Safe handling and knowledge of common ERP and Office software
4. English language skills, written and spoken
5. Good understanding of business processes and technical production
6. Independent and structured way of working
Yrs of Experience: 6-8 yrs

Company is at Daund / 30 to 40 km away from Hadapsar …

Transport facility will be given/ 5 days working

Job Timing – 8:30 AM to 5 PM

If interested please contact Sonal Sharma from Neptune Consultants. 020-41463902

Assignment – Baan SQL

1. Assume the Suppliers (tccom020) and Purchase Order tables (tdpur040). Make the reference ‘Not mandatory’ from Purchase Order to Supplier Master table. Insert the following data from general table maintenance. Insert three suppliers in the supplier table. Insert orders for one of the suppliers. Insert few orders with supplier code that does not exist in supplier table. Write a query to fetch the records from orders and supplier using ‘refers’ and ‘referred by’. For this query note the effect of various reference modes.


2. Write a simple select statement. Display a message in the sections selectdo, selectempty, selecteos. Execute the query for a range of values for the key fields so that:

  • · No records are selected
  • · One record is selected
  • · More that one records are selected

Note the messages that are displayed, note the sequence of execution of the sections.


3. For the case in assignment 1, how can one get a list of orders with suppliers not maintained in supplier table using:

  • · Refers
  • · Sub-queries


4. For the case in assignment 1, how can one get a list of suppliers with no orders using:

  • · Refers
  • · Sub-queries
  • · Nested selects


5. Consider the order details table, the requirement is that only first five largest orders for an item should be listed. Also, note that more than one detail for an item can be present. How can this be done?  Using group functions, using ‘as set with’.

Baan Secrets

There are various hidden sessions with Baan Software that is not documented anywhere, and those sessions aren’t present in the Menu Bar of Baan. These sessions would help the developer’s to play with and incorporated in to few challenging assignments in future.

Enjoy !!!

1) Font Selection Session – Session Code (ttdskfs)


2) Color Selector Session – Session Code (ttdskcs)


3) Calender Session – Session Code (ttstpcalendar)


4) Run a Shell – ttstpshell