2,326

(5 replies, posted in Accounts Receivable)

The amounts prepaid should not have been allocated for any other invoice and it is possible that the final invoice(s) the prepayments are sought to be allocated to may not be an exact match. Pricing, tax rates and whether inclusive or not are part of the invoice generation process and does not affect the prepayment values. What calculations do you refer to? Same date values like how to distinguish between prepaid in the morning and then invoiced in the evening?

This forum is for FrontAccounting (FA) specific:

1. Job offers directed to and availability of FA experienced technical / commercial / operational personnel.

2. Module creation requests with commercial offers for development.

3. Commercially available modules and link to it's functionality / price page.

4. FA specific hosting offers preferably with link to page listing details of offers that may be updated from time to time.

5. Support and Service offerings from developers / sponsors

6. Training in FA setup, usage, upgrade and maintenance

7. Commercial disaster recovery / migration facilities and capabilities for FA

8. FA Language / Chart / Theme contracting

9. Offers of/for integration with third party applications

10. Data Center support for FA hosting

Please refrain from spamming by multiple postings for SEO rankings even over time.
Avoid very long and descriptive postings and achieve the same by linking to a details page elsewhere.

Those providing commercial services who wish to support the FA project are requested to donate to the project by contacting the devs (@joe / @itronics).

I was not aware of the AU fiscal year you stated when I prepared the chart.

When you install such a chart, before you input any data into the installation, manually (phpmyadmin) correct the fiscal_year table so that the appropriate date ranges are there for each fiscal and they must be in serial order and no id should be missing either.

Australian Fiscal Year

I have changed the insert statement in the chart to be:

INSERT INTO `0_fiscal_year` VALUES (1, '2016-07-01', '2017-06-30', 0);

The additional key for the tax_types table UNIQUE KEY `name` (`name`,`rate`) is essential to avoid duplicate entry of tax types that populate select drop down boxes. Hope the devs will add it upstream. All AUTO_INCREMENT=XXX have been removed. Some comments have been added from later upstream chart updates.

Committed

Download the updated chart here.

1. random barcodes - security - so that it is not easily guessable as serial ones are. It appears to be a common way to do it in some local applications I have seen where an internal serial id is there to keep track by the application and the random one in another field is used for human / external automated interface. This technique is used in some hall ticket in examination systems to thwart "paper chasing" where auto dummy number allocation is resorted to.

2. A company specific config option to suppress the auto random barcode generation will help avoid confusion among those not using barcodes.

3. Which barcode type and how many digits in the barcode (if not specific to the chosen barcode) and the appropriate format for it, possibly without check digits (which should be auto generated) or when given, to be used for verification would make for a slightly more complex interaction best left to custom modules..... Making the function generic in the ammer you sufggested would be welcome even if not implemented fully for now. The barcode.php has anyway been fully "upgraded" manually from the original TCPDF sources of later versions to support a much wider range than was available earlier.

4. Yes, a note on the Show pictures options would be nice and it may double up for the config option or is it to be differentiated in some way by being a new one?

No. It will download only the old version and install that - but never mind that. Just download the new version from the FA24extensions repo and overwrite the downloaded file in your sql folder.

Then you can choose the Chart to use for creating your new company.

@itronics: please refresh the pkg repo with this new file from my repo linked herein.

Attached is the patch (for the FA 2.4 master) for Barcode auto generation on demand, reporting and extension of the barcode library to accommodate a much larger set of barcode formats.

@joe: you can commit it now.

The en_AU general 4 digit chart of accounts corrected for FA 2.4.3 has been committed to the FA24extensions repo.

@itronics: can re-create the pkg for it.

2,333

(5 replies, posted in Setup)

Why was the index:

UNIQUE KEY `name` (`name`,`rate`)

removed from the 0_tax_types table in FA 2.4 while it was there in FA 2.3?

Do we allow the same named tax with the same rate to appear more than once?

If so, how would we distinguish them in the select drop-down boxes?

@joe: what say you?

Looks like there is more than meets the eye.
There are some default data necessary for FA to run - reflines, security_roles, etc..
We need to eliminate all AUTO_INCREMENT=XXX phrases and all collation information from the base sql.
I will now proceed to make a real standard SQL for AU and revert.
Since you already have data, you may not be able to benefit from the newer dispensations in reflines unless you are willing to start the new references midway or from scratch.

None of the others have any externally sourced references like a sales order did.

@joe: should the concurrent edit issue have a more generic solution to cover all auto generated references?

Some if not all of these issues have been addressed in FA 2.4.3 or a means to edit it in the next screen is provided.

Better still - which was the original Chart of Accounts you used to start with?
Did you install any extensions that caused these differences?

You can upload anywhere (delete all insert statements especially for the users table) - just your schema and the differences with en_US-new.sql and paste the link here.

2,338

