5,651

(6 replies, posted in FA Modifications)

Updated the Wiki with a HOWTO for manual install and language extension creation. An offline PDF version is also available.

Attached the en_IN package for inclusion in the FA Repo.

Edit the lang/installed_languages.inc file and include the following array element into the $installed_languages array (take care of the array index assumed 1 here):

  1 => 
  array (
    'code' => 'en_IN',
    'name' => 'English (IN)',
    'package' => 'en_IN',
    'encoding' => 'iso-8859-1',
    'version' => '2.3.15-1',
    'path' => 'lang/en_IN',
  ),

5,652

(2 replies, posted in Report Bugs here)

Which version of FA are you using?

Lines 881 to 896 in ui_input.inc are:

function inactive_control_cell($id, $value, $table, $key)
{
    global    $Ajax;

    $name = "Inactive". $id;
    $value = $value ? 1:0;

    if (check_value('show_inactive')) {
        if (isset($_POST['LInact'][$id]) && (get_post('_Inactive'.$id.'_update') || 
            get_post('Update')) && (check_value('Inactive'.$id) != $value)) {
            update_record_status($id, !$value, $table, $key);
        }
        echo '<td align="center">'. checkbox(null, $name, $value, true, '', "align='center'")
             . hidden("LInact[$id]", $value, false) . '</td>';    
    }
}

Your inverted ternery code - $value = $value ? 0:1; - will toggle the status.

5,653

(6 replies, posted in FA Modifications)

Hi Joe,

Encapsulate the attached en_IN file for use with FA as a pkg.

5,654

(2 replies, posted in Setup)

Put in too much into the wiki over time - too much to copy over.....- too familiar with the wiki - please take care of it!

It would be nicer to view all prices in same units of qty and currency for comparison and listed sorted in ascending prices!

where is the reminder function?

Try it in a different browser - Firefox?
Also see that you have Java scripting enabled.
Java runtimes would also be nice.

5,658

(15 replies, posted in Setup)

Actually a signature switch can be set in all reports for
signature,
standard disclaimer or
no signature (default for backwards compatibility)

The signature can be set in the config file incurrent FA v2.3.x in a generic manner and in a per company instance as a new field in the company table in FA v2.4

5,659

(4 replies, posted in Setup)

@pierre whilst your change works, it is the non standard way and will get overwritten on updates. The preferred way is to make a copy of the lang/new_language_template/LC_MESSAGES/empty.po file and edit lines 10438-10439 to be:

msgid "INVOICE"
msgstr "TAX INVOICE"

and compile it with gettext as lang/en_SA/LC_MESSAGES/en_SA.mo and make an entry in the list of available languages and see that the locale is properly implemented. Refer Wiki.

5,660

(20 replies, posted in Setup)

Wiki-ed it.

GL Account Groups have a parent child relationship that can be used optionally.
Read the Wiki on Account Classes and Groups and Parent Ledgers.

Line 58 in purchasing/includes/po_class.inc :

        if ($qty != 0 && isset($qty))

should be:

        if ( isset($qty) && $qty != 0)

The file purchasing/includes/po_class.inc has the class definition for the class po_line_details which refers to the default Quantity / Price - check the defaults in the table schema as well.

5,664

(3 replies, posted in Announcements)

There are no DB changes or config variables additions / changes in v2.3.15 vis-a-vis v2.3.14.
Just copy over the attached diff files into the FA folder.

Language strings will need to be translated from the empty.po as usual.

OpenVZ Template for FA v2.3.15 on Debian Squeeze is available at GNUAcademy.

5,665

(24 replies, posted in FA Modifications)

FA core is okay as it is. Make extensions for peculiar (country specific / rare legal) needs. The programming paradigm - KISS - is well protected here and that is why most non-programmers have found it easy to fathom the code. Extending the COA is inadvisable - porting from other accounting systems / fa versions, inadvertant switch flag type fields, backward compatibility issues pervade.

[RANT]:
Non Accountants and Non Programmers must be able manage FA without having to bother with Government - businesses need simple acounting info / capability for day to day operations. Most countries have begun to question the need for Statutory Audit - Self Audit is being encouraged. In the aftermath of Enron / Arthur Anderson / and other major corporations / audit firms / banks fudging accounts, Governments too will soon have automatic billing systems in their countries from which their VATs will be auto-calculated instead of summary submissions each month/quarter/year! There seems to be little trusted data on countries printing / creating money and providing huge windfalls to select individuals of choice - insurance, subsidies, rights.

{NICE]
If you do not sell in currencies (debt denominator) issued by governments - you do not need to pay tax! Corollary - no one pays any taxes for using FA! No one's paying Joe/Janusz any monies for coding and preserving the FA source! Yet FA users will look after you (tax free) when you visit their countries.....People like them are the real assets worth preserving.

If you wish to replace the regular help URL with your site which has the relevant urls, you might be able to use the help hotkey popup functionality of FA.

5,667

(9 replies, posted in FA Modifications)

Make one like Shipping at the bottom of the invoice or make a service item called, say, VAT Ajustments, with no tax and use it as a free form value.

Caveat: Must remember to do it each time one is needed.

Lines 64-69 in sales/view/view_invoice.php (although it is in the same lines of view_dispatch.php as well) can be commented out to remove the Charge Branch box.

start_table(TABLESTYLE, "width=100%");
  $th = array(_("Charge Branch"));
  table_header($th);
  label_row(null, $branch["br_name"] . "<br>" . nl2br($branch["br_address"]), "nowrap");

end_table();

Other elements can be found there likewise.

Wow! That's a nice way of managing translation of labels and moving into form fields at the same time! For this to work, we need to have an "id" for each label and it's correspondig form field to be suffixed with a common number something like:

<p>
  <span id="formfieldlabel_001"><?php echo _"(&Name"); ?> :</span>
  <input type="text" size="40" id="forminputfield_001" name="name_field">
</p>

Only then can a generic js included in each form be able to generically do the trick.

You will need to show it in a popup window when an invoice is being created or editied or viewed. So code a separate php page to show it and pass it a variables like debtor_id, company#, logged_in_user, logged_in_token, etc. - check if the said user is logged in and the token matches and then pop up the window.

In empty.po as well for relevent mods to be ported to other languages if used.

Since VAT is already included (your price settings), how can you further add VAT to give a total?
Set your prices to exclude VAT and you will have it inline.

Sales Invoice Number is right at the top.

Attached is a mockup of what you need - just make a new invoice format by editing the existing one.

Better still, create a new table called, say, customer_images and link it on a 1 : N relationship with the debtors_master table and have a timestamp field in the new table as the date of last update and use the latest photo in it to display in the invoice form. Possibly have and show a signature field as well to have their scanned signatures for verification.

debtor_id INT AUTOINCREMENT NOT NULL PRIMARY KEY
lupdate DATETIME
Picture BLOB
PictureType enum ('Photo', 'Signature')
IsDeleted TINYINT DEFAULT 0

This way, when there is an FA Upgrade, your table will not be affected.

The shortcut here is not to merely go to a URL but for a specific (Memo) field in a form to get focus. Will this "&" method do it?

5,675

(6 replies, posted in Reporting)

Place the custom reports in the company/#/reporting folder to survive upgrades and be specific to the company!