Report Designer

Report designer_Optimum

How to customize report with user defined field
SCENARIO: How to customize the Sales Invoice Register report to display Promotion items only?  STEP 1:  Create new user define field – Promotion  ST...
Tue, 8 Sep, 2020 at 3:45 PM
Customize Payment Voucher(PV) to sort the payment details by document number
The below is an example on to sort payment details by Doc No in the Payment Voucher.  1. Go to the properties of payment details by click the small arro...
Tue, 8 Sep, 2020 at 3:49 PM
Set Page break per Group / GL Account into Report format
**Example: General Ledger Report 1. Go to Report > GL Report > Report > General Ledger 2. Select Home > Design 3. Highlight the format y...
Tue, 8 Sep, 2020 at 2:38 PM
How to display 0.00 or Blank in report format when the item do not have unit price?
Scenario 1: How to set report format to show 0.00 when the unit price is blank? Refer the below transaction_ 1. Go to Task > Design > click on t...
Fri, 17 Mar, 2023 at 4:14 PM
How to pull out project description for Sales invoices
To understand what is Header Project and Item Project, please refer picture below: To understand where to get this two column from report designer. S...
Tue, 6 Oct, 2020 at 3:25 PM
Outstanding Delivery Order Report prompted error
Outstanding Delivery Order Report prompted error  Exception occurs while assigning the 'XpandDetailView, ID:ReportFilterContainer_DetailView' view ...
Wed, 14 Oct, 2020 at 10:32 AM
MISSING FOREIGN CHARACTERS WHEN EXPORTING TO PDF
1. Create a SINV 2. Add a stock, input the description in Chinese characters 3. Save and preview the transaction 4. Notice that the description is stil...
Wed, 14 Oct, 2020 at 2:50 PM
Optimum- Unable to scan barcode
In the event where your barcode scanner is not able to scan the barcode printed from QNE Optimum, it may be due to the resolution of the barcode printer i.e...
Wed, 14 Oct, 2020 at 10:27 AM
Export Sales Invoice format from Database A and import to Database B
How to export Sales Invoice format from Database A and import to Database B.  [Export]  GOTO Database A  1. Sales  2. Sales Invoice  3. Task  4....
Thu, 15 Oct, 2020 at 3:26 PM
How to create a Report in A4 Half Page Size
This document demonstrates how to create a A4 half page size report. Choose and open a report type from the system. For example Journal Voucher.  1. In ...
Wed, 14 Oct, 2020 at 3:09 PM