Search options (Page 2 of 4)

11/14/2018 09:43:19 pm

Hello,

I managed to upgrade to 2.4.4 from 2.4.2 on php 7.2 directly, and the process was relatively straight forward, though I have to say I did manage to delete a few things on 2.4.2 before I upgraded 2.4.4. and had no choice but to make it work. Luckily I had created backup from FA itself.

One problem I came across was similar to what has been discussed in this post https://frontaccounting.com/punbb/viewtopic.php?id=7778

I got an error before installation begins and pointed it to "maintenance_db.inc" file at line 186, but I applied same logic as mentioned in the link and replaced count by count_array and installation was successful.

    // update per company files
     $cnt = max(1, count($db_connections));
    for($i = 0; $i < $cnt; $i++)

So far so good, and everything seems to be working fine.
I haven't been able to use import items extension on 2.4.4 though I tried everything but that can wait.

Thank you all for all the help.

10/25/2018 09:47:26 pm

This excel manipulation would be a boon, especially for someone like me who's had to take multiple steps in order to 'comply' with so called regulations.

Thanks a lot.

10/25/2018 09:45:25 pm

Thank you all.

I am going to try and move to 2.4.4 along with php 7.2 over the weekend.

I am planning to do a fresh install and use the back from my prod of 2.4.2 before I migrate over completely.

Hope it all goes well or else I'll be back with lot of questions again.

10/22/2018 08:37:35 pm

Hello all,

Seems I completely missed this very important bit of information on VAT, thank you for bring this up @Hirum.
(I am based in UK and so will definitely get impacted because of this.)

I read above posts and so going to speak a bit below...

Going through the links, it seems that to get started we should be fine if we use the so called "API-enabled spreadsheets".

The process I currently follow is very similar, where I download all the tax related data from front accounting and then literally copy paste it in to an excel template I have created.

The only exception to above is when I have made journal entries for expenses and vat needs to be reclaimed, for these particular entries I copy paste lines in to above excel sheet, and every quarter the numbers match 100%.

The only new thing I see is that I'll have to use a excel sheet which would communicate with HMRC directly. So some work required.

But in the meantime are there are any VAT users reading this who have developed a way to identify VAT transactions entered using a date from a previously reported VAT period but not included in that periods VAT return, it would be really interesting to hear if anyone has a way to spot late entries to include in the following period. (allowed up to a certain level by UK tax authorities)
Also, does anyone run a "check report" of any kind on their VAT entries. For example if the standard VAT rate is 20% the report would "flag" entries which didn't seem to match that calculation because of user input error.

With regards to the point of late entries or entries which need to be entered in next quarter, I follow a process where I reconcile every bank transaction (80% purchases in my case, and 20% comprises of sales/expense etc). Effectively I check what transaction are pending reconciliation from previous quarter, and they would be included in present quarter.

The template I use has some basic excel formula, which looks up net amount, tax rate from tax report via front accounting, and calculates vat amount on net price, and then check if it matches to what vat amount is in tax report(rounded to two decimal places, for avoiding penny errors).

Hope this long post helps. And please let me know if I can be of any help.

Also, if my memory serves right for zero rate tax, I've found that if you enter tax as zero, it doesn't show it as zero rate, if you don't enter anything it shows as zero rate

Just found this guys who are already providing solutions it seems
https://www.taxoptimiser.co.uk/Features/MTDVAT

I am sure we'll be fine when the time comes for MTD (Making Tax Digital).

Regards,
GJ

10/22/2018 08:06:45 pm

Am I correct in understanding below ?

1. I can install 2.4.2 and 2.4.4 both on php7.1 and php7.2?

2. Once 2.4.x is installed on certain php version, the php version cannot be updated for same installation to work with higher php version ? (e.g. I have 2.4.2 installed on php5.6, but when I upgrade to php7.1, I start getting errors).

10/19/2018 07:56:12 pm

Hi,

Sorry to pick your brains again but, the problem I have in next few days is that my web services provider is going to stop supporting both php 5.6 and 7.0 completely, so I need to make sure that my existing installation 2.4.2 keeps working smoothly on php 7.1 or if possible php 7.2.

