1 Reply by gj6n68

(2 replies, posted in Report Bugs here)

Hi,
I am trying to solve a similar description related issue in Delivery Note printing, if I understand the descritpion details is not available in rep110.

I tried using the below code lines from Quote 9 (rep109)  and Sales Invoice (rep111) templates in Delivery Note (rep110) but no real success so far, and description details not visible on printed/pdf Sales Order.

if (!empty($SysPrefs->prefs['long_description_invoice']) && !empty($myrow2['long_description']))
$rep->TextColLines(1, 2, $myrow2['long_description'], -2);

Any help would be appreciated.

Go to forum: Report Bugs here

2 Reply by gj6n68

(3 replies, posted in Banking and General Ledger)

Thanks a lot advocaat.pollet,

I'll go through the details and I hope it resolves my simple query, which was working fine until last few updates.

Thanks once again.

Go to forum: Banking and General Ledger

3 Reply by gj6n68

(3 replies, posted in Banking and General Ledger)

Hello team,

Anyone else facing this issue ?

Where the tax reports don't list all the supplier/sales invoice where taxes are zero % ?

Any workaround on this one issue to display all entries with any rate of taxes ??

This is required for VAT submissions and right now we are under pressure to not report wrong numbers along with lot of manual checks to make sure everything is correct.

Another bug I found is that any journal entries which have vat entry in it are not being collected by tax report.

Go to forum: Banking and General Ledger

4 Topic by gj6n68

(3 replies, posted in Banking and General Ledger)

Hi all,

Sorry to create a new post but it seems most topics on the tax reports have been locked down and not sure if they've been fully resolved, I say this because there was a working soclution which seems to have disappered in recent relesases.

I did try to follow up here  But, not update.

Then here but, again no update.

Not sure if there has been a solution to this which I haven't found on the forum but, I would really be grateful as it helps most of us working from EU to file our VAT correct.

@Joe, I believe a previous version of rep709 did list out all the taxes including the ones which were created with 0% in 'taxes' and included/exempted in tax group/items respectively.

For taxes to appear on the report you had to not select them in the 'tax group', though the 0% tax was created in 'taxes'

I hope someone points me to a solution if already discussed.

Currently I only get Supplier invoices which are all taxed at 20%.
My sales invoices which are zero rates don't show up at all.
I have setup all the taxes correctly, even the 0% one and assigned it to relevant customers.

(edit)Another bug in the tax report is when the vat entries as posted via journal entry feature. If a business bought something and wants to expense it using journal entry, the vat amount entered in this entry is not captured within tax reporting, effectively missing out on vat savings. This was never reported in any version of rep709 from my memory.

Having made this work before it is more frustating to lose the solution.

Go to forum: Banking and General Ledger

5 Reply by gj6n68

(6 replies, posted in Reporting)

Hi,

I am not sure if it is me facing this issue or it is a bug.

I did a massive upgrade from 2.4.8 to 2.4.12 and since then I haven't been able to generate the tax repots which include "zero rated tax line"

Looking at the reports 107 and 709 I can see there has been some changes but, not sure if we have lost the ability to include the zero rated transactions.

A similar topic was discussed on this thread but, it is locked now so had to post a new question.

Go to forum: Reporting

6 Reply by gj6n68

(12 replies, posted in Reporting)

Hi,

Thanks for this code.

I am trying to replicate the same on a Delivery Note but not able to see the results.

Also I noticed that in Delivery Note Report 109, there is a field called stk_code where as report 107 has field stock_id.

Not sure if that could cause issue.

Any help would be greatly appreciated.
Regards,
gj


harshadmwasule wrote:

Dear all,
I made following changes to sales/includes/db/sales_order_db.inc (line 285)

        line.description AS StockDescription,
        item.long_description AS StockLongDescription,
               
and added following code in rep111

          if (!empty($SysPrefs->prefs['long_description_invoice']) && !empty($myrow2['StockLongDescription']))
          {
            $c--;
            $rep->TextColLines($c++, $c, $myrow2['StockLongDescription'], -2);
          }

it solved my concern

Thanks

Go to forum: Reporting

7 Reply by gj6n68

(4 replies, posted in Reporting)

Hi,

For no. 7 you need to tweak the details within "Setup \ Transaction References"

popsicles12 wrote:

Good day All,

Kudos to Joe and crew that has made FA what it is today. Excellent job you've done so far.

I needed help for modification of some things in FA to make it flexible in use.