(1 replies, posted in Modules Add-on's)

This is what a REST API does. Check out forum posts and wiki articles on Slim 2 REST API for FA.

2,339

(3 replies, posted in Report Bugs here)

You have merged what should have been 2 separate vouchers. One for the invoice of 995/- and another for expenses of 5/-. Since you issued only 1 cheque for payment of 1000/- you should have got a Pay Instrument (Draft, TT, etc) for 995 and the bank would have debited you 5/- for bank charges. Hence the vouchers should have been:

Purchase Invoice:
=============
Credit AP (Supplier) - 995
Debit COGS: 995

Payment Voucher:
=============
Credit Bank - 1000/-
Debit AP (Supplier) - 995/- (Payment Allocation)
Debit Bank Charges - 5/- (Payment Allocation)

Now the Supplier Payments Report should show 995/- only.

The following fixes it:

--- admin/inst_chart.php    Thu Nov 12 03:19:51 2015
+++ admin/inst_chart.php    Sun Nov 19 12:15:49 2017
@@ -42,6 +42,10 @@
     install_extension($id);
 
 //---------------------------------------------------------------------------------------------
+function sortByOption($a, $b) {
+    return strcmp($a['name'], $b['name']);
+}
+
 start_form(true);
 
     div_start('ext_tbl');
@@ -52,6 +56,8 @@
         display_note(_("No optional chart of accounts is currently available."));
     else
     {
+        uasort($mods, 'sortByOption');
+
         $th = array(_("Chart"),  _("Installed"), _("Available"), _("Encoding"), "", "");
         $k = 0;
 

@joe: would you like to commit it?

2,341

(86 replies, posted in Modules Add-on's)

Create a Sales Invoice and use the Slim API to GET that invoice - you will get the json value. Form your new Invoice in json accordingly and use the PUT endpoint to inject your invoice. Putting in such an invoice will not have the Sales Order, Sales Delivery and Customer Payment that would need to have their own PUT requests in place (or does it?).

I'm sure you can now parse the code and determine what you need. The community has put in sufficient effort in double quick time to assist you among others. Hopefully you too will contribute tested code to it once you get familiar.

This is what makes Open Source tick.

When we are installing Charts of Accounts, as the list is long and many non standard custom ones with numerical indices will be available in the array of charts details that countries with a set of charts will be far apart making searching difficult.

Unlike languages which must start with the lang code, the charts can pretty much be anything, the name comes in handy when it denotes the country primarily though some start with number of digits in the account code.

2,343

(9 replies, posted in Announcements)

@itronics: The official release of FA 2.4.3 in SourceForge in it's tar.gz and .zip formats have CRLF DOS Style line endings. Kindly re-package the release.

Packages stand re-packaged with proper LF line endings as of 2017-12-11.

Those on the debian linux platform can do the following (alter path as required) if you have already installed it:

apt-get install dos2unix

find /var/www/frontac -type f \
     -name "*.php" \
     -o -name "*.css" \
     -o -name "*.js" \
     -o -name "*.txt" \
     -o -name "*.inc" \
     -o -name "*.sql" \
    | xargs dos2unix

In the meanwhile, users can get the official release from the GitHub commit here or from the SourceForge commit here..

The upgrade was done from official release but a patch was needed for the del tag to work. It has been submitted to their project with additional changes for their master branch of v1.4.4.

One Open Source project assisting another!

For the record, even the latest master branch of the PunBB code as on date does not officially sport the del tag. Attached is the patch for the PunBB v1.4.4 release version to enable the said tag which has been implemented here like so: del

Since the FA Forum relies on this script, a separate repo on GitHub has been created to track the changes.

2,346

(1 replies, posted in Fixed Assets)

Enable the Fixed Assets configuration in the Setup -> Roles for your role. Logout and Login again. You will find newly enable menu entries to configure your depreciation settings for the various fixed assets. Only then will it "depreciate".

2,347

(86 replies, posted in Modules Add-on's)

I took the easier way out by renaming the class and file to WLog and WSet instead as the original method gets used everywhere. I use Slim 2.64 and have it fully updated in my repo to manage without composer. Expect that Slim 2.x is not going to get updated very much in future, having been last updated on 2017-01-07 and FA dependant coding here will not need to rely on these low level methods at all.

All my Fixes to Slim 2.6.4 are in this commit.

2,348

(86 replies, posted in Modules Add-on's)

Take the latest FA 2.4 API from this post. It sports the latest Slim v2.64 and does not rely on composer.

The output of a json_decode to array using the API24 can be obtained after setting the test credentials in util.php and browsing to:

http://www.yourdomain.comt/FA24PATH/modules/api24/sales/5/13

This should retrieve Sales Invoice (type=13) #5.

Attached is the text output.

The Slim2 REST API integration for FA 2.4.3 is now attached herein. This is based on Slim v2.64 with all bugfixes included.