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?
2,326 11/23/2017 06:25:04 am
Re: How to do: sales prepaid (5 replies, posted in Accounts Receivable)
2,327 11/22/2017 09:59:02 pm
Topic: This Forum Usage (0 replies, posted in Jobs wanted/offered, non-free offers)
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).
2,328 11/22/2017 09:07:31 pm
Re: Bookings in previous financial years (17 replies, posted in Banking and General Ledger)
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.
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.
Download the updated chart here.
2,329 11/22/2017 08:53:56 pm
Re: EAN13 BarCode patch for FA 2.4.x (10 replies, posted in Items and Inventory)
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?
2,330 11/21/2017 02:41:12 pm
Re: Bookings in previous financial years (17 replies, posted in Banking and General Ledger)
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.
2,331 11/20/2017 04:59:55 pm
Topic: EAN13 BarCode patch for FA 2.4.x (10 replies, posted in Items and Inventory)
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.
2,332 11/20/2017 04:53:11 pm
Re: Bookings in previous financial years (17 replies, posted in Banking and General Ledger)
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 11/20/2017 04:33:18 pm
Re: DB Schema anomalies (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?
2,334 11/20/2017 02:40:47 pm
Re: Bookings in previous financial years (17 replies, posted in Banking and General Ledger)
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.
2,335 11/20/2017 01:55:53 pm
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
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?
2,336 11/19/2017 05:44:13 pm
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
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.
2,337 11/19/2017 05:30:19 pm
Re: Bookings in previous financial years (17 replies, posted in Banking and General Ledger)
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 11/19/2017 05:25:44 pm
Re: Journal entry - Direct db access (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 11/19/2017 05:23:40 pm
Re: Bank Account Payment Entry (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.
2,340 11/19/2017 06:55:27 am
Re: Sort Chart of Accounts by name (2 replies, posted in Misc. Charts of Accounts)
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 11/19/2017 06:52:31 am
Re: REST API (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.
2,342 11/18/2017 05:18:29 pm
Topic: Sort Chart of Accounts by name (2 replies, posted in Misc. Charts of Accounts)
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 11/18/2017 05:12:34 pm
Re: Release 2.4.3 (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..
2,344 11/18/2017 12:42:59 pm
Re: PunBB Forum Update from 1.3.6 to 1.4.4. (3 replies, posted in Announcements)
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!
2,345 11/18/2017 10:47:07 am
Re: PunBB Forum Update from 1.3.6 to 1.4.4. (3 replies, posted in Announcements)
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 11/18/2017 06:48:57 am
Re: How do Fixed asssets depreciate (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 11/18/2017 04:46:57 am
Re: REST API (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 11/18/2017 03:40:33 am
Re: REST API (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.
2,349 11/18/2017 03:39:09 am
Re: Slim REST API module for FA 2.4.x - No Composer (18 replies, posted in Modules Add-on's)
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.
2,350 11/18/2017 02:24:32 am
Re: Slim REST API module for FA 2.4.x - No Composer (18 replies, posted in Modules Add-on's)
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.