Right now when I change my php from 5.6 to 7.1, within my web services control panel, I encounter below error message, which I did try solving using this post but, it gave few more errors.

Fatal error: Uncaught Error: Call to undefined function user_company() in /customers/4/6/2/portuk.com/httpd.www/fa/includes/errors.inc:85 Stack trace: #0 /customers/4/6/2/portuk.com/httpd.www/fa/includes/session.inc(376): error_handler(8192, 'Methods with th...', '/customers/4/6/...', 19, Array) #1 /customers/4/6/2/portuk.com/httpd.www/fa/includes/session.inc(376): include_once() #2 /customers/4/6/2/portuk.com/httpd.www/fa/index.php(18): include_once('/customers/4/6/...') #3 {main} thrown in /customers/4/6/2/portuk.com/httpd.www/fa/includes/errors.inc on line 85

For now I want to make sure that I can keep working on 2.4.2, and if possible update to 2.4.4 in order to avoid more complications when it comes to updating to new versions.

Along with the PHP 7.1/7.2 upgrade you also run the risk of getting your MySQL version upgraded too to 5.7.x which may need some strict setting to be switched off like zero date.

As for above, I don't mind strict settings switched off, but I really don't know where or how to switch them off.

apmuthu wrote:

The function user_company() is in includes/current_user.inc and expects the default company to be defined in the config_db.php file for use on the login screen if no company is available / selected as yet.
The files that changed from FA v2.4.2 to FA 2.4.4 and those that changed thereafter to the current GitMaster are available in the announcements page from where you can sequentially overwrite the existing ones without having to install them (the install folder's files may be ignored).
The databases may have to be upgraded on first admin login into each company.
Along with the PHP 7.1/7.2 upgrade you also run the risk of getting your MySQL version upgraded too to 5.7.x which may need some strict setting to be switched off like zero date.

10/19/2018 07:45:19 pm

poncho1234 wrote:

To clarify on MySQL version: You are running MariaDB not MySQL, MariaDB 10.0 is compatible with MySQL 5.6, and MariaDB 10.2 is compatible with MySQL 5.7.
So it depends on what your last digit is?

Read about it here

Hi Ponocho1234,

You are right, I am running below MariaDB, which according to link in your post is equivalent of MySQL 5.6.

Software version: 10.1.30-MariaDB-1~xenial - mariadb.org binary distribution

Thank you

10/19/2018 01:50:44 pm

apmuthu wrote:

The function user_company() is in includes/current_user.inc and expects the default company to be defined in the config_db.php file for use on the login screen if no company is available / selected as yet.
The files that changed from FA v2.4.2 to FA 2.4.4 and those that changed thereafter to the current GitMaster are available in the announcements page from where you can sequentially overwrite the existing ones without having to install them (the install folder's files may be ignored).
The databases may have to be upgraded on first admin login into each company.
Along with the PHP 7.1/7.2 upgrade you also run the risk of getting your MySQL version upgraded too to 5.7.x which may need some strict setting to be switched off like zero date.

I need to update to 2.4.4 and with php7.1 or 7.2, as php5.6 and 7.0 won't be supported by one.com post mid Nov 18.

But I want to make sure i can have continuity of system in order to avoid manual entry or re-entry of transactions.

If I check mysql version via myphp, I think it is 10.x.x something, way ahead than 5.7.x.

I really need some help and clarity on how to go about this.

10/19/2018 10:04:01 am

Thank you for your reply.

With new database I meant the one I create within we hosting.

Also, can someone please let me know about the php7.1 or php7.2 usage?

10/18/2018 10:06:42 pm

Hello all,

I have come to a stage where my web services provider has finally decided to upgrade to php 7.1 by mid Nov and so I have no choice but to upgrade from 5.6 to 7.1.

Also as I am running 2.4.2, with a lot of minor changes in reporting names, etc I didn't upgrade to 2.4.3, that means I have no choice but to move to 2.4.4 directly and as I have lot of different transactions I am not keen to re-enter them all in fresh install.

I like the steps I see above in post 2 and hopefully I won't encounter any problems, but I have a few questions which I really need help with before I take any adventurous steps.

1. I am running 2.4.2 with php5.6. I believe 2.4.2 is compatible with php7.0, but when I change from php5.6 to php7.0 within my web hosting control panel (I am with www.one.com) for some reason I start getting "fatal errors" as below.
Am I correct in understanding that my installation was done on php5.6 which is why I get this error if I now switch to php7.0 ?

Fatal error: Uncaught Error: Call to undefined function user_company() in /customers/4/6/2/portuk.com/httpd.www/fa/includes/errors.inc:85 Stack trace: #0 /customers/4/6/2/portuk.com/httpd.www/fa/includes/session.inc(376): error_handler(8192, 'Methods with th...', '/customers/4/6/...', 19, Array) #1 /customers/4/6/2/portuk.com/httpd.www/fa/includes/session.inc(376): include_once() #2 /customers/4/6/2/portuk.com/httpd.www/fa/index.php(18): include_once('/customers/4/6/...') #3 {main} thrown in /customers/4/6/2/portuk.com/httpd.www/fa/includes/errors.inc on line 85

2. If installation has to be done on certain php version for 2.4.4 to work, can I change the version to php7.2 (in web hosting) and then install 2.4.4 as mentioned in steps above by @kvvaradha's post 2 ???

3. If I follow steps in post 2 above to install a fresh copy of 2.4.4 and then use backup to restore data from 2.4.2 production, do I need to use the same database that I have used in 2.4.2 ? Or can I create and use a new database for 2.4.4 installation and still use backup file from 2.4.2 ?

I would be really grateful if someone could help me with above.

Thanking you all
GJ

05/29/2018 08:32:58 pm

Hello,

Just wondering if there is a way to jump from 2.4.2 to 2.4.4 directly ?

I really don't have courage to install everything from fresh, especially when it comes to loading all items, customers, suppliers and so on.

I would be thankful if someone could direct me with what files needs updating.

Thank you,
GJ

apmuthu wrote:

The set of files that can be used to overwrite their counterparts in an existing FA 2.4.2 installation to update it to FA 2.4.3 is attached herewith.
Tamil, Hindi and Arabic languages stand fully translated in the FA24extensions repo.
Tamil, Hindi and Arabic have their install wizards fully translated too in my repo.
See this post for details and downloads.
Post release commits are listed here.
Anyone upgrading from FA 2.4.2 to this version will need to manually apply the database fixes to every company as detailed in this post.

05/26/2018 09:59:12 am

Hello,
Thank you for your valuable input as always.

Seems I had allocated payment to this order and also done a "invoice against delivery" for this order instead of 'invoice prepaid order" option.

So it was showing outstanding though the delivery was made.

But having cancelled the 'invoice against delivery' and after processing 'invoice prepaid order' the problem has been resolved.

Though I have another issue going on now.

When I try to print the invoices for customer via reports, this one prepaid order is showing on each invoice of theirs, instead of the invoice for which the prepayment was received.

It seems a minor glitch but this has also stopped showing all the invoices.

When I try to see all the invoices of all customers, I can only see invoices from 1st (latest invoice) to the invoice which has this prepaid orders). The invoices before these prepaid orders dont' show in the pdf file which gets generated.

05/16/2018 10:18:28 pm

Hi all,

I might be bit slow in updating my version so please ignore that.

I am still using the 2.4.2 version and believe it has been most stable for me in terms or implementing.

But, in my live version I have a sales order ( prepayment order), which never materialized and so I want to cancel it.

In normal case I just go to Sales/Inquiries and Reports/Sales Order Inquiry and then select the order to edit via a little pencil icon which is next to printer icon, and open the sales order in edit mode and simply cancel it.

For this particular sales order I am do not get any option to edit it ( pencil has disappered).

I haven't allocated any payment to it and even in the customer allocations it is pending for allocation of payment.

Is there any way to get rid of this by cancelling this order ?

Any help would be appreciated.

Thank you,
GJ

12/03/2017 12:24:36 am

Hello,

Just wondering if there has been any progress on this tax reporting ?

I am writing with regards to the display of zero tax which relates to sales/purchases to/from an EU country to another EU country.

And in my particular case, where I don't see any sales invoices which have zero (export)tax.

Is there a way to display these within tax reports, or tax inquiry ?

I am still on version 2.4.2 but don't see any sales or purchase invoices which have 0% tax.

Any update would be great great help.

joe wrote:

I am not sure about the details. Janusz has changed a lot here.
The zero tax values are important inside EU countries to track the outputs/inputs for non taxed values.
Joe

11/28/2017 09:28:23 pm

Hello ApMuthu,

Thank you for keeping track of so many things.
I got bit busy with the daily work on business in my 2.4.2 version, which I have implement for running accounts.
But I've been reading the posts and updates and so thank you very much for including point 7 above, along with everything else.

I am hoping to switch to 2.4.3 once few of the below are updated, and I hope I can do that using your post which suggests copying the new files from 2.4.3 to older 2.4.2 installation directly.

Regards and thanks
GJ

11/09/2017 12:52:44 pm

Hello,

Have you looked at quick entries?

I have done something similar to what you are looking for using quick entries for vat on items acquired from EU, where I have to pay local vat on these items.

11/08/2017 04:33:10 pm

ha ha ha...

seems this feature is right at the bottom of wish list...

11/06/2017 10:38:05 pm

Hi,

I completely agree with you but at times a few of my clients request sales order so that they can make remittance on basis of this document.

When above is the case, I have to close a sales order and then cannot edit it as that is exactly how my delivery note and sales invoice would look like, which goes with the export documentation for customs purpose.

When above happens, I am not able to use sales order to add more items, and bunch them for delivery.

I agree, it might not be as useful to everyone, but if at all it is a easy fix, considering there are no implications to GL entries, it would be a good option.

11/03/2017 01:13:38 pm

Hi barbarian,

Did you mean the point about adding to sales order or the option of 'batch delivery' ??
If it is about batch delivery it would be great, though I get the add-on free for giving the idea :d

Also, thinking about what apmuthu said before, if sales orders don't actually make any changes or entries to GL accounts, won't it be easier to implement this feature as compared to batch invoice already available?

11/02/2017 11:27:22 pm

Exactly what I've been doing...

Though I have to say, batch deliveries would definitely be a great feature.

Having tried sage/intuit/xero FA has beaten them all in my needs, so I can't be greedy, but us humans always want more and more and more....

apmuthu wrote:

You're right, you deliver per Sales Order.
Multiple Sales Orders cannot be bunched to a single Delivery in FA as on date.
Since Sales Orders generally do not affect many tables, it might be better to just edit an existing Sales Order and keep adding to it - saves time creating separate Sales Orders.

11/02/2017 07:05:49 am

Hello,

I tried doing step 2a, but I don't get an option to combine multiple sales orders in to single delivery.

I am aware of 2b clubbing deliveries in to single invoice, but not able to club multiple sales orders in to single delivery.

11/02/2017 07:02:43 am

Hi Joe,

I am aware of above and used it too but, what I meant to ask was if there is an option to batch multiple deliveries together if I had several sales orders ?

11/01/2017 10:13:07 pm

Hello Joe,

Seems there is something I am missing or not finding in latest v2.4.2

Is there an option to 'batch deliveries' ??

Please let me know as this would be a blessing.

11/01/2017 10:09:23 pm

Hello,

Just wondering if this point was ever taken on ?

I personally experience this a lot, where customer places different orders over period of days and then wants a single shipment of all the items.

It becomes problematic as to do single delivery, I'll have to cancel previous quotes/sales orders and create new one with all the items in single quote/sales order, and then process the delivery.

Just like batch invoice, a 'batch delivery' where we could club deliveries for same customer would be a great addition.

I hope this is possible.

Regards,
Gj

11/01/2017 08:50:58 pm

hey hey, seems my mischief has made @apmuthu give some tips for dummies... thank you

Search options (Page 2 of 4)

Posts found: 26 to 50 of 79

26 Reply by gj6n68 11/14/2018 09:43:19 pm

Re: Upgrade from 2.4.2 to 2.4.4 (20 replies, posted in Setup)

27 Reply by gj6n68 10/25/2018 09:47:26 pm

Re: Making Tax Digital VAT in UK and EEC (27 replies, posted in Setup)

28 Reply by gj6n68 10/25/2018 09:45:25 pm

Re: Upgrade from 2.4.2 to 2.4.4 (20 replies, posted in Setup)

29 Reply by gj6n68 10/22/2018 08:37:35 pm

Re: Making Tax Digital VAT in UK and EEC (27 replies, posted in Setup)

30 Reply by gj6n68 10/22/2018 08:06:45 pm

Re: Upgrade from 2.4.2 to 2.4.4 (20 replies, posted in Setup)

31 Reply by gj6n68 10/19/2018 07:56:12 pm

Re: Upgrade from 2.4.2 to 2.4.4 (20 replies, posted in Setup)

32 Reply by gj6n68 10/19/2018 07:45:19 pm

Re: Upgrade from 2.4.2 to 2.4.4 (20 replies, posted in Setup)

33 Reply by gj6n68 10/19/2018 01:50:44 pm

Re: Upgrade from 2.4.2 to 2.4.4 (20 replies, posted in Setup)

34 Reply by gj6n68 10/19/2018 10:04:01 am

Re: Upgrade from 2.4.2 to 2.4.4 (20 replies, posted in Setup)

35 Reply by gj6n68 10/18/2018 10:06:42 pm

Re: Upgrade from 2.4.2 to 2.4.4 (20 replies, posted in Setup)

36 Reply by gj6n68 05/29/2018 08:32:58 pm

Re: Release 2.4.3 (9 replies, posted in Announcements)

37 Reply by gj6n68 05/26/2018 09:59:12 am

Re: Unable to cancel a sales order (5 replies, posted in Accounts Receivable)

38 Topic by gj6n68 05/16/2018 10:18:28 pm

Topic: Unable to cancel a sales order (5 replies, posted in Accounts Receivable)

39 Reply by gj6n68 12/03/2017 12:24:36 am

Re: Tax Inquiry - Tax not showing (18 replies, posted in Reporting)

40 Reply by gj6n68 11/28/2017 09:28:23 pm

Re: Release 2.4.3 (9 replies, posted in Announcements)

41 Reply by gj6n68 11/09/2017 12:52:44 pm

Re: Withholded tax deduction at PURCHASE transactions (13 replies, posted in Accounts Payable)

42 Reply by gj6n68 11/08/2017 04:33:10 pm

Re: Batch delivery desired (12 replies, posted in Wish List)

43 Reply by gj6n68 11/06/2017 10:38:05 pm

Re: Batch delivery desired (12 replies, posted in Wish List)

44 Reply by gj6n68 11/03/2017 01:13:38 pm

Re: Batch delivery desired (12 replies, posted in Wish List)

45 Reply by gj6n68 11/02/2017 11:27:22 pm

Re: Batch delivery desired (12 replies, posted in Wish List)

46 Reply by gj6n68 11/02/2017 07:05:49 am

Re: Batch delivery desired (12 replies, posted in Wish List)

47 Reply by gj6n68 11/02/2017 07:02:43 am

Re: Multiple Delivery Note ... (9 replies, posted in Accounts Receivable)

48 Reply by gj6n68 11/01/2017 10:13:07 pm

Re: Multiple Delivery Note ... (9 replies, posted in Accounts Receivable)

49 Reply by gj6n68 11/01/2017 10:09:23 pm

Re: Batch delivery desired (12 replies, posted in Wish List)

50 Reply by gj6n68 11/01/2017 08:50:58 pm

Re: Download specific folder from GitHub (3 replies, posted in Setup)

Posts found: 26 to 50 of 79