5,576

(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.

5,577

(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!

5,578

(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

5,579

(3 replies, posted in Setup)

Any Extension available for it now?

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.

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.

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

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.

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.

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.

5,586

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

RepGen Extension v2.3.9-3 has been updated to v2.3.13-1 in my personal GitHub repo.

Thanks Joe. HG 3122 did the job.

5,588

(3 replies, posted in Installation)

In the config.php file, set:

$text_company_selection  = true;

5,589

(5 replies, posted in Translations)

Updated Wiki at:
https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages

5,590

(4 replies, posted in Announcements)

Thanks Janusz.
Now we can take snapshots at will.
Please update the git/hg with the missing rep308.php file

5,591

(8 replies, posted in Setup)

Review transactions in each company and take action (contra to revert) even if they stand posted in real time.
Each branch can be a profit centre - Use Dimensions / Tags

5,592

(4 replies, posted in FA Modifications)

Dimensions and Tags may solve your issues.

Otherwise, a federated table structure may help outside of FA.

Creating UNIONised VIEWS (with apporpiately prefixed primary keys) of corresponding tables from all companies into a read-only consolidated virtual company's database will enable FA to do what you want.

It will work in current PHP v5.3.x - maybe specific early versions in PHP 5.3.x may be broken.

Just remove the .htaccess file and see if it works - then fix the .htaccess settings to match your hosting provider.

Quite a few DB changes have been done and older variables may be deprecated. Check out the apache error log and see what gives.

5,595

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

The account numbers for the Journal Entries are hardcoded in inventory.inc - lines 321-323 are:

             // TODO Obtener cuentas contra las cuales hacer asientos
             $_SESSION['gl_items']->add_gl_item('1510', 0, 0, ($info['quantity']*$info['standard_cost']*-1), $info['memo']); // Cta de Inventario del Producto
             $_SESSION['gl_items']->add_gl_item('4010', 0, 0, ($info['quantity']*$info['standard_cost']), $info['memo']); // Cta Configurada para Obsolteos, Propios, etc ...

The comments are in Spanish - Please make it in English.

5,596

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

Please use the SimpleAPIModule.

5,597

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

@andresamayadiaz:
Your recent GitHub change has an error in line 14 of inventory.inc:

include_once($path_to_root . "/gl/includes/dl_db.inc"); 

should be

include_once($path_to_root . "/gl/includes/gl_db.inc"); 

The included file name is gl_db.inc and not dl_db.inc

To save us the trouble, please list a set of URLs that you would use to achieve all of this along with the original source URL for the invoice. That way we can build the URL with the variables needed and put it in the invoice page.

Looks like the FA team has not yet returned from the Easter holidays as a few of the bugfixes (2172, 2183) in the Bugtracker have yet to find their way into the code base.

5,599

(8 replies, posted in Setup)

AFAIK FA has real time posting and real time import (using addon).

Batch upload and review before posting is a nice feature - do not know if FA can accomodate it in the current version.

Possible Workaround:

  • Take backup

  • Do real time batch import

  • Check the registers and printouts

  • If found to need major record level corrections, then edit in the import source file

  • Restore from earlier backup

  • Re-import after corrections.

5,600

(8 replies, posted in Setup)

Why do you need to switch at all?
Just keep it real time and post batch realtime as well.