Skip to Content
0

query for totaling customers invoiced amount minus credits for a specific period?

Aug 31, 2017 at 01:18 PM

32

avatar image
Former Member

I am trying to come up with a query that I can run to tell me what has been spent by whom in a territory and with what sales empoloyee.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Aug 31, 2017 at 05:38 PM
1

Hi Will,

Please send some more details for actual requirement in query.

Rgds,

Kamlesh Naware

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Kamlesh,

I am trying to create a report so that I can see what all BP's in a certain territory have spent per month, minus credits (and minus cancelled invoices). It would be nice to also be able to break it down by Sales Employee as well.

Thanks.

0