UBSA1.22 : Access UBS (Accounting): How to Add 2nd Description in Ledger

UBSA1.22 : Access UBS (Accounting): How to Add 2nd Description in Ledger

Description

How to include 2nd description in Print Ledger Report when exporting to MS Excel. 

Environment

Access UBS (Accounting) Microsoft Excel Microsoft Windows OS 10

Solution

  1. Go to Reports, Print Ledger Click OK, Click Excel at the Ledger 
  2. Select the Export to Excel Template
  3. Right-click at the Exit , Click Copy and it will open a new excel template ,  
  4. Edit the format to follow the specifications from the image below: 
    1. Set Report Layout, Add 1 from 10 to 11 
    2. Set Report Header, Add the new table field name (eg: Desp (2)) 
    3. Set Body Field, Add body field from table name (eg:despa)
    4. Set Body Field Type, Add C
    5. Set Group Total, Do you want to total up the numerical value in the table Yes / No. (Y/N) - Add F
    6. Set Column Width, Set line spacing for information to appear in excel - Add 30
    7. SQL Statement, (eg: the table alias c.despa) 
  5. This is set in left join glpost c on (x.batchno=c.batchno and x.tranno=c.tranno) by tables GLPOST and Excelfile X, you are able to call the data with the primary table from excel_initfile to initfile. 
  6. Click Export after the editing to see the results in excel. 
image.png

--Source from Access UBS --