5,501 Reply by apmuthu

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

@elax: You are right. It should be configurable to be either on a separate tab or in each tab. depending on bandwidth, latency and size of recordset the enduser should make an intelligent choice and I would hard code it to be on a separate tab anyway. Please provide patch for hardcoding it on a separate tab and / or making it configurable.

Go to forum: Modules Add-on's

5,502 Reply by apmuthu

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

It appears that it is the intended functionality to remove the Menu Tab.

Quote from forum post:

There was a dashboard tab in an early iteration because the module adds a new application to FA. It is hidden by the dashboard theme render module (~/themes/dashboard/renderer.php). Originally, only the dashboard tab displayed widgets, but by moving the menu to the side, it made more sense to make every application tab a dashboard and hide the dashboard tab itself. I forgot to hide it from the application list in the dashboard set up form.

Go to forum: Modules Add-on's

5,503 Reply by apmuthu

(6 replies, posted in Banking and General Ledger)

Are the Businesses separate companies or profit centres?
Should any employee be able to make entries in more than one location?

The Dimensions / Tags feature of FA should see you thru.

Inventory / Customers / Transactions - must they be viewable and accessible by all? Do they share the same stationery? TimeZone? Currencies?

Federated databases in MySQL can be used with dummy views in one non-transactional install of FA can appear to mimic the subsidiary concept.

You can choose to keep all of them as separate entities and view them all from one location - single FA install with multiple companies and one browser interface with separate logins.

Go to forum: Banking and General Ledger

5,504 Topic by apmuthu

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

In the Module/Theme Dashboard, what does the reminder do?

Neither the table nor the form have any action name to be performed at each chosen interval.

The readme.txt file states for Reminder:

This shows a list of tasks that you can maintain by user role, with a date required and frequency. Go to Setup, Reminder Setup to define the reminder tasks for all roles. For each user, the reminder widget displays the outstanding tasks, with overdue tasks shown in red, today's tasks in blue and future tasks in black. When the user clicks on the task actioned check box, the next date for the task will be set according to it's defined frequency, and it is removed from the user's reminder list.

Go to forum: Modules Add-on's

5,505 Topic by apmuthu

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

Latest Dashboard theme and module installed and activated from the fa repo does not seem to have a menu tab for itself as was available earlier and shown in the wiki.

The current hg 3227 version shows it as in the attachment

Since the Dashboard Menu tab's contents like Dashboard Setup and Reminder Setup are now in the Miscellaneous Submenu of the Setup Menu, has the Menu Tab been dispensed with?

The company/*/js_cache had been flushed and the browser restarted on fresh login to no avail.

Is this because the Line 18 in modules/dashboard/dashboard.php is commented out (line 9-20):

class dashboard_app extends application
{
    var $widgets;
    var $apps;

    function dashboard_app()
    {
        $this->application("Dashboard", _($this->help_context = "&Dashboard"));

        //$this->add_module(_("Dashboard"));
        $this->widgets = array();
        $this->add_extensions();

This is so even though the lines 12-21 that call it in modules/dashboard/hooks.php are:

class hooks_dashboard extends hooks {
    var $module_name = 'dashboard';

    /*
        Install additonal menu options provided by module
    */
    function install_tabs($app) {

        $app->add_application(new dashboard_app);
    }

Go to forum: Modules Add-on's

5,506 Reply by apmuthu

(4 replies, posted in Banking and General Ledger)

Wikied it.

Go to forum: Banking and General Ledger

5,507 Reply by apmuthu

(9 replies, posted in Wish List)

Other than Report and Trial balance, the others should be okay.

Go to forum: Wish List

5,508 Topic by apmuthu

(1 replies, posted in Installation)

@Janusz: HG 3227 - Ignore hook system in installer. - Please throw some light on what this actually does and what error and where it occurs if not used. Does it change existing installs or merely avoids the hooks during the initial run of the FA install routine when no database had yet been chosen?

Go to forum: Installation

5,509 Reply by apmuthu

(4 replies, posted in Banking and General Ledger)

@AlastairR: Can you publish the format for your country that does work? Can update it on the wiki as well then so that the hardcoded format can someday become softcoded.

Go to forum: Banking and General Ledger

5,510 Reply by apmuthu

(4 replies, posted in Accounts Receivable)

Are you using the admin user for the second company or is it a less privileged user - if so - setup the roles and permissions for the said user.

Go to forum: Accounts Receivable

5,511 Reply by apmuthu

(1 replies, posted in FA Modifications)

Very nice workflow - setting flags and then remembering to uncheck them gets us wrong most of the time - like forgetting to take tablets!

Go to forum: FA Modifications

5,512 Reply by apmuthu

(9 replies, posted in Wish List)

If you can provide individual patches for each suggested feature with order of patch application, it might be easy for Joe/Janusz to incorporate them.
Alternatively, fork from either the original Git or my GitHub repo and make a branch for yourself and a branch for each feature arising out of the master and update the code base to reflect the real HG default. Then merge the changes to your personal branch whilst restricting merging with the master till the main code base is updated with it.
That way you will be able to maintain your personal branch and merge in cherry-pick mode - I'm still learning the ropes with a more evolved project that OpenEMR is in this regard.

Go to forum: Wish List

5,513 Reply by apmuthu

(11 replies, posted in Banking and General Ledger)

There is an Item Sales Summary Report in the addon extensions and a standard Customer wise sales summary report in the core.

Check the wiki - Reports and Analysis
https://frontaccounting.com/fawiki/index.php?n=Help.ReportsAndAnalysis

@Joe - please clean up the Wiki Sidebar and place Reports and Analysis on it as well.

Go to forum: Banking and General Ledger

