UBS Accounting Software » Report

ID #1172

Report Column

Description

The solution below shows  the  way to view Report Column in Check Transactions.

 

Solution

 

1.

In Country Setting, check Print Report Row.

 

2.

Set the  report  column number: go to

General >General Ledger A/C Maintenance 

OR

 

General  > Print Chart of Accounts, locate the  account, double click on it and key in the

column number at Report Row (1I2)..Column (in rightmost column), click Save.

3.    Then go to Reports  >  More Report (1)  >  Check Transactions, specify the  column numbers at Report Column From and Report Column To, click on Ok,  Preview. The transactions listing will be in columnar form.

4.    The standard report  can only check 3 columns. Customization needed to add more  column.

5.    Step 1. Click on Preview, File, Save As, click on Save to save  the  report  file in data directory.

6.    Step 2. Right click on Exit button, select report  file then  click Open.

7.    Step 3. Right click on Report  Expression: lg(”column 3”), copy and paste into Page Header section then  rename to column 4, at Print When expression rename to column_t >= 4, click OK. Another Report  Expression: tran(glpost.debitamt- glpost.creditamt,“@z “ + p4) also need  to copy and paste into Detail section, then  at

Print When expression rename to column_t >= 4 .and.  gldata.rpt_col=4 and click OK, then

Save the  report  format.

8.    Preview the  report.

 

 


Tags: Report Column

Related entries:

Last update: 2010-11-10 06:46
Author: Noor Diyana
Revision: 1.0

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry