FrontAccounting forum — Sales Quote Inquiry

Re: Sales Quote Inquiry

null@example.com (apmuthu) — Thu, 18 Dec 2014 18:42:49 +0000

Yes, I saw the automatic creation entry, but only wanted it for new installations to be complete. This will be useful in code analysis as well rather than searching all over the php files for all possible values.

Re: Sales Quote Inquiry

null@example.com (joe) — Thu, 18 Dec 2014 18:21:32 +0000

No apmuthu, this is done automatically in gl_setup.php, line 97.

We can wait until release 2.4 with this.

Joe

Re: Sales Quote Inquiry

null@example.com (apmuthu) — Thu, 18 Dec 2014 17:39:28 +0000

We now need to synch these changes into the default Chart of Accounts:

INSERT INTO `0_sys_prefs` VALUES ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, 30);

The code is done to auto create this entry but adding it to the CoA's is just for completion sake.

Re: Sales Quote Inquiry

null@example.com (joe) — Thu, 18 Dec 2014 08:46:37 +0000

Not a problem G, glad that you contributed with this issue.

Joe

Re: Sales Quote Inquiry

null@example.com (geoffreywalton) — Wed, 17 Dec 2014 22:06:04 +0000

Sales Order Entry and Inquiry have different field titles, so i was not confusing them.

I have just tried it again and the dates are promting as expected so apologies for a false alarm.

Not sure what could explain it, I have not changed the files since and I logged off and on again just in case.

Must be operator error but can't determine here.

Cheers

Re: Sales Quote Inquiry

null@example.com (joe) — Wed, 17 Dec 2014 17:46:46 +0000

Strange, I did test it correctly.

Are you sure you did not test Sales Order Entry by mistake?

And did you replace all files correctly?

Joe

Re: Sales Quote Inquiry

null@example.com (geoffreywalton) — Wed, 17 Dec 2014 16:41:09 +0000

Just tested this,

I went to GL set up and set Quote Valid Days to 30 and Delivery Required by to 10.

Logged off and on again.

Started Sales Quotation Inquiry, Quotation Date is 17/12/24 and the field titled "Valid Until:" is prompting with 27/12/14, this is today's date plus the number in the Delivery Required by field set up on the GL set up screen. I would expect it to be 14/01/15.

Any thoughts?

Cheers

Re: Sales Quote Inquiry

null@example.com (joe) — Wed, 17 Dec 2014 14:41:54 +0000

After Consulting with Janusz, we have decided to add this entry in the System and GL Setup, Setup tab.

Three files were updated, /admin/gl_setup.php, /includes/prefs/sysprefsinc and /sales/includes/ui/sales_order_ui.inc.

The php files has been renamed to php1, due to that php files are not allowed to upload. Please rename to .php Before replacing.

The fix has gone to HG repository and the Changes are going to next minor.

/Joe

Re: Sales Quote Inquiry

null@example.com (joe) — Wed, 17 Dec 2014 08:26:59 +0000

I guess we can fix a global variable in config.php for release 2.3 and later in 2.4 we can implement it in the sys_prefs and Company setup.

/Joe

Re: Sales Quote Inquiry

null@example.com (apmuthu) — Wed, 17 Dec 2014 04:34:58 +0000

Excellent idea.
@joe: can we get a new entry into the sys_prefs table and company preferences form for this and it's fallback in the config.php or in the scripts for backwards compatibility?

Sales Quote Inquiry

null@example.com (geoffreywalton) — Tue, 16 Dec 2014 20:27:31 +0000

When entering a Sales Quote there is a field called "Valid until:", this promts with tomorrows date.

If you complete a quote without changeing the date using Sales Order Inquiry you will not be able to see the quote after 2 days.

Most quotes are valid for 30 days, so my initial thought was for it to promt with the current date + 30.

But I dare say validity of quotes could vary by company so having it as variable in the company set up makes sense. This would enable faster entry of quotes as the operator will not need to change a date every time as the company standard would be prompted every time.

So I am proposing 2 changes:-

Company parameter of "Duration of Quote"

Allow "All Quotes" to be seen in Sales Order Enquiries by using a "Show Expired:" check box as per the "Show closed:" on the Journal Enquiry screen.

This would allow expired quotes to be retrieved and used.

Cheers