Work Period Report crashing

[na1978]

@emre

I updated to version 4.1.49. SambaPOS crashes when I click Work Period Report. I will PM you the DB.

Many thanks.

---

[General Info]

Application: SambaPOS
Version: 4.1.49
Region: en
DB: SQ
Machine: BAR
User: User2
Date: 8/18/2014
Time: 5:21 PM

User Explanation:

User2 said “”

[Exception Info 1]

Top-level Exception
Type: System.DivideByZeroException
Message: Attempted to divide by zero.
Source: mscorlib
Stack Trace: at System.Decimal.FCallDivide(Decimal& d1, Decimal& d2)
at System.Decimal.op_Division(Decimal d1, Decimal d2)
at Samba.Modules.BasicReports.Reports.EndOfDayReport.EndDayAbstractReportViewModel.GetReport() in c:\Users\Emre\Documents\GitHub\SambaPOS-Gold\Samba.Modules.BasicReports\Reports\EndOfDayReport\EndDayReportViewModel.cs:line 266
at Samba.Presentation.Common.Reports.AbstractReport.<>c__DisplayClass8.b__2(Object param0, DoWorkEventArgs param1)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

---

[Assembly Info]

Samba.Services, Version=1.0.0.0
mscorlib, Version=4.0.0.0
System, Version=4.0.0.0
Microsoft.Practices.Prism, Version=4.0.0.0
WindowsBase, Version=4.0.0.0
Samba.Infrastructure, Version=1.0.0.0
Samba.Infrastructure.Data, Version=1.0.0.0
PresentationFramework, Version=4.0.0.0
System.Xaml, Version=4.0.0.0
Samba.Presentation.Services, Version=1.0.0.0
FluentValidation, Version=3.4.0.0
Samba.Domain, Version=1.0.0.0
DevExpress.Xpf.Grid.v14.1, Version=14.1.5.0
DevExpress.Xpf.Grid.v14.1.Core, Version=14.1.5.0
PresentationCore, Version=4.0.0.0
Stateless, Version=1.0.0.0
System.Core, Version=4.0.0.0
System.Drawing, Version=4.0.0.0
System.Windows.Forms, Version=4.0.0.0
System.ComponentModel.Composition, Version=4.0.0.0
Samba.Localization, Version=1.0.0.0
Microsoft.CSharp, Version=4.0.0.0
Microsoft.Practices.ServiceLocation, Version=1.0.0.0
Samba.Persistance, Version=1.0.0.0
Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0
DevExpress.Xpf.Core.v14.1, Version=14.1.5.0
PropertyTools, Version=2012.4.14.1

---

[System Info]

Operating System
-Microsoft Windows 8.1
–CodeSet = 1252
–CSDVersion =
–CurrentTimeZone = -300
–FreePhysicalMemory = 2623824
–OSArchitecture = 64-bit
–OSLanguage = 1033
–ServicePackMajorVersion = 0
–ServicePackMinorVersion = 0
–Version = 6.3.9600

Machine
-BAR
–Manufacturer = Dell Inc.
–Model = Inspiron One 2020
–TotalPhysicalMemory = 4178911232
–UserName = BAR\User2

---

[emre]

Did you created any Transaction Documents? If so can you review if you have 0 quantity transaction in it?

[emre]

Also can you please PM me a backup zip of your Database ?

[na1978]

I added "Add Settled by Terminal to Work Period Report " you assisted from a couple of days ago. I just PMed the DB.

Not sure where to check if I have 0 quantity.

Thanks

[emre]

There is no transaction exists in this backup. Can you create a new backup?

[emre]

@na1978 I think you are reopening an already settled ticket and void it. When you reopen a ticket you should cancel all payments and also remove ticket tags that we use to track payments.

Sorry for asking that but this is not something expected. Why you are doing it? Is it a trial data?

[na1978]

@emre,

You are correct. I reopened an settled ticket and I void it.

I settled a ticket and re-open it, but I can not remove Payment and Ticket Tags.

I am tagging each ticket payment, such as Cash, Credit Card.

How can I remove Payment and Ticket Tag after I reopen the ticket.

Thanks.

[na1978]

I think, I will remove Ticket Tags, since I now have the open to track payments by Terminal.

But, I still can not remove Payment after ticket is reopened.

[emre]

Re-open Settled Ticket & Cancel Payments

The short version of this originally posted here: Enable More Ticket Actions Module from Samba Market. This module enables Reopen Closed Ticket and Cancel Payments action types. Create two actions for both of these action types. These actions do not have parameters. Create “Display Ticket” action, name it Refresh Ticket. Set TicketId parameter as 0. Create an Automation Command, name it as you wish an place it somewhere suitable. Create a Rule to handle this command and call Actions Reo…

[na1978]

@emre,

Thank you very much for your help today. I think, i will remove this feature because it is easy to make a mistake by our staff.

Best Regards,

[Jesse]

This feature should really be used by you or a trusted manager. I dont think I would ever let my staff use it.

[QMcKay]

@na1978, you can limit the Roles that can use the button easily…

[na1978]

@QMcKay,

Is there a way to automatically remove existing payment before re-opening ticket? Thanks.

[Jesse]

You can tie a command together that removes payment on ticket reopen.

[na1978]

Great. I will play with it today. Thank you @kendash.

[Jesse]

The remove payment should happen after ticket reopen action. It will seem like it happens at same time I you tie them both in to same command button. Just be sure cancel payment happens after the reopen ticket action in your rule.

[QMcKay]

The Tutorial for Re-open Settled Ticket & Cancel Payments is set by default to Re-Open the Ticket then immediately Cancel any previous payments.

If you’re talking about removing Ticket Tags as well, you will need to do that in an extra step… my preference would be to not remove Payment Type Ticket Tags since it would delete history of Payments (Ticket Tags).

[emre]

@QMcKay it dispalys wrong values in reports. That’s why he needs to remove payment tags.

[na1978]

@QMcKay, I need to remove Ticket Tags because it is causing Work Period Report to crash. (It seems that is trying to divide by zero)

I am still learning SambaPOS. It possible to show me what Actions or Rules I need to make to remove Ticket Tags?

[emre]

It is same as tagging a ticket with action. To remove tag you’ll set an empty value.