How to make custom delivery charge report


#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?


#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)}

Custom Package Delivery for V5
#10

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


#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.