1. Once an invoice is raised, I cant modify the price. sometimes prices are entered and later i may decide to reduce price. But I cant in FA.
2. In my Invoice I need these to appear in my report: Total Price, Amount Paid and Balance. even though I have receipt to that effect.
3. I needed the Invoice body to be extended more to accommodate more lines of items and if possible remove somethings at the bottom.
4. I need to add a Place for Customer Signature & Company Signature
5. I need to remove the Column for the Item code so the description is clearly show instead of it looking clumsy.
6. I also want to remove the ship to address in the Invoice, Receipt and Sales Order
7. I also need auto numbering for both invoice and Sales Order.

Please kindly assist as this is very important to our day to day transaction.

Thanks in advance.

Popsicles12

Go to forum: Reporting

8 Reply by gj6n68

(5 replies, posted in Accounts Receivable)

apmuthu wrote:

@joe: any filters in the sql(s) that are needed to be tweaked?

Hello @Joe,

Have you had a chance to look in to this please ?
I know it is old but now I have two such sales orders.

Hope it is something minor.

Thanks,
GJ

Go to forum: Accounts Receivable

9 Reply by gj6n68

(27 replies, posted in Setup)

Hello all,

I was just looking at the post from @apmuthu about the number of downloads (link below) and it seems UK has one of the high numbers of downloads(and I believe users) who all eventually might need VAT MTD module.

https://sourceforge.net/projects/frontaccounting/files/stats/map?dates=2020-02-04+to+2020-02-06

I see that a number of us started the discussion but, not sure how far we got. I am not tech minded but more than happy to help develop a module which could benefit all. I can definitely help in terms of VAT related calculations etc and little bit of coding.

Hope to hear soon.

Regards,
GJ

Go to forum: Setup

10 Reply by gj6n68

(29 replies, posted in Installation)

apmuthu wrote:

Also check the contents of the installed_extensions.php in both the FA webroot and in the company folders.


Hi,
please see the code from my file  below

$next_extension_id = 46; // unique id for next installed extension

$installed_extensions = array (
  1 => 
  array (
    'name' => 'British COA',
    'package' => 'chart_en_GB-general',
    'version' => '2.4.1-5',
    'type' => 'chart',
    'active' => false,
    'path' => 'sql',
    'sql' => 'en_GB-general.sql',
  ),
  45 => 
  array (
    'name' => 'Inventory Items CSV Import',
    'package' => 'import_items',
    'version' => '2.4.0-3',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/import_items',
  ),
);

If I make 'active => true' would it solve the problem of extension not being visible ?

Go to forum: Installation

11 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

And how is the clean installation?
To clarify:-

You only have to create a clean install of FA2.44 with default COA and language etc
You only need to prove that install ext's works or do not work on the new clean installation.

I'll try a separate fresh install tomorrow, and see if that solves the problem.

Thanks

Go to forum: Installation

12 Reply by gj6n68

(3 replies, posted in Accounts Payable)

You are master of this system. Thank you.

Any chances we could have the sequence in from : start from the 1st/oldest PO rather than the latest ?

Go to forum: Accounts Payable

13 Reply by gj6n68

(29 replies, posted in Installation)

Hi,
I am with one.com and have lowered my php version to 5.6, but they've just confirmed that they do no allow CGI on their servers.

Go to forum: Installation

14 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

Try lowering your php version


Hi,

Just done that after your msg and also when I read about it at below post:
https://frontaccounting.com/punbb/viewt … 199#p33199

Any idea how can I implement this CGI thing ? Do I need to speak to my host provider for it ?

Go to forum: Installation

15 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

No delete them using the red cross in 'Installed Extentions' after first deactivating them.

To prove your server, do a clean install of 2.4 and try installing extentions.


Hi,

I have deleted them as above many times and tried reinstalling but no change.

I would have done a fresh install but because this is production version for my company and I really do not want to take the risk.

In the /tmp/folder I see loads of .pkg files for extensions,  including the one I want. Should I delete them ? And try again ?
Below is the lastest error I get in error file.

function count_array().
[17-Nov-2018 14:27:36 UTC] 0:admin:maintenance_db.inc:186: Unhandled exception [0]: Call to undefined

I had changed "count()" to "count_array" as I got this error while trying to install 2.4.4 on 7.2 php.

Go to forum: Installation

16 Reply by gj6n68

(29 replies, posted in Installation)

Hello,

poncho1234 wrote:

Try deleting them completely and then re-installing, make sure you have debug on. This may give you more information when you install/activate exts.

Do you mean, delete them by deactivating them ?
Or delete them from ftp ?

Is your server setup with the necessary permisions?

I don't know where to check this as I am using the installation via web hosting services.

