| Author |
Message |
|
porteast
|
Post subject: Backorder Report  Posted: Thu Sep 29, 2011 8:41 am |
|
Joined: Wed Jan 28, 2009 2:59 am
Posts: 123
|
|
I saw somewhere mention of a Backorder Report, I can't find it in the report downloads. Can someone point me in the right direction please.
Thanks
JC
|
|
  |
|
 |
|
dave
|
Post subject: Re: Backorder Report Posted: Sun Oct 02, 2011 9:10 am |
|
Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3498
Location: Colorado, US
|
|
Here's the one I use.
Dave
|
|
| |
|
|
|
porteast
|
Post subject: Re: Backorder Report Posted: Sun Oct 02, 2011 11:33 am |
|
Joined: Wed Jan 28, 2009 2:59 am
Posts: 123
|
|
Thanks Dave, it will work for me.
JC
|
|
| |
|
|
|
porteast
|
Post subject: Re: Backorder Report Posted: Wed Oct 05, 2011 1:38 pm |
|
Joined: Wed Jan 28, 2009 2:59 am
Posts: 123
|
|
Hi Dave
I need to make a few changes to the report for our situation, but when I make the changes, the report boms out with:
"There was not any data in this report based on the criteria provided! The sql was: SELECT journal_main.bill_primary_name AS c0, journal_main.post_date AS c1, journal_main.purchase_invoice_id AS c2, journal_item.sku AS c3, journal_item.description AS c4, journal_item.qty AS c5, inventory.quantity_on_hand AS c6, qty_backorder AS c7 FROM journal_main JOIN journal_item ON journal_main.id = journal_item.ref_id JOIN inventory ON inventory.sku = journal_item.sku WHERE journal_main.id = '0' and journal_main.id = '10' and journal_main.id = 'soo' ORDER BY journal_main.post_date
I then removed the report, re-imported, opened the report with edit without making any changes and hit the save button. When I then tried to run the report, I get the error again.
Something wrong, can you assist.
Thanks
JC
|
|
| |
|
|
|
dave
|
Post subject: Re: Backorder Report Posted: Thu Oct 06, 2011 3:25 pm |
|
Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3498
Location: Colorado, US
|
|
The problem is with: WHERE journal_main.id = '0'
This will never happen. This field is derived from the criteria tab on the builder, probably one of the fields is not specified properly. After you save, re-open the form and see if one of the criteria fields is empty.
Dave
|
|
| |
|
|
|
