Check for an sql method to auto convert. Take an sql backup, then convert one sales order to a delivery, now take another sql backup, compare the 2 sql backups and see what INSERT, UPDATE differences exist and check what info was passed on (each order may have different line items) and then prepare the new sql statements in an excel / sql query and run it in one shot. Take backup before any changes.

Post a bounty offer in the Job board if you are not upto doing it yourself.

Looks like you forgot to delete the install folder. Check if your config.php file exists, if not, restore it from your backup.

Your sql/update.sql has an error "END IF;" that needs to be removed as well as the trailing blank line for synch with existing module.

https://github.com/apmuthu/FA24extensions/commit/698b3f2b4f90bd7d743e9a8aabbb0e2e4f4e02e6

Have you tried OrangeHRM and creating views for read only tables from FA tables?

Anyone tested it out ?

Will then upload it to my repo and possibly @joe can take it into the official repo after vetting it.

This extension refers to OpenStreet Route Map project.

https://project-osrm.org has some subdomains like https://map.project-osrm.org and other obsolete ones like http://route.project-osrm.org last seen in 2018.

31

(1 replies, posted in Report Bugs here)

Check out the debug and debugsql settings in config.php

What do your Apache/PHP logs say?

32

(2 replies, posted in Wish List)

You can set the PDF page size in the reports by referring to TCPDF library to print on customized paper.

TCLim and others have POS. Also PHPPointofSale and OSPOS are other alternatives in php/mysql.

33

(5 replies, posted in Installation)

Refer to the existing reports in the wiki and see what you want to modify or mockup a screenshot. Check out the ERDs for the fields you need in your report.

34

(57 replies, posted in Installation)

It works if your IP is not blacklisted (does one exist?).
The following is the contents of the modules/_cache folder that has the the list of extensions as of today.

Alternatively make a separate repo with all the current ones in them and take it from there.

The unofficial repo of extensions can also be used although version bumps may not be uptodate but with fixes/extensions not in the official repo.

Time to exit your hosting service and roll your own - a learning curve though.

@joe: was that commit complete to include edition as well?

Use the bleeding edge from the GitHub Master as it has many PHP 8.x fixes.

PHP 8.3 is not yet supported in most configurations in frontaccounting 2.4.x.

39

(57 replies, posted in Installation)

The check / cheque print extensions are attached. They are from the unofficial repo.

Just unzip the appropriate one into the modules folder and update the installed_extensions.php file.

Even a mere checkbox might suffice for all binary choices.

@joe: Is this essential to include in the core FA. If so clean up the kludge herein which was just a Quick'n Dirty fix.

Attached is modified version of reporting/rep201.php file to suit your needs. You may do the same for reporting/rep201.php.

Such modified files should be placed in the company/#/reporting folder so as to be applicable as a substitute for the default one in the reporting folder.

Have a separate application for managing the truck transaction data and have a middleware to synch with FA tables when at the HQ. Issues such as change in data that was already synched will render the HQ server data as stale even though newer data are in synch.

Let us freeze the PHP version for this FA version.
People should not keep updating PHP version frequently.

If you are referring to Notrinos FrontHRM module, visit
  https://frontaccounting.com/punbb/viewtopic.php?id=9773
Check for newer version.

Check if there are any overdue items.

47

(5 replies, posted in Installation)

Navigate to Setup => Company Preferences and in the left side bottom check if the DB version is:
Database Scheme Version    2.4.1

This setting comes from the #_sys_prefs table "value: field for "name" field = version_id.

Then check your database schema and settings / constants in the your database with the schema sql of the Chart of Accounts used and make the necessary changes to match the version you used. All CoAs are for the install are in the sql folder. Also see if the version numbers match the ones in the "installed_extensions.php file if they were added from withing the UI.

After you have updated the core FA files, navigate to Setup => Software Upgrade and see if all is okay.

Did you mean:
https://frontaccounting.com/fawiki/uploads/Help/Rep201_SupBalRpt.png
https://frontaccounting.com/fawiki/uploads/Help/Rep101_CustomerBalances.png

https://www.tax-rates.org/taxtables/sales-tax-by-state

50

(5 replies, posted in Installation)

check version.php file.