Search options (Page 140 of 246)

You have asked many questions to which you may find answers by consulting the wiki. Also search the forums here. Take support from consultants for implementation.

When a direct invoice has been voided what policy do you expect for any payments received for that invoice till then?

Actually any payments received from the customer for that invoice should be either voided or re-assigned to be advances received on account before voiding any associated direct invoice.

Check the customer ledger account to see if the customer payment is still there and void it there if necessary.

@joe: What is the policy on treating customer payments received on voiding associated direct invoice?

Anything in the error logs?

Make a separate clean install of FA v2.3.25 and take a backup of the sql schema.
Compare the sql with that of your pre-upgrade v2.3.22 and see if there are any settings change.
Compare the sql/en_US-new.sql in FA v2.3.25+ with your Singapore CoA and see what differs.

In plain vanilla FA, there is no cheque number field. It must exist only in the Memo / Description field. You can make a module extension for yourself for the new field in the forms / reports with new tables in a 1:1 relationship with existing ones or extend the table schema for a new field. Such changed will break your upgradeability unless you also upgrade your module extension.

Attempting to live within the Memo / Description field can be done using the Inventory Bin hack listed in the wiki.

Then treat the payment as on Account and pay by allocation with check number which would be searchable. For reporting by cheque number, you will have to parse it out into a custom report.

Best way:
1. Take sql backup.
2. Manually make 1 entry.
3. Take another sql backup
4. Compare the backups and see what changed
5. Generate and execute MySQL statements (in phpMyAdmin, SQLyog, etc) to simulate these changes (Inserts / Updates) for all other entries to be imported.

In the Charts itself?

Does the client use FrontAccounting or do they intend to do so?
This is not a general employment forum but specific to FA related work.

There is some code in FA where Polish characters are spared. Checkout includes/session.inc lines 312-332 in FA 2.3:

function html_cleanup(&$parms)
{
    foreach($parms as $name => $value) {
//        $value = @html_entity_decode($value, ENT_QUOTES, $_SESSION['language']->encoding);
        if (is_array($value))
            html_cleanup($parms[$name]);
        else
            $parms[$name] = @htmlspecialchars($value, ENT_QUOTES, $_SESSION['language']->encoding=='iso-8859-2' ? 'ISO-8859-1' : $_SESSION['language']->encoding);
    }
    reset($parms); // needed for direct key() usage later throughout the sources
}

@Digger: Thanks a ton!
@joe: This should be a sticky!