Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
reports
03-18-2017, 02:55 PM,
#1
Wink  reports
If anyone could give help on creating a report that would show orders that have not been "shipped/confirmed" in the system for a specific location that the user would select when running the report
Reply
10-06-2017, 09:06 AM,
#2
RE: reports
tim or phil on this one.?
Reply
10-06-2017, 12:32 PM,
#3
RE: reports
Well this is the outstanding sales orders inquiry?

http://www.weberp.org/weberp/SelectSalesOrder.php

just print the browser window.
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
10-06-2017, 06:03 PM,
#4
RE: reports
I would start off with the orders invoiced report PDFOrdersInvoiced.php as it mostly does this already. You will need to add a check in the SQL to only include orders with a total invoiced of zero (or less than the total ordered if you want to include orders partially despatched). There is a loop in the middle to print out invoices that you should remove. This should do the job, and all that is left is formatting the report to be as you want.

Tim
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)