1. Home
  2. Point-Of-Sale Software
  3. Sales report: Written vs. Delivered

Sales report: Written vs. Delivered

I want a report that shows 'written' instead of 'delivered' sales for any given time frame.

Delivered Sales is what I get now. It's invoices generated in the specified date range.

Written sales should include:

  1. all orders (open & closed) created in the specified date range
  2. invoices where no order was created

It should also exclude:

  1. invoices generated from orders created outside the specified date range

If you have a report like this or would be willing & able to help me create one, I'd really appreciate it.

Tom

Reply to
Terrible Tom
Loading thread data ...

Hi Tom, you can use the RecallID and RecallType fields in the Transaction table to link back to the original Order table record. Both tables have TIME fields you can use to filter records by date. Your query will probably need a couple of UNION commands to piece together the segments you need. Let me know if you want to discuss it further.

Ken K kkosnik at cacorp dot com

Reply to
Ken K

I am definitely interested in discussing it further.

I have successfully added columns to existing reports in the past, though my experience with the UNION statement is practically nonexistent.

Today's a really busy day here - our annual anniversary sale - but I would very much like to talk about this some more tomorrow.

Tom

"Ken K" wrote:

Reply to
Terrible Tom

I was talking with one of my bookkeepers and it dawned on me that I am complicating this issue unnecessarily.

All I need to do is add transactions with no RecallID to an existing work order report. I can already remove the 'Status = OPEN' filter to get all orders for a date range. All I need to do is add from the transaction table all entries with no RecallID that meet the date range criteria.

I think that the best starting point would be the Work Orders - Detailed report.

Tom

"Ken K" wrote:

Reply to
Terrible Tom

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.