Go to forum: Installation

17 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

How many companies have you installed?

Are you logged on to the same company you have activated the ext's for?

Hi,

I have two companies, one is master one which controls every other company.

I have tried installing and activating the extensions on both the companies but I can't see them in either of them.

I've also checked access rights in both the companies, but I don't get emtpy tick boxes in either to tick the extensions.

Go to forum: Installation

18 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

???

But can you see the reports by going to  - Banking and General Ledger -> General Ledger Reports

Try to deactivate and then activate again

And send a screen shot of access role with system admin...you may have to take 2 or 3

Hi,

Please see below images at below location.

https://drive.google.com/drive/folders/ … sp=sharing

I've tried removing, installing, removing a few times.
Even tried removing relevant folders from /modules/ via filezilla, but no change.

But, I can see "Annual Expense Breakdown" now in General Ledger reports.

This is driving me crazy now.

Go to forum: Installation

19 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

As stated the two reports do not require additional access,

do you have access to the two reports? You should see the two reports by going to  - Banking and General Ledger -> General Ledger Reports


Hi,

I understand but I don't have access to these 2 either unfortunately.

Go to forum: Installation

20 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

Ok, nothing seems to be wrong there.

You are logged into the company that you have activated them for?

The two reports do not require additional access, as long as you have access to "GL analytical reports and inquiries" in access levels

You should see the two reports by going to  - Banking and General Ledger -> General Ledger Reports

The 'import items' ext does require additional access rights, you should see... 'Import CSV Items' tick the box and another box will appear labelled the same 'Import CSV Items' save role and you should see a new menu item in 'Items & Inventory'

I completely agree with you and have used it exactly as you mentioned in 2.4.2, but since I upgraded to 2.4.4 I don't see the options under user access where you tick the boxes for new extension.

Not sure what is wrong with my installation or extensions, but I have done everything like before and mentioned above, but I can't see those extensions in user access.

Go to forum: Installation

21 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

??? imgur is free and post link on here

or

as I wrote list the contents of the dir /modules/


Hi,
Please see images below:

https://drive.google.com/file/d/17pAirET0T7vfjMQXupscb8YrQd4jGRBR/view?usp=sharing

https://drive.google.com/file/d/1cPv8cua22Rv9xQng21CCIDQiEhZG7y2P/view?usp=sharing

The contents of the \modules\ are as below:


index.php
rep_annual_expense_breakdown
rep_annual_balance_breakdown
_cache
import_items

Thanks a lot

Go to forum: Installation

22 Topic by gj6n68

(3 replies, posted in Accounts Payable)

Hi all,

Not sure if this is a bug or something which is not supposed to happen so pardon me if I am wasting time.

I am using to printing multiple invoices via Sales/Inquiries and Reports/Customer and Sales Reports/Print Invoices

Here we have option to select all the invoices we want to print and we can generate a long pdf file.

But if I try to do the same within Purchases/Supplier and Purchasing Reports/Print Purchase Orders , I can select one PO and see the pdf file. The moment I select 2 or more POs for printing I get 1 blank pdf file.
Is this a bug ?

And while we are talking about this particular aspect, I would also like to point out that it would be great if we could have a filter here to select a particular supplier and print only their POs. There is such option available in sales invoice printing, where we can select a particular client and print all their invoices.

Hope to iron this out soon.

Thanks

Go to forum: Accounts Payable

23 Reply by gj6n68

(29 replies, posted in Installation)

poncho1234 wrote:

Hi, can you send a screenshot of installed extensions page please or list the dir contents of /modules/

Hello,
I think you are online, and so was trying to put some screenshots here.
But, how do I attach photos, never thought I won't have permission for that.

Go to forum: Installation

24 Reply by gj6n68

(29 replies, posted in Installation)

kvvaradha wrote:

You need to provide page permission to your login.   

Here is the procedure to provide it.

Goto Setup ->Access setup

Here select " Your role (System Administrator as main login access).  and scroll to end and there are some checkboxes, check them all. Each main checkbox will show some more by extending the list.

check them all and click "Save Role" 

Than logout and login again. You can able to access those pages.


Hello,

Having tried above all, I am just wondering is there anything else I can look at ?

I can install/activate the extensions, but I don't see them at all when I try to edit 'system administrator' role and tick the boxes.

I've done the process on 2.4.2 but I just don't see them at all, even after activating them for relevant companies etc.

Thanks in advance.

Go to forum: Installation

25 Reply by gj6n68

(20 replies, posted in Setup)

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.

Go to forum: Setup