To enlarge the F2 screen for customers replace Line 506 in includes/ui/ui_controls.inc from

        113,    _("Customers"), 900, 500),

with

        113,    _("Customers"), 900, 600),

@joe: can commit this.
Committed

Why are we sprinkling variable and array assignments in files that otherwise contain functions only?

Video

Greeting's Mihael

Fiscal years 2016 and 2017 are open.
Company is set to Fiscal Year 2016.
3 Quotes - Nos. 1,2,3 are created in 2017 fiscal year.
1 Quote - No. 4 is created in 2016 fiscal year now during Aug 2017.

The View Quote shows the reference as 004/2016 whereas it should be 001/2016 which it is in the refs table.
The Print Quote shows 001/2016 as the Quote No (reference) in the header and in the middle, it shows Quotation No. 4.

These need to be fixed as well.

Thank you for pointing this problem.

Janusz

Also the function date2sql() in includes/date_functions.inc can be fixed by replacing:

    if ($date_ == null || strlen($date_) == 0)
        return "";

    $date_ = trim($date_);

with

    $date_ = trim($date_);

    if ($date_ == null || strlen($date_) == 0)
        return "";

Committed

Joe

Check your install and you will find that the Company's current fiscal year is 2016 instead of 2017 (hope you have created 2017).

@joe: I can confirm this to be an issue in FA 2.4.2+. If you enter a Sales Quotation (possibly Sales Order too) in any previous fiscal year then it will not show up in a transaction search (Sales Quotation Inquiry). Also in a listing of Sales quotations, we can disable the GL entries icon. Any further new / edit Sales Quotation entry will show up the last reference value instead of the relevant next ref value for the new one / same reference value of the one to be edited.

Best is not to allow creation of any Sales Quotation in any previous fiscal year with an allow override permission for edge cases like accounting from archived vouchers. In any case this issue needs resolution.

YOUTUBE

I do not know exactly if we understand each other, so I made a short Screen Capture on the problem.

VIDEO (37.6 MB)

In the db:
1. You have 2 entries for the same item in the same sales quotation but no sales order.
2. You have 1 sales quotation (and the corresponding entry in the refs table).
3. You have no sales invoices.

These can be verified in the Setup -> View/Print Transactions page.

Here is how to trouble shoot it.
1. Take a backup of a freshly installed en_US-demo.sql based default company.
2. Take another backup of your company db.
3. Replace all company db table's prefixes with "0_" to match the first one.
4. Use any diff tool (WinMerge) to check the differences between the two backups.

You did not have the 2017 year in your fiscal years table and I have created it.
You made the sales quotation in Aug 2017 and expected it to be valid till end of Jan 2017!
Your operational fiscal year was 2016 and hence the reference was needed to be reset each time as your quote was for 2017. I have now made it to be the newly created fiscal year 2017.

Now all is well.

Upgrade_Screen

There is another new installation here, the same error

FA2.4.2

user:admin
pass:pasword

alter2.4rc1.php
alter2.4rc1.sql
alter2.4.php
alter2.4.sql

Whilst the *.sql files bring the schema uptodate, the *.php files migrate the data carefully into the new constructs and then cleans up the old ones.

The 2.3 database will not run in 2.4, there have been many changes, most noticeably in your case references have changed to reflines, so you need to continue with your upgrade:-

Its all explained in the update.html file which is in FA's root directory - Please read this 1st - I've completed many upgrades by following these instructions and never had a problem.

There are 2 parts to the upgrade, the software upgrade and the database upgrade, from your description and the screenshot, it 'looks' like you have done the software upgrade, now you need to do the database upgrade - I think you need to go to Setup - Software Upgrade (this is really the database upgrade), this should show you that you have an upgrade - click the 2.4 upgrade and it will make the necessary changes in the database. It will take a while to make the necessary changes, this will depend on the size of your database.

To answer your question

Its in the "sql" folder. Have a look at the sql in this file and you will see that it corresponds with your screenshot errors. You could run this directly in myphpadmin, but the software upgrade works fine and I've used it numerous times.