Hi, I´m just getting to know SambaPOS and I’m amazed how customizable it is. I been trying to get some custom report to work after reading some post about it but my SQL knowledge is not really good.
I’m tagging the paid tickets with a number just before they are close and printed and I use this number as the invoice number, it is store as a ticket tag called FACTURA. I’m also tagging the ticket with the number of people making use of the entity: ADULTS and KIDS .
What I’m looking for is to have a custom report that is arrange by the ticket tag number used as invoice number called FACTURA, and contains the date, time, the customer(CLIENTE) name(Nombre),customer ID number(Cedula), ticket tag number of people(ADULTS,KIDS), Subtotal (Total without taxes(10%Servicios,12%IVA)), taxes (Tax templates (10%Servicios,12%IVA)), Total amount (Subtotal+Taxes) and payment type (Cash, Credit or Deposit).
At the end I also would like to have the total of ADULTS, KIDS, Subtotal, taxes(10% Servicios, 12%IVA) and Total amount.
Anyone can give me a hand with this if it is possible, I’ll really apreciate it! Thanks in advance.
PS: #.00;-#.00;- format string after PA.Cash and PA.Credit Card fields used to display zero payment amounts as “-” for more readability. You can try removing it if you want zeros instead.
Nice, thanks a lot for your help! I got it working, I would like to know what expression should I use when there is no value associated to show “-” instead, like the one that is used when the value is zero (#.00;-#.00;-)?
Also how do I get all the values from a column added at the end? Because I have Ticket Tag Values in the table that I would like to be added at the end like Number of persons grand total, and also I would like taxes and total amount grand total at the end.
Reading tutorials @Jesse linked will give more idea so once you get the idea you can create your own reports. SQL is needed for some advanced cases. Generally Custom Report tag syntax does the job fine.
I understood you can format it if the values are positive, negative and zero, but my question was what if there was no value (no zero, no positive, no negative), how to make a ¨-¨ be show also if there is no value associated. This can be caused when a ticket tag was not assigned in a ticket for some reason.
My other question was how to add all the values in each individual column and show them at the end like this:
(Can ticket tag values been add together at the end of the column as well?)
I’ve added two reports to demonstrate the difference. On first report you’ll see first ticket does not have a person value. On second report I’ve forced it to process as a number by using TTN (comes with .57). So empty values processed as 0 and it will obey your zero format.
This is exactly what I been looking for! Thanks for the great software! Where can i get the last update? or when will it be released? Thanks a los for your help!
Then: This type of average adds all sales and all ticket types from all departments.
What I specifically need is for me to average my customer ticket at the table, not for delivery customers.
Rob, while posting templates can you format your post properly to make it more readable? You can select code and click </> button to make it appear in a box.