926 Topic by apmuthu

(1 replies, posted in Report Bugs here)

File: admin/db/transactions_db.inc
Line 34:

     $sql .= ",t.$trans_date as trans_date";

to be replaced with:

    if ($trans_date)
          $sql .= ",t.$trans_date as trans_date";

@joe: can commit it.

Go to forum: Report Bugs here

927 Reply by apmuthu

(12 replies, posted in Accounts Receivable)

There is no Field id in the above statement. Only the Field tax_type_id is there.

The said error occurs in the function add_trans_tax_details() defined in gl/includes/db/gl_db_trans.inc. Hence check the whole of the Sales Order cart for any missing / improper data. Also check the value of $tax_id and see if it is properly related record with some valid value for the field tax_type_id in the Tax Setup.

Go to forum: Accounts Receivable

928 Reply by apmuthu

(12 replies, posted in Accounts Receivable)

This might have something to do with missing exchange rates if other currencies are involved or a duplicate reference is used.

Go to forum: Accounts Receivable

929 Reply by apmuthu

(15 replies, posted in Reporting)

Lines 323 to 330 in reporting/rep303.php:

            if ($barcodes && barcode_check($trans['stock_id']))
            {
                $adjust = true;
                $bar_y = $rep->GetY();
                $barcode = str_pad($trans['stock_id'], 7, '0', STR_PAD_LEFT);
                $barcode = substr($barcode, 0, 8); // EAN 8 Check digit is auto computed and barcode printed
                $rep->write1DBarcode($barcode, 'EAN8', $rep->cols[$firstcol++], $bar_y + 22, 22, $SysPrefs->pic_height, 1.2, $style, 'N');
            }

@joe: We need to put in BarCode type as a per company variable in the sysprefs table and have a table that looks up the size and checkdigit details preferably from the tcpdf file. Also, the stock_id field can be increased to be greater than the size of all known barcode types.

Go to forum: Reporting

930 Reply by apmuthu

(3 replies, posted in Banking and General Ledger)

Yes - Separate Sub Ledger Account for each trackable Customer or use the customer reports.

The report shared is a common one for all GL Transactions - True Ledger. As this needs to accomodate all kinds of references, the Person/Item column may not exist for every line record.

Custom reports with minor changes can be made to a copy of the appropriate report in reporting/rep###.php file and then placed in the company/#/reporting/ folder where it will override the original in actual FA usage.

If the custom report is completely different, make it as an extension and install it - see samples under the rep_* folders here.

Read the wiki.

Go to forum: Banking and General Ledger

931 Reply by apmuthu

(3 replies, posted in Banking and General Ledger)

FA does not have a separate field for Cheque Number in the core - you will need an extension for it - besides it does not qualify as to which bank it pertains to even here. However, it can be part of the memo / detail field in FA.

Banking and General Ledger (tab) => Reports => GL Account Transactions => Choose Accounts Receivables in From and To Accounts - this will yield a report with all customers in it. If sub-ledgers for each trackable customer is created for the AR main head, then it can be filtered on a per customer basis.

@joe: The report attached in the previous post can be made atleast in FA 2.5.

Go to forum: Banking and General Ledger

932 Reply by apmuthu

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

Export out a few Journal Transactions and then try to import them back with some date and number changes into a dummy install. Also try to upgrade your FA install to the latest in a test environment and see what happens.

We still need to resolve the missing add_bank_transaction() function in the core.

Go to forum: Modules Add-on's

933 Reply by apmuthu

(1 replies, posted in Banking and General Ledger)

Void the entry in Setup => Void a Transaction.

Go to forum: Banking and General Ledger

934 Reply by apmuthu

(28 replies, posted in Items and Inventory)

The said rep304.php was last altered in FA 2.4RC1 way back on 2016-02-23. It is possible that the functions it uses may have been "fixed" thereafter. Try a fresh install of FA 2.4.7+ and see if you can simulate the error.

Go to forum: Items and Inventory

935 Reply by apmuthu

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

The said error occurs in the function add_journal() defined and called in write_journal_entries() in gl/includes/db/gl_journal.inc where the full complement of 10 arguments are used. Other functions too call it through:

add_supp_invoice() <= purchasing/includes/db/invoice_db.inc
void_supp_invoice() <= purchasing/includes/db/invoice_db.inc
add_wo_costs_journal() <= manufacturing/includes/db/work_order_costing_db.inc
handle_negative_inventory() <= includes/db/inventory_db.inc
add_exchange_variation() <= gl/includes/db/gl_db_banking.inc
add_cust_supp_revaluation <= gl/includes/db/gl_db_banking.inc
delete_this_fiscalyear() <= admin/db/fiscalyears_db.inc

None of the above functions are directly called in the extension file modules/import_multijournalentries/import_multijournalentries.php.

The file /gl/includes/db/gl_db_trans.inc is included in the above extension file which defines the function add_gl_trans() which has many more arguments but does not use the event_date parameter.

The functions called by the said extension file of importance are:

write_journal_entries() <= gl/includes/db/gl_journal.inc
add_bank_transaction() <= ** (Cannot find it defined anywhere - not even in FA 2.3.x) **

However, these functions are defined:

add_bank_transfer() <=gl/includes/db/gl_db_banking.inc
add_bank_trans() <= gl/includes/db/gl_db_bank_trans.inc

and both do not match the number and type of arguments used in the call.

The missing function add_bank_transaction() can be compared to the function write_bank_transaction() defined in gl/includes/db/gl_db_banking.inc but even this does not match the arguments used in the call.

@joe: where and how do we define the function add_bank_transaction() now?

Go to forum: Modules Add-on's

936 Reply by apmuthu

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

Wherever you have an event_date field as blank / null, it appears that your MySQL / PHP is not happy with it and the normal '0000-00-00' is not acceptable as well and it does not degrade gracefully as earlier versions of PHP/MySQL did. Set the strict date off in MySQL and restart MySQL and Apache:
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
https://www.liquidweb.com/kb/how-to-disable-mysql-strict-mode/

Otherwise, make the existing settings happy by populating the import file with some date like 1970-01-01 wherever event_date is blank and then import it.

Go to forum: Modules Add-on's

937 Reply by apmuthu

(3 replies, posted in Setup)

Lines 25-26 in config.php:

    if (!ini_get('date.timezone'))
        ini_set('date.timezone', 'Asia/Kolkata');

Comment out the first line above and edit the second as needed.

Go to forum: Setup

938 Reply by apmuthu

(8 replies, posted in FA Modifications)

Compare any dashboard type theme (like canvas / dropdown) files with the AdminLTE and make the necessary images / css changes as needed.

Go to forum: FA Modifications

939 Reply by apmuthu

(8 replies, posted in Report Bugs here)

https://gist.github.com/Dreyer/2958946
https://conetix.com.au/support/simple-php-mail-test/

Go to forum: Report Bugs here

940 Reply by apmuthu

(2 replies, posted in Jobs wanted/offered, non-free offers)

State what language interface you use so that you can get the appropriate developer and what bounty you offer.

Go to forum: Jobs wanted/offered, non-free offers

941 Reply by apmuthu

(9 replies, posted in Reporting)

We need to pinpoint the version / build date when it last worked as desired and not as in the policy stated now. Only then can a diff show what needs to be reverted if desired even if it violates espoused design policy.

Go to forum: Reporting

942 Reply by apmuthu

(28 replies, posted in Items and Inventory)

Inventory Sales Report is rep304.php and it works fine at my end in both Windows and Linux on PHP 5.3.1 and 5.3.3 respectively. State your PHP version and other versions and which FA version you are on.

Go to forum: Items and Inventory

943 Reply by apmuthu

(3 replies, posted in Items and Inventory)

Related Post

Go to forum: Items and Inventory

944 Reply by apmuthu

(9 replies, posted in Reporting)

When all was okay for rep301.php in v2.4.4, and now it is amiss, what lines changed in 2.4.7 to make it "correctly conforming to this new policy"?

FA 2.4.7 was released on 2019-06-25.
FA 2.4.4 was released on 2019-03-17.
rep301.php was last modified on 2019-06-24
Prior to 2.4.4, rep301.php was modified on 2017-12-09.

Hence a diff between then and now would prop up some leads. Ignoring all whitespace and comment changes, the effective diff is attached.

Related Post

Go to forum: Reporting

945 Reply by apmuthu

(4 replies, posted in Items and Inventory)

State version of Apache/PHP/MySQL/Platform/FA.
Check apache and FA error logs.
Turn on debug if necessary in the config.php file.

Go to forum: Items and Inventory

946 Reply by apmuthu

(15 replies, posted in Reporting)

Using barcode reader to get the stock codes into FA does not require any integration in FA since a barcode reader is just a keystroke pump into the keyboard buffer.

The real need is to generate a new barcode report to accomodate your 13 digit barcodes.

Go to forum: Reporting

947 Reply by apmuthu

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

The current translation for ar_EG is available at Transifex and is also attached here.

Your po file is for a boxygen theme codebase and has different formatting for certain strings.

Go to forum: Modules Add-on's

948 Reply by apmuthu

(8 replies, posted in Setup)

The generated PHP file is for windows users who do not have a useable GD library due to different way that windows recognises locales. It is a fallback for those who cannot use the newer php GD library in FA. Some js related double escaped strings cause problems here.

Go to forum: Setup

949 Reply by apmuthu

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

Remove the Google sign-in for downloading the file.

Go to forum: Modules Add-on's

950 Reply by apmuthu

(8 replies, posted in Setup)

The necessary ANSI files are at:
https://github.com/apmuthu/FA24extensions/tree/master/Languages/en_US

Also attached here.

Go to forum: Setup