How to make custom delivery charge report

V5 Question
1

Hi,
I want make a custom delivery charge report based on the deliverers.
In this setup I made ticket tag as Deliverers. So Each delivery ticket the ticket tag deliverer will be assigned.
I need to make a delivery charge report that showing how much amount of delivery charge received by each deliverer.
Thank you.

2

And delivery charge is a product or a calculation?

1 Like
3

Delivery charge is a Calculation.

4

@JTRTech is there any way?

5

@QMcKay How to get the calculation specific report?

6

Read the WiKi:

https://sambapos.com/wiki/doku.php/custom_reporting_tags

  {REPORT CALCULATION DETAILS:<fields>:<expression>}
  {REPORT CALCULATION COUNT:<expression>}
  {REPORT CALCULATION TOTAL:<expression>}

expression supports the Calculation Type Name ( CT ):

{REPORT CALCULATION TOTAL:(CT=Delivery Charge)}

fields are:

  C.Date                              Calculation Date
  C.Time                              Calculation Time
  C.User                              User Name 
  C.Type                              Calculation Type      
  C.Amount                            Amount
  C.CalculationAmount                 Calculation Amount
7

can u please help me out for doing this?

8

{REPORT CALCULATION TOTAL:(CT=Delivery Charge)}
I need to group it by Ticket Tag DELIVERER.

9

I don’t do Delivery, and have no DELIVERER Ticket Tag, so I have no way to test this, so you will need to figure it out yourself by trying things.

You can try using expression:

TT.<tag name>                      Ticket Tagged With

Maybe:

{REPORT CALCULATION TOTAL:(CT=Delivery Charge) and (TT.DELIVERER=Joe)}

:warning: Remember, everything is cAse-sENsitive, and must match exactly. So if your Ticket Tag Name is Deliverer instead of DELIVERER, then you need to use (TT.Deliverer=Joe). The same is true for the Calculation Type Name, ie. (CT=Delivery Cost) … or whatever.

If the above works, then you can make the report a bit more “automatic” by making an @list of Deliverers, then use that list dynamically using $1 variable, like:

[Delivery Charge by Deliverer:1, 1]
@Joe,Fred,Mark,John
>Deliverer|Charges
$1|{REPORT CALCULATION TOTAL:(CT=Delivery Charge) and (TT.DELIVERER=$1)}

That ^ produces this report:

image

To make it even more “automatic”, try this:

[Delivery Charge by Deliverer:3, 1]
@{TICKET TAG LIST:DELIVERER}
>Deliverer|Charges
$1|{REPORT CALCULATION TOTAL:(CT=Delivery Charge) and (TT.DELIVERER=$1)}
1 Like
10

Perfect,. Thank You very much.:slight_smile: @QMcKay

2 Likes
11

this is not working.

12

Is not working is wrong. It does work and answered the question. If it isn’t working for you either something is different in your configuration or you made a mistake.
Not working won’t get you any answers as no one can just guess why, you have to elaborate and show what you did.

1 Like