SambaPOS

Documentation Website

User Tools

Site Tools


Sidebar

Installation

User interface

Basic concepts

  • Departments
  • Terminals
  • Users & user roles
  • Work periods
  • Tickets & orders
  • The POS menu
    • Products & product categories
    • Menus
    • Recipes
    • Product modifiers

Quick-start: setting up a (very basic) POS configuration

Advanced concepts

Customizing your POS system

Extra

Mobile Client

SambaPOS License

custom_reporting_tags_for_v5

Custom Reporting Tags for V5

Here are new custom report tags implemented for V5

REPORT ENTITY DETAILS

Reports details for Entities.

FieldDescription
E.IdEntity Id
E.EntityTypeIdEntity Type Id
E.TypeEntity Type Name
E.AccountIdAccount Id
E.BalanceEntity Balance
EC.<custom field>Custom field value for <custom field>

REPORT ENTITY DETAIL

Does same thing with REPORT ENTITY DETAILS but this tags returns data for only first entity that matches to expression. Works faster if you want to work with a single entity.

REPORT MENU ITEM DETAILS

Reports menu items.

FieldDescription
M.IdMenu Item Id
M.NameMenu Item Name
M.GroupCodeGroup Code
M.BarcodeBarcode
M.TagTag

REPORT ORDER TAG DETAILS

Reports details for order tags.

FieldDescription
T.NameOrder Tag Name
T.ValueOrder Tag Value
T.QtyOrder tag quantity
T.PriceOrder tag Price
T.DescriptionOrder tag description
O.<field name>Order reference
T.<field name>Ticket reference

REPORT MENU ITEM TAG DETAILS

Reports menu item's custom tags.

FieldDescription
T.NameMenu Item Tag Name
T.ValueMenu Item Tag Value
M.<field name>Menu Item reference

REPORT TICKET LOG DETAILS

Reports ticket logs.

FieldDescription
L.LogDateLog Date
L.LogTimeLog Time
L.CategoryLog Category
L.UserNameUser Name
L.LogLog
L.TicketNoTicket Number
T.<field name>Ticket reference

REPORT TASK DETAILS

Reports task details.

FieldDescription
T.NameTask name
T.TaskTypeTask type name
T.StartDateTask start date
T.StartTimeTask start time
T.EndDateTask end date
T.EndTimeTask end time
T.DurationTask duration
T.ContentTextTask Content
T.CompletedIs task completed
TSC.<custom field>Custom Field Value

REPORT INVENTORY TRANSACTION DETAILS

Lists inventory transactions.

FieldDescription
T.TransactionTypeTransaction Type Name
T.NameTransaction Name
T.DateTransaction Date
T.TimeTransaction Time
T.SourceSource Warehouse Name
T.TargetTarget Warehouse Name
T.ItemGroupInventory Item group
T.AccountNameTransaction's Account Name
T.UnitUnit Name
T.MultiplierMultiplier Amount
T.QuantityQuantity
T.TotalPriceTotal Price
T.PricePrice
D.<field name>Document Reference

REPORT CONSUMPTION DETAILS

Reports Inventory Consumptions.

FieldDescription
C.StartDateConsumption period start
C.EndDateConsumption period end
C.NameConsumption period name
C.UnitConsumption Item Unit
C.InventoryConsumption Item Inventory
C.PredictionConsumption Item Inventory Prediction
C.WarehouseConsumption Item Warehouse
C.InStockIn Stock
C.AddedAdded to inventory
C.RemovedRemoved from inventory
C.ConsumptionConsumption
C.CostCost
C.PhysicalInventoryPhysical inventory
PC.<field name>Periodic Consumtion Item reference
WC.<field name>Consumtion reference
I.<field name>Inventory Item reference

REPORT COST DETAILS

Reports Product Cost Details.

FieldDescription
C.StartDateCost period start
C.EndDateCost period end
C.NameMenu Item Name
C.PortionNamePortion Name
C.WarehouseConsumption Warehouse
C.QuantityQuantity
C.CostPredictionCost Prediction
C.CostCost
C.AvgPriceAverage Price
M.<field name>Menu Item Reference
PC.<field name>Periodic Consumption Reference
WC.<field name>Warehouse Consumption Reference
custom_reporting_tags_for_v5.txt · Last modified: 2016/11/17 14:58 (external edit)