Report: End of Day

I've tried to generate an end-of-day report, but can't seem to get it right. I basically want a report that lists:

Item, Customer, Payment Received for Item, Type of Payment (Cash, Credit Card), like:

Red Widget, John Doe, $43.21, Credit Blue Widget, Jane Doe, $21.24, Cash

Not sales order, not invoice, but a payment report (and type of payment).

It seems like it would be one of the most basic reports. Am I just missing something obvious?

Thanks in advance for help!

Reply to
jytylr
Loading thread data ...

Yes you are. The type of payment is not that easy to obtain because an invoice can be paid by a combination of methods, cash, check, credit card, barter, and first born, specail favors, etc.

Reply to
Allan Martin

So I can't pull an end of day report saying John Doe paid for his widgets with his second first born son?

And Jane Doe paid for her widgets with $21.24 cash?

Meh! MEH! Waaaaaaaa . . .

Reply to
jytylr

The closest you can get is a Sales By Item Detail report.

Add in column for Paid (while there's a column for payment method it doesn't show the method for some strange reason).

Take out any extraneous columns you don't want like Balance.

For the date select Today. Memorize the report.

Reply to
Tee

Thanks, Tara.

As far as I can tell, there's no way to do a custom report (from scratch). Is that true?

Reply to
jytylr

Second verse same as the first.

Lets say John purchased 100 different items for $1,000. 30 days after the sale John paid 200 in cash. 60 days later he paid another 200 by credit card. 65 days later he wrote a check for 500. etc etc. How do you suppose a custom report can help?

>
Reply to
Allan Martin

It takes very little effort to confuse an issue. Trying to help might be more of a challenge; but, perhaps we ask for too much from you.

Allan Mart> > Thanks, Tara.

Reply to
jytylr

We ask he go away and stay away, he agrees that is too much.

Gosh, am I the only one who has a clue on this?

Take that report of invoices or whatever and click on the modify report button. Click the filters tab. Under type of transaction, change it from invoice to selected types. Now select the types of things you want, like receipts, credit memos and the like. Here is the trick: In the filters click on the paid by. Set the date range. Click the okay button. Presto bingo. If you like it, memorize it, if not modify it some more until it is too your liking.

I've got a report saved on a machine I don't have access to tonight. I'll double check tomorrow try and post if I forgot anything.

Reply to
Golden California Girls

That did the trick. I use the Check Detail report (REPORTS > BANKING >

CHECK DETAIL) to get the payments and payment types received, modified p. the filers you mentioned. Thanks much.

Reply to
jytylr

Sorry, rather than just tell you that the report you want can't be created in QB I made the mistake of explaining the reason why it can't be done. I gave you far to much credit. I forgot that most users simply what to know what buttons to click.

Who wants to bet if the OP was from India or China they would have responded differently to my post?

Reply to
Allan Martin

Stop giving yourself a good time. Read your inital post. The report you wanted and the one describe above are completely different.

>
Reply to
Allan Martin

Below is the report wished for by the OP:

I've tried to generate an end-of-day report, but can't seem to get it right. I basically want a report that lists:

Item, Customer, Payment Received for Item, Type of Payment (Cash, Credit Card), like:

Red Widget, John Doe, $43.21, Credit Blue Widget, Jane Doe, $21.24, Cash

Looks like it is you that does not have a clue.

Reply to
Allan Martin

Well, while you are giving out thanks you might want to send some to Allan. Check detail is the report link he sent you to in his post 6/9/05 at 7:51 in this thread. (Time is my zone of EST)

Reply to
L

Thanks L, but I did not send the link. The report the OP wanted in the original post, makes no sense and can't be created in QB.

Reply to
Allan Martin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.