5,514 Reply by apmuthu

(6 replies, posted in Accounts Receivable)

A side note for standardisation:

The file reporting/includes/reporting.inc defines function print_link() that is called by function print_document_link() also in the same file.

The function print_document_link() is called in quite a few files, but the print_link() function is directly called from only these other files:

  • manufacturing/work_order_add_finished.php

  • manufacturing/work_order_entry.php

  • sales/create_recurrent_invoices.php

Go to forum: Accounts Receivable

5,515 Reply by apmuthu

(3 replies, posted in Reporting)

Wikied it.

Go to forum: Reporting

5,516 Reply by apmuthu

(6 replies, posted in Setup)

Set up donation as a service entry with zero tax.
Service items are "sold" with no inventory.
Recurring donations can also be taken care of with recurring invoices "selling" such service items.

Go to forum: Setup

5,517 Reply by apmuthu

(2 replies, posted in Reporting)

It appears that the rep308.php should be the way it is in HG 3224.

This is so because the class variable $headers2 displays first and then the class variable $headers is displayed in the class method FrontReport::Info() in pdf_reports.inc lines 358-367:

        if ($this->headers2 != null)
        {
            $count = count($this->headers2);
            for ($i = 0; $i < $count; $i++)
                $this->TextCol2($i, $i + 1,    $this->headers2[$i]);
            $this->NewLine();
        }
        $count = count($this->headers);
        for ($i = 0; $i < $count; $i++)
            $this->TextCol($i, $i + 1, $this->headers[$i]);

Some involuted logic in the FrontReport class method Info() indeed!

Go to forum: Reporting

5,518 Reply by apmuthu

(2 replies, posted in Reporting)

Thanks for the updated version now in the FA Core as of HG 3224.

Line 164 in rep308.php:

    $rep->Info($params, $cols, $headers2, $aligns, $cols, $headers, $aligns);

should be:

    $rep->Info($params, $cols, $headers, $aligns, $cols, $headers2, $aligns);

The $headers and $headers2 variables got swapped.

function Info is defined in reporting/includes/pdf_report.inc as

 function Info($params, $cols, $headers, $aligns,
  $cols2 = null, $headers2 = null, $aligns2 = null,
  $companylogoenable = false, $footerenable = false, $footertext = '')

A new string is needed in empty.po:

C&osted Inventory Movement Report

Go to forum: Reporting

5,519 Reply by apmuthu

(3 replies, posted in Setup)

Any Extension available for it now?

Go to forum: Setup

5,520 Reply by apmuthu

(11 replies, posted in Accounts Receivable)

Actually, FA has been good with common base workflow for the PC. Now that other small screen and touch centric devices have become commonplace, the UI will evolve.

Go to forum: Accounts Receivable

5,521 Topic by apmuthu

(2 replies, posted in Reporting)

The erstwhile rep_stock_movement extension for FA has Standard Costs as one of the parameters in the SQL and material cost was computed in it. When the extension was merged into the FA core as rep307.php on 2013-01-24, the Standard Material Costs got left out due to paucity of space on the standard A4 and Letter paper sizes and was called Inventory Movement Report.

Another report, rep308.php was made by Janusz/Joe around the same time but was not included in the FA core. Attached herewith is the improved version which is fully functional:

1. Commented out hardcoding of $orientation.
2. Retained UOM (units).
3. Moved extra function below regular function just as in rep307.php
4. Adjusted the indent values of the displayed fields - set for A4 but should work for Letter as well.
5. Ordered the report ids in the reports_main.php

Kindly include it in the FA Core. I have named it Costed Inventory Movement Report for now.

Go to forum: Reporting

5,522 Reply by apmuthu

(1 replies, posted in Banking and General Ledger)

Google Translated:

Hello,

I wonder if FA may be legally used in France and if not why.
I recall that 10 years ago, for example Excel could not be officially used, because it can delete / modify rows in the ledger that was not legal. Is this still the case?

I do not live in France, so I'm asking more out of curiosity than necessity (and I have the time, not necessary contacts).

thank you

Go to forum: Banking and General Ledger

5,523 Reply by apmuthu

(5 replies, posted in Misc. Charts of Accounts)

You can install chart of accounts even after installing FA. The newly installed COAs can be used in subsequent creation of companies. All this can of course be done only from the Setup /Create Company Menu in the Default / Main Company (generally 0) only.

Go to forum: Misc. Charts of Accounts

5,524 Reply by apmuthu

(11 replies, posted in Accounts Receivable)

Attached your screenshot herein.

Since the Invoice Date is part of the Invoice No., either the Invoice Date field can be dropped or the date prefix in the Invoice No. be removed.

The Status field is to be numbered 6 in your list above.
Nos. 6 to 16 in your list above are to be Nos. 7 to 17.

The View Icon (No. 10) can be removed and the link provided in the Invoice No. Field itself.

You can generate the said page using the one page script from Adminer, or use the commercial HKVStore / XLineSoft products. The final product can be made into an extension for use in FA.

What application did you use to obtain the screenshot's underlying data layout?

Alternatively, all the icons can be replaced with a single drop down box and the checkboxes at the left of the records can become radio buttons to feed the parameters to the URL generated by selecting the action.

Go to forum: Accounts Receivable

5,525 Reply by apmuthu

(3 replies, posted in Installation)

Create the FA installs locally in each POS machine with the same SQL as in the online one. Then change the Reference Nos to be an unique prefix in each Setup->Forms Setup.

Now arrange to export the local db changes to the remote one filtered for the local prefix. This can be done with a php script linked to a "single click button" on the local POS install. This ofcourse assumes that there are no file uploads / documents in the local install that may have been changed.

Go to forum: Installation