{"id":14015,"date":"2018-05-08T07:59:53","date_gmt":"2018-05-08T07:59:53","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=14015"},"modified":"2018-05-08T15:56:53","modified_gmt":"2018-05-08T15:56:53","slug":"9-1-4-custom-reporting-tags-for-v5","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/9-1-4-custom-reporting-tags-for-v5\/","title":{"rendered":"9.1.4. Custom Reporting Tags for V5"},"content":{"rendered":"
\n

Here are new custom report tags implemented for V5<\/p>\n<\/div>\n

REPORT ENTITY DETAILS<\/h2>\n
\n

Reports details for Entities<\/p>\n\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
E.Id<\/td>\nEntity Id<\/td>\n<\/tr>\n
E.EntityTypeId<\/td>\nEntity Type Id<\/td>\n<\/tr>\n
E.Type<\/td>\nEntity Type Name<\/td>\n<\/tr>\n
E.AccountId<\/td>\nAccount Id<\/td>\n<\/tr>\n
E.Balance<\/td>\nEntity Balance<\/td>\n<\/tr>\n
EC.<custom field><\/td>\nCustom field value for <custom field><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

REPORT ENTITY DETAIL<\/h2>\n
\n

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.<\/p>\n<\/div>\n

REPORT MENU ITEM DETAILS<\/h2>\n
\n

Reports menu items.<\/p>\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
M.Id<\/td>\nMenu Item Id<\/td>\n<\/tr>\n
M.Name<\/td>\nMenu Item Name<\/td>\n<\/tr>\n
M.GroupCode<\/td>\nGroup Code<\/td>\n<\/tr>\n
M.Barcode<\/td>\nBarcode<\/td>\n<\/tr>\n
M.Tag<\/td>\nTag<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
\n

REPORT ORDER TAG DETAILS<\/h2>\n
\n

Reports details for order tags.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
T.Name<\/td>\nOrder Tag Name<\/td>\n<\/tr>\n
T.Value<\/td>\nOrder Tag Value<\/td>\n<\/tr>\n
T.Qty<\/td>\nOrder tag quantity<\/td>\n<\/tr>\n
T.Price<\/td>\nOrder tag Price<\/td>\n<\/tr>\n
T.Description<\/td>\nOrder tag description<\/td>\n<\/tr>\n
O.<field name><\/td>\nOrder reference<\/td>\n<\/tr>\n
T.<field name><\/td>\nTicket reference<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

REPORT MENU ITEM TAG DETAILS<\/h2>\n
\n

Reports menu item’s custom tags.<\/p>\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
T.Name<\/td>\nMenu Item Tag Name<\/td>\n<\/tr>\n
T.Value<\/td>\nMenu Item Tag Value<\/td>\n<\/tr>\n
M.<field name><\/td>\nMenu Item reference<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

REPORT TICKET LOG DETAILS<\/h2>\n
\n

Reports ticket logs.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
L.LogDate<\/td>\nLog Date<\/td>\n<\/tr>\n
L.LogTime<\/td>\nLog Time<\/td>\n<\/tr>\n
L.Category<\/td>\nLog Category<\/td>\n<\/tr>\n
L.UserName<\/td>\nUser Name<\/td>\n<\/tr>\n
L.Log<\/td>\nLog<\/td>\n<\/tr>\n
L.TicketNo<\/td>\nTicket Number<\/td>\n<\/tr>\n
T.<field name><\/td>\nTicket reference<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

REPORT TASK DETAILS<\/h2>\n
\n

Reports task details.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
T.Name<\/td>\nTask name<\/td>\n<\/tr>\n
T.TaskType<\/td>\nTask type name<\/td>\n<\/tr>\n
T.StartDate<\/td>\nTask start date<\/td>\n<\/tr>\n
T.StartTime<\/td>\nTask start time<\/td>\n<\/tr>\n
T.EndDate<\/td>\nTask end date<\/td>\n<\/tr>\n
T.EndTime<\/td>\nTask end time<\/td>\n<\/tr>\n
T.Duration<\/td>\nTask duration<\/td>\n<\/tr>\n
T.ContentText<\/td>\nTask Content<\/td>\n<\/tr>\n
T.Completed<\/td>\nIs task completed<\/td>\n<\/tr>\n
TSC.<custom field><\/td>\nCustom Field Value<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

REPORT INVENTORY TRANSACTION DETAILS<\/h2>\n
\n

Lists inventory transactions.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
T.TransactionType<\/td>\nTransaction Type Name<\/td>\n<\/tr>\n
T.Name<\/td>\nTransaction Name<\/td>\n<\/tr>\n
T.Date<\/td>\nTransaction Date<\/td>\n<\/tr>\n
T.Time<\/td>\nTransaction Time<\/td>\n<\/tr>\n
T.Source<\/td>\nSource Warehouse Name<\/td>\n<\/tr>\n
T.Target<\/td>\nTarget Warehouse Name<\/td>\n<\/tr>\n
T.ItemGroup<\/td>\nInventory Item group<\/td>\n<\/tr>\n
T.AccountName<\/td>\nTransaction’s Account Name<\/td>\n<\/tr>\n
T.Unit<\/td>\nUnit Name<\/td>\n<\/tr>\n
T.Multiplier<\/td>\nMultiplier Amount<\/td>\n<\/tr>\n
T.Quantity<\/td>\nQuantity<\/td>\n<\/tr>\n
T.TotalPrice<\/td>\nTotal Price<\/td>\n<\/tr>\n
T.Price<\/td>\nPrice<\/td>\n<\/tr>\n
D.<field name><\/td>\nDocument Reference<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

REPORT CONSUMPTION DETAILS<\/h2>\n
\n

Reports Inventory Consumptions.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
C.StartDate<\/td>\nConsumption period start<\/td>\n<\/tr>\n
C.EndDate<\/td>\nConsumption period end<\/td>\n<\/tr>\n
C.Name<\/td>\nConsumption period name<\/td>\n<\/tr>\n
C.Unit<\/td>\nConsumption Item Unit<\/td>\n<\/tr>\n
C.Inventory<\/td>\nConsumption Item Inventory<\/td>\n<\/tr>\n
C.Prediction<\/td>\nConsumption Item Inventory Prediction<\/td>\n<\/tr>\n
C.Warehouse<\/td>\nConsumption Item Warehouse<\/td>\n<\/tr>\n
C.InStock<\/td>\nIn Stock<\/td>\n<\/tr>\n
C.Added<\/td>\nAdded to inventory<\/td>\n<\/tr>\n
C.Removed<\/td>\nRemoved from inventory<\/td>\n<\/tr>\n
C.Consumption<\/td>\nConsumption<\/td>\n<\/tr>\n
C.Cost<\/td>\nCost<\/td>\n<\/tr>\n
C.PhysicalInventory<\/td>\nPhysical inventory<\/td>\n<\/tr>\n
PC.<field name><\/td>\nPeriodic Consumtion Item reference<\/td>\n<\/tr>\n
WC.<field name><\/td>\nConsumtion reference<\/td>\n<\/tr>\n
I.<field name><\/td>\nInventory Item reference<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

REPORT COST DETAILS<\/h2>\n
\n

Reports Product Cost Details.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
C.StartDate<\/td>\nCost period start<\/td>\n<\/tr>\n
C.EndDate<\/td>\nCost period end<\/td>\n<\/tr>\n
C.Name<\/td>\nMenu Item Name<\/td>\n<\/tr>\n
C.PortionName<\/td>\nPortion Name<\/td>\n<\/tr>\n
C.Warehouse<\/td>\nConsumption Warehouse<\/td>\n<\/tr>\n
C.Quantity<\/td>\nQuantity<\/td>\n<\/tr>\n
C.CostPrediction<\/td>\nCost Prediction<\/td>\n<\/tr>\n
C.Cost<\/td>\nCost<\/td>\n<\/tr>\n
C.AvgPrice<\/td>\nAverage Price<\/td>\n<\/tr>\n
M.<field name><\/td>\nMenu Item Reference<\/td>\n<\/tr>\n
PC.<field name><\/td>\nPeriodic Consumption Reference<\/td>\n<\/tr>\n
WC.<field name><\/td>\nWarehouse Consumption Reference<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-14015","post","type-post","status-publish","format-standard","hentry","category-reports"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=14015"}],"version-history":[{"count":4,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14015\/revisions"}],"predecessor-version":[{"id":14022,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/14015\/revisions\/14022"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=14015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=14015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=14015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}