@joe: The explanation is okay but any change from FA 2.3 that warranted this in FA 2.4? Just a design decision that may fill up the ID space quickly. Is such a change of transaction number of any real benefit?

1,877

(7 replies, posted in Report Bugs here)

Thanks @joe.

There are a host of inquiry files that needs to be merged and tested as well.
Will get the diffs after testing.

In includes/ui/ui_view.inc, the newly added functions set_posts() and get_js_history() use the splat operator available in PHP 5.6+ for variable length argument lists.

Some workarounds are here.

We need to make it backwards compatible with the attached diff file.

@joe / @itronics: Do we intend to revert to FA 2.3.x functionality for retaining the same transaction number? Why was it changed in FA 2.4.x?

@uurfi: Open a new topic for each issue.

As a start try to change the field size and see if that satisfies the entry. Then change the font size on display/print.

1,880

(1 replies, posted in Reporting)

Create and use a new en_IN.mo file by editing and compiling the en_IN.po file  based on empty.po with the said "VAT" being replaced with "GST" everywhere.

1,881

(7 replies, posted in Report Bugs here)

@braathwaate has sent me a good pull request that needs to be incorporated into the core after checking if any critical extension breaks. The key file diffs are attached - includes/ui/ui_view.inc and js/insert.js.

@joe/@itronics: can do the needful.

Use FA 2.4.3+ as it has a lot of fixes.

You need to have some items and customers before you can create a sales quotation.

Also use a Chart of Accounts that matches the en_US-new.sql for tables, fields, field types and fields orders apart from missing SysPrefs entries fixed. Checkout the latest Charts from here.

1,883

(4 replies, posted in Setup)

1. Check tables with large logs and purge them especially after changing the debug variables in the config.php.
2. Use the command line to dump the backup - mysqldump
3. Use a MySQL client like SQLyog.
4. Increase the php.ini's script timeout and max transfer size / memory limit variables
5. FA's time limit is also hardcoded at 180 seconds or so - search the wiki.

In a separate new company, make 1 sample transaction to simulate the wrong entries you mad. Study the before and after sql backups Now appropriately edit the actual company's DB with these updations, possibly having the sqls created from a spreadsheet.

Using FA under localhost on Windows/Mac desktops is about the easiest it will get.

1,886

(5 replies, posted in Setup)

Most proprietary applications help you migrate your data from other's programs into theirs but will not help in doing the reverse. In the case of FA, you have access to the raw tables that you can manipulate/extend at will and migrae in/out without reference to anyone.

Identify the Sage DB used and it's version. See if an ODBC driver exists and is interface-able. Then identify the core elements you wish to import - Customers, Suppliers, Items, Pricelists, Chart of Accounts, etc. Export such data into an FA usable format and import using the Import extensions in FA.

Doing it yourself right is cost-effective. Asking others to do it might turn out more expensive than buying Sage, etc.

1,887

(3 replies, posted in Accounts Receivable)

If the customer paid by non-cash means, say by cheque, then it would go directly to bank but still needs to be allocated to the appropriate sales invoice(s).

@uurfi: does this happen only to journal entries in FA 2.4?
@joe/@itronics: This needs to be fixed if true.

Use PHP upto 7.1.x. PHP 7.2.x still has issues with FA. Make sure that the MySQL Strict Date setting is disabled to allow for zero dates and times. Otherwise revert to PHP 5.5 or less.

The finished goods must then be moved to the appropriate warehouse location.

@joe: any issue here?

1,891

(1 replies, posted in Reporting)

Setup => System and General GL Setup => Tax Algorithm
Toggle the choices and see what suits you. Logout and login again for it to be effective.

Hence the DB Record Number will change on such editing as the Audit Trail needs to keep track of it.

Test with Git Master FA 2.4.3+ as many fixes are included now since the original release.
State your server platform, PHP/MySQL versions.

After the release of FA 2.4.3, there have been quite a few fixes. Hence use FA 2.4.3+.

@joe: is this possible?

1,895

(0 replies, posted in Announcements)

The SourceForge SysOps Twitter page states that there is no ETA for getting it up to speed. It is back online now after 9 days of outage.

Also read:

The Problem With Putting All the World's Code in GitHub and it's parallels with SF being taken over by corporate profit interests and the "death" of Google's Codeplex on pursuing "all data is only mine" policies.

How GitHub Conquered Google, Microsoft, and Everyone Else

In academic vein as an example for an alternative to Grade III multiplication, view the Karatsuba Multiplication.

Just to purge a whole lot of already delivered orders after invoicing - a sort of "history -c" in bash. This will make for just the retrieval and display of "Outstanding Sales Orders along with recently completed Sales Orders (so as to answer CRM questions by Call Centers). "Cancel Orders" still does not affect already delivered and invoiced sales orders. Just like "Clear the Desktop of all the Clutter". Makes searching that much more efficient at the cost of "loss of history and trackbacks".

1,897

(15 replies, posted in Reporting)

BasrCode by default is EAN/UPC - does the item have a proper barcode-able no?

@cempamj: Very nice documentation indeed. The wiki will certainly benefit from it once done.

1,899

(26 replies, posted in Report Bugs here)

Sourceforge Git web UI seems to be down now. Works now.

Except for the fact that if it was not fully delivered and invoiced, the balance that will not be delivered can be removed from it so that it does not confuse outstanding sales order deliverables.