Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Contract - Retrieval Issue
12-20-2017, 12:12 PM, (This post was last modified: 12-20-2017, 12:58 PM by VortecCPI.)
#1
Contract - Retrieval Issue
Main Menu > Sales > Select Contract

Modify > Update Confirmation

Click "Go to Confirmation N"

SelectSalesOrder.php

Multiple errors: "ERROR Message Report : The date does not appear to be in a valid format. The date being converted from SQL format was:"

   

Looking into it now...

Looks like SQL is using condition " AND salesorders.quotation=0" where it should be " AND salesorders.quotation=1"

$_POST['Quotations'] is empty or not set?

Look like this needs to be set at the top of the code page instead of where it is now just below "if (!isset($StockID)) {"

if (isset($_GET['Quotations']) AND $_GET['Quotations']=='Quotes_Only'){
$_POST['Quotations']='Quotes_Only';
}

Attached is my change. Can somebody please check it to be sure what I did is correct? Just because it works does not mean it is right!


Attached Files
.php   SelectSalesOrder.php (Size: 42.18 KB / Downloads: 2)
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Messages In This Thread
Contract - Retrieval Issue - by VortecCPI - 12-20-2017, 12:12 PM
RE: Contract - Retrieval Issue - by TurboPT - 12-21-2017, 04:25 AM
RE: Contract - Retrieval Issue - by VortecCPI - 12-21-2017, 06:42 AM
RE: Contract - Retrieval Issue - by TurboPT - 12-21-2017, 06:47 AM
RE: Contract - Retrieval Issue - by VortecCPI - 12-21-2017, 07:16 AM
RE: Contract - Retrieval Issue - by TurboPT - 12-21-2017, 07:31 AM
RE: Contract - Retrieval Issue - by TurboPT - 12-23-2017, 04:20 AM
RE: Contract - Retrieval Issue - by TurboPT - 12-28-2017, 03:09 PM
RE: Contract - Retrieval Issue - by TimSchofield - 01-02-2018, 07:26 PM
RE: Contract - Retrieval Issue - by VortecCPI - 01-03-2018, 12:17 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-03-2018, 03:16 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-03-2018, 03:28 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-03-2018, 05:26 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-03-2018, 11:11 PM
RE: Contract - Retrieval Issue - by TurboPT - 01-04-2018, 01:38 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-04-2018, 03:15 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-04-2018, 05:15 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-04-2018, 05:44 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-04-2018, 05:58 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-04-2018, 06:03 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-04-2018, 06:05 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-06-2018, 06:41 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-06-2018, 06:48 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-06-2018, 07:08 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-06-2018, 07:55 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-06-2018, 10:57 PM
RE: Contract - Retrieval Issue - by TimSchofield - 01-06-2018, 11:49 PM
RE: Contract - Retrieval Issue - by TurboPT - 01-07-2018, 12:33 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-07-2018, 12:42 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-07-2018, 01:25 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-07-2018, 01:46 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-07-2018, 02:03 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-07-2018, 02:13 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-07-2018, 04:24 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-07-2018, 05:00 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-07-2018, 12:28 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)