Book Image

ADempiere 3.6 Cookbook

Book Image

ADempiere 3.6 Cookbook

Overview of this book

Table of Contents (16 chapters)
ADempiere 3.6 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

Configuring a new print format for a window


This recipe describes how we can configure a print format for a window where we can display information from different tabs on that window.

How to do it...

  1. 1. Create a view from the different tables, used in the window.

    CREATE VIEW adempiere.c_mom_v AS
    SELECT
    a.*,
    b.item_nbr,b.discussion_desc,b.ad_user_id AS actioned_by,b.c_momstatus_id,
    c.ad_user_id AS participant,c.company,
    d.name AS status
    FROM
    adempiere.c_mom a
    JOIN adempiere.c_mom_discussionline b ON a.c_mom_id=b.c_mom_id
    JOIN adempiere.c_mom_participantsline c ON c.c_mom_id=b.c_mom_id
    JOIN adempiere.c_momstatus d ON b.c_momstatus_id=d.c_momstatus_id;
    
  2. 2. Go to the Table and Column windows and create table and columns from the c_mom_v view, as shown in the following screenshot:

  1. 3. Go to the Menu | System Admin | General Rules | Printing | Print Format window and create a print format for, say, MOM Print Format, as shown in the following screenshot:

  1. 4. Click on the Copy/Create button. When prompted...