User Sales by Payment Type

Hi I was wondering if someone could help me. The problem I’m having is that I need the Settled by {User} feature in my V5 Work Period Report it seems to be missing or doesn’t report the same as V4. I would like my V5 Work period report to contain a settled by section its essential for my business but I am unable to figure out the tags to make it work. It also needs to be broken down into payment type like in the picture attached.

Something like the attached picture would be perfect.

[User Sales:1, 1] 
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum}
@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,} 
[Settled by $1:1, 1, 1] 
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1)} 
>Total Income|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}

Try that let me know

1 Like

That code generates this now but at least its a step in the right direction.

Thats because its inserted into Work Periods… try putting it at the top of report.

Worked like a Charm Thank You :smiley:

1 Like

Great idea @kendash !!!

@emre I have seen it requested a lot maybe we should put it back into the Default Work Period report. What do you think?

1 Like

@Gilberts be sure and delete the User Sales near bottom of work periods report or it might show user 2x at top.