Wiki

SAP BUSINESS ONE

None Defined

Columns in SAP Annual Financial Reports are not Displayed

You execute SAP Financial Statements such as Trial Balance or P&L with annual selection. The displayed report is missing columns.

You execute SAP Financial Statements such as Trial Balance or P&L with annual selection. When you display report, some of the columns (or months) are missing from screen. The report prints okay displaying all months. 1. Find the formid, itemid of the problematic report. a) Open SBO. b) Enable the System information (From SBO Menu, select View → System Information) c) Put the mouse on any field of the problematic report, find the formid (The number after `Form=`) and the itemid(The number after `Item=`) on the status bar at the left bottom of SBO. d) Record this formid and itemid. 2. Close SBO. Make sure no SBO clients are connected to the server. 3. Open SQL Analyzer, run the update query below. Before running the query, do please replace: /!Formid found in Step 1!/ to the formid found in step 1. /!Itemid found in Step 1!/ to the itemid found in step 1. /!Problematic User Code!/ to the user code of problematic user. –begin –delete all the user settings delete cprf where formid=`/!Formid found in Step 1!/` – for this form and itemid=`/!Itemid found in Step 1!/` – and this document and usersign =` `– User id with issue

Solution

25 Jun 2014