Month: May 2018
5.1.10.a. SambaPOS Accounting System
Credit and debit accounts are technically the same thing in SambaPOS. If you want a credit account, you make sure it always has a negative balance. If you want a debit account, you make sure it always has a positive balance. So, accounts with a balance between brackets are credit accounts and the other accounts […]Read More
9.1.1. Custom Report Templates
Main Menu > Manage > Reports > Add Report > Add this Custom Report Template inside report. Custom Report 1 [Table 1:1,1] >Sub Row 1| Cell 1|Cell 2 Cell 3|Cell 4 This is what each template line displays. Formatting Tables When you add a Table Section all lines added under that section will appear as a table […]Read More
9.1.2. Creating Custom Reports with SQL
Adding SQL Scripts You can display result of an SQL Script in custom reports. If SQL Scripts returns a single value you can use it as a cell value. If it returns multiple values that will be formatted as a table row. In other words SQL result will be converted to a list where each […]Read More
9.1.3. Custom Reporting Tags
It is possible to prepare any type of reports with SQL and display results as a Custom Report. Alternatively you can use Custom Report Tags to prepare reports. If you need more information about preparing a custom report you can review tutorial below. http://forum.sambapos.com/t/new-how-to-use-custom-reports-module-1-0/2142 Introduction Basically there are four types of tags. DETAILS TAGS These […]Read More
9.1.4. Custom Reporting Tags for V5
Here are new custom report tags implemented for V5 REPORT ENTITY DETAILS Reports details for Entities Field Description E.Id Entity Id E.EntityTypeId Entity Type Id E.Type Entity Type Name E.AccountId Account Id E.Balance Entity Balance EC.<custom field> Custom field value for <custom field> REPORT ENTITY DETAIL Does same thing with REPORT ENTITY DETAILS but this […]Read More
9.1.5. Creating Accounting Reports with Custom Reporting Tags
Creating Accounting Reports with Custom Reporting Tags Using Custom Report Tags Custom reports contain some tags useful for preparing reports easily. These tags work same as Printer Template Tags but the difference is these tags will display values from selected date range, or date range from active work period if used out of report module. […]Read More
9.1.6. Custom Report Pivot Table Views
Pivot tables are useful to create different views of data easily for better analyzing data. Preparing a Sample Report You can create a simple Orders report by using this custom report template. [Orders:1,2,1,1] >Item Group|Item|Quantity|Total {REPORT ORDER DETAILS:O.ItemGroup,O.MenuItemName,O.Quantity,O.TotalPrice} This report will list all orders we’ve placed inside selected date range. Converting Report to a Pivot Table Pivot […]Read More
9.1.7. Custom Report Table Views
Introduction You can convert a Custom Report to a Table View for more sorting, filtering, grouping or data analyzing features. Adding # char in front of a table name converts report to a table. This is a simple custom report that lists tickets in date range. In here it is used this Custom Report Template to generate that report. [Tickets:1,1,1,1] >Ticket […]Read More
9.1.8. Custom Report Viewer Widget
You can add custom reports inside a Custom Entity Screen by using a Custom Report Viewer Widget. After adding widget in custom entity screen click Settings context menu item to edit settings. You can select a custom report from Report Name combo box. Setting a Border for report or changing Zoom Ratio is also possible. For using Setting Mappings feature you can review Custom Report Widget […]Read More
9.1.9. Custom Report Filtering and Grouping
Basic Use This is the basic structure of a custom report. This report lists order lines of tickets. Adding quantity column to report; Adding quantity summary; Filtering You can filter items by Menu Item Group. You should use (MG=x) expression for that. This report will display only Breakfast items. Another report will be added to […]Read More