Search options (Page 126 of 247)

Quotations / Orders do not enter the ledger.

1. You can choose to have 2 separate companies in FA -> one the actual one, and the other a staging one where entries for approval are made. You can then export out those entries from the staging one on approval and import them into the actual one.

2. You can take a backup first. Let the staff make the entries for approval. Export out those entries that have been approved. Restore from backup. Import the approved entries. Take a backup again and go on all over again....

Going forward, in FA 2.4.x, we can have a separate data entry operator permission with inactive flag set on each transaction entered. The actual accountant with the approval rights gets to remove the inactive flag on approval whensce it gets into the ledger.

Refer line 44 in sales/create_recurrent_invoices.php:

    $doc->Comments .= sprintf(_("Recurrent Invoice covers period %s - %s."), $from, add_days($to, -1));

and change as needed.

SynPOS hasn't been updated since Nov 2006 at SourceForge and is written in Java.

synpos mirror with some mods is on GitHub and was last updated in Sep 2015.

Which is your repo for the integration?

Initial user / password: 123 / 123
Uses the HSQL DB by default - can configure for MySQL with JDBC.

If you are working with html emails, can they not be preferentially attached with some includes / css to achieve what you want? "Some" of the emails need some place to to store / flag them for such decisions or based on some logic even if just pertinent to you.

Emails are handled by the class in reporting/includes/class.mail.inc. See if you want to include some conditional header in them.

First off, the Amount field is present in the standard Audit Trail Report 710.

Your PDF of the lacunae in the Audit Trail is appended to this post for forum asset self sufficiency.

The database schema for FA 2.3.x has been frozen. Any changes to it will need to be done in FA 2.4.x only.

The amount field comes from the gl_trans table. Hence it is the GL Transactions table record insertion / updation that needs to be attended to and not the reporting script per se.

Does this bug appear in the other implementation?
Post a copy of the SQL statements after they are formed in the report file.

See if you can download it manually. It may be a route to host issue. Clear dns cache.

Advance payment to supplier should be a "loan" till the invoice is booked.

Debit Card, direct debit, standing order etc are "cheques" in FA where the Transaction number can be the Cheque Number. Make it part of the name of the Bank Account.

Before safely using strings in SQL statements, cleaning them up has traditionally been done using the likes of mysql_real_escape_string and add_slashes. Whilst the latter can be used for insertion/updation of records in MS Access, the following function will be suited for many instances where offending/unsafe/exploitable characters need to be stripped:

function msaccess_escape_string($str) {
    $lf = "\n";
    $str = str_replace(Array("'", '"', "\t", "\r", $lf, "\\"),"", $str);
    if ($str == NULL) $str = ' '; // Access does not allow null fields to be blank in insert using this method
    return $str;
}

PM me the access details.

Check your PM mailbox.
Your host has switched to PHP 7 - ask them to revert back to PHP 5.3 to 5.6 as it originally was.

You may be able to make the change from your hosting control panel itself like this and if using SuPHP, like this and if using Plesk, like this.

PHP 7 incompatibilities are here.

MySQL functions have been removed in PHP 7 and only PDO_MySQL and MySQLi are available in it now.

Use the links from my earlier post. The official SF link / release download has some bugs fixed later in the repos.