Report to list Sales Invoices with remaining balance

1

We are preparing an event for which we have printed tickets. And I keep track (as an invoice) for each members of our group how many tickets they have with them, and how much (as a receipt) they have sold. So I can calculate how much they still have in their hand.

For the general pages of the application (Sales Invoices) or the existing report “Customer Statements (Unpaid Invoices)”, I can get the information, but one member at a time.

So I’m trying to create a custom report to have a unique list of members with remaining due payment.

I tried so may possibilities, but still not found what I’m looking for. So if someone can help me with that, it would be very appreciate.

Thanks in advance for your help.

2

Have you tried using the built-in Aged Receivables report?

3

Custom reports can only include transactions that have been entered. So your desire is a lost cause.

What you are trying to accomplish is not an accounting function to begin with. So you will need to track ticket sales some other way.

4

Which is not in Manager terminology so is difficult to interpret.

Just to clarify, are you

  • giving a book of tickets to a sales person and invoicing that person for the books of tickets supplied

  • then as the sales person sells a ticket you enter a receipt against the invoice for that sales person

  • You then intend to use invoice payment for that inventory item to track ticket sales for each sales person?

5

I tried it, but as soon as I set the “Division” related to our event, the report returns nothing.
But all the tickets (inventory item) are associated to that division.

6

The way I tried is to enter the tickets in the inventory to start.
The, to each member I provide some tickets, I create a Sale invoice as selling them a ticket.
So all those tickets are (in one hand) calculated as sold (reducing the inventory) and the member has a “du payment” to do.
Some of the already bring back some payments, so I created a “Receipt”. So their “Due amount” is decreasing.
My goal is not to manage the number of tickets I expect to sold, but the amount of money that is in the Account receivable, but detailed, and just for that division.

7

Right. But to be more clear, the goal is not to know how many tickets has been sold, but how much money should be back, and who is suppose to bring it back.

As mentioned, the existing built-in report “Customer Statements (Unpaid Invoice)” does exactly what I needed, but we can not filter by division (which I’m trying to do).

8

If this is what you are doing, when and how is this accomplished?

You can’t get such information from a system without entering it into the system, hence my question on how and when the sales receipts are entered.

9

When they give me back the money for the tickets I gave them.
On my perspective, I sell them the tickets (creating an invoice, so it become a due payment by them) and when they give me the expected the money (receivable), I close that transaction (no more due)