Custom Transaction Report with Balance

[Jason Dunham]

Hi Derek,

I believe I am using the customer payment and invoice features correctly,
but on the customer report, I just get one line for the invoice total, so I
also have to print out the invoice. That's not a killer, but the invoice
doesn't add much value in my situation.  I'd rather just have all the
invoice items entered as regular transactions and generate a transaction
report (just like a bank statement does).  I suppose I could make separate
invoices for each line item, but that's a pain too.  It's also difficult to
include credits and refunds in the invoice, which is its own problem.

The more serious need is the beginning and ending balances. I presume I'll
have to figure this out in scheme.

Thanks for the reply,
Jason

On Thu, Dec 10, 2009 at 1:26 PM, Derek Atkins <warlord at mit.edu> wrote:

> Hi,
>
> Jason Dunham <jwdunham at gmail.com> writes:
>
> [snip]
> > with starting and ending balances. If it matters, which it shouldn't, it
> > will be for the Accounts Receivable account, filtered by customer.  It
> > should show the starting balance, a list of all transactions, and the
> ending
> > balance.  Basically I need a "statement", exactly what everyone gets from
> > banks and credit card companies every month.  The customer report doesn't
> > show each transaction, and I don't really need to generate invoices so
> much
>
> What do you mean by "doesn't show each transaction".  It most certainly
> does show every Invoice and Payment.  Of course it only works if you USE
> the invoice and payment interfaces....
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>       warlord at MIT.EDU                        PGP key available
>