Quick Jump Menu
Advanced Search Search the Knowledgebase
Categories
There are no subcategories in this category.
41 Customize sub total for each page and grand total on last page | 每页显示小计,尾页显示总计

Scenario: Follow the steps to customize sub total for each page and grand total on last page. Solution: Go to report designer. Add a field with the expresssion ictran.amt for subtotal. Double click the field, click “Calculations”, set reset to "End of…

42 Customize the invoice in order to show Agent Description in the header. | 在发票显示代理人说明 Featured

Scenario: The solution below shows the step to customize the Invoice in order to show Agent Description in the header. Solution: Go to [Housekeeping > Run Setup > General Setup], select Transaction tab. Tick the option "With bill agent" at Add Header…

43 Different format of Serial Number. | 序列号显示模式 Featured

Scenario: The solution below shows the different format of Serial Number. Solution: Go to Report Designer, double click on a field with expression Fserialno(1,",") and then edit to Fserialno(2,",") or Fserialno(3,","). 方案: 以下说明如何更换序列号显示模式。…

44 Display 1st, 2nd and 3rd level discount amount at footer of an Invoice bill | 在发票页尾显示第一,第二和第三折扣数额

Scenario: The solution below shows the step to display 1st, 2nd and 3rd level discount amount at footer of an Invoice bill. Solution: Open report designer for the report “icbil#02”, go to [Report > Variables] and insert 3 variables: 2. Go to Report…

45 Display footer discount with 2 decimals. | 页尾折扣显现双小数点 Featured

Scenario: This solution below shows the steps to display footer discount with 2 decimals. Solution: Click "Print" for the Invoice that have footer discount. Click "Preview" and then save the report, press "Esc". Click "Setting" and double click the file that…

46 Error: Invalid SQL Statement on customize a Custom Report.

Scenario: Error warns while click on ‘Save’ after selected and key in the field. Solution: The custom report behaves as similar to a query. Therefore, it must not consist of the symbol of apostrophe ( ' ). Rename the Report Name by remove the apostrophe…