5,551 Reply by apmuthu

(4 replies, posted in Accounts Receivable)

Use phpmyadmin and check the tables manually. Alternatively, in FA, take a mysql dump (backup) and edit it and upload and restore.

Go to forum: Accounts Receivable

5,552 Reply by apmuthu

(6 replies, posted in Banking and General Ledger)

Very easy!
Place network printers in each location and turn on CUPS-BSD Printing and set it in each user's profile.
Keep one or more userids for each location if needed so that the profile of the printers and stationery can be stored.

Keep Dimensions as the Branches.

Just one company install is sufficient.

One user login can see all the branches.

Filter by Dimension (branches) for branch transactions.

Specific set of transactions across locations can be bunched together using Tags. Example will be one supplier supplying goods to more than one location to be bunched together for evaluating average cost of his supply alone and then making payment across all supplies.

Go to forum: Banking and General Ledger

5,553 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,554 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,555 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,556 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,557 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,558 Reply by apmuthu

(4 replies, posted in Banking and General Ledger)

Wikied it.

Go to forum: Banking and General Ledger

5,559 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,560 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,561 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,562 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,563 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,564 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,565 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,566 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,567 Reply by apmuthu

(3 replies, posted in Reporting)

Wikied it.

Go to forum: Reporting

5,568 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,569 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,570 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,571 Reply by apmuthu

(3 replies, posted in Setup)

Any Extension available for it now?

Go to forum: Setup

5,572 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,573 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,574 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,575 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