Width?

Choose a smaller Font size.
Shorten your Item names.
Choose one of the standard widths offered by TCPDF library and alter your report files.

902

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

Contact the respective extension authors (refer the init/config file in each extension) stating your server's PHP/MySQL and FA versions.

MySQL 5.7+ zero Date settings can be read in this post.

Check the zero date time settings - strict dates in your MySQL / PHP and TimeZone settings being different in Server and client browser. Turn on debug in config.php and see what shows up.

Otherwise, choose PHP 5.6.x in FastCGI.

Hope you are using the FA 2.4.7+ GitMaster version.
There were some Void file changes recently.

Attempting a Customer Payment and Voiding it results in the SQL changes in the attachment.
The said sql is abstracted from a plain vanilla install of FA 2.4.7+ (latest Git Master).

Try this on a copy of your installation and see if the results match.

If you manually include the necessary files, you will not need composer. Also the Slim3 version of index.php will need to have the array syntax reverted for use in PHP < 5.4

908

(2 replies, posted in Setup)

Check the fiscal years table in phpmyadmin.

Sales => Maintenance => Sales Types => Use the Tax Incl checkbox as needed.

Done. Thanks.

You probably missed the json_decode line in fabridge.php file at near the end:

$content = ($code == "200") ? json_decode($content, true) : false;

My test was on browser only. Check your PHP.ini settings in CLI and in webserver for any differences.

The CLI output for php check.php is:

"{\"trans_type\":\"10\",\"ref\":\"NoGuia0001\",\"customer_id\":\"78\",\"branch_id\":\"78\",\"location\":\"DEF\",\"deliver_to\":\"ABC, S.A. DE C.V.\",\"delivery_date\":\"2019\\\/11\\\/09\",\"delivery_address\":\"Karachi\",\"order_date\":\"09\\\/11\\\/2019\",\"phone\":\"\",\"cust_ref\":\"\",\"comments\":\"\",\"ship_via\":\"1\",\"payment\":\"1\",\"sales_type\":\"1\",\"items\":[{\"stock_id\":\"2801\",\"description\":\"iPhone\",\"qty\":\"1\",\"price\":\"100\",\"discount\":\"0\"},{\"stock_id\":\"2802\",\"description\":\"Samsung\",\"qty\":\"1\",\"price\":\"100\",\"discount\":\"0\"}]}"

Using PHP 5.3.1 on XAMPP 1.7.3, there is no erroneous duplicate for your transaction.

Check your PHP version and settings.
Verify with PHP 5.3.6 / 7.0 before reporting errors.

This is possibly a PHP version problem - which version are you using?

In PHP v5.3.1 on XAMPP 1.7.3 on WInXP SP3, the following was output for: echo json_encode($data, true);:

"{\"trans_type\":\"10\",\"ref\":\"NoGuia0001\",\"customer_id\":\"78\",\"branch_id\":\"78\",\"location\":\"DEF\",\"deliver_to\":\"ABC, S.A. DE C.V.\",\"delivery_date\":\"2019\\\/11\\\/09\",\"delivery_address\":\"Karachi\",\"order_date\":\"09\\\/11\\\/2019\",\"phone\":\"\",\"cust_ref\":\"\",\"comments\":\"\",\"ship_via\":\"1\",\"payment\":\"1\",\"sales_type\":\"1\",\"items\":[{\"stock_id\":\"2801\",\"description\":\"iPhone\",\"qty\":\"1\",\"price\":\"100\",\"discount\":\"0\"},{\"stock_id\":\"2802\",\"description\":\"Samsung\",\"qty\":\"1\",\"price\":\"100\",\"discount\":\"0\"}]}"

You have used the same subscript for both items. Try the following:

$data =  json_encode(array(
      'trans_type' => '10',
      'ref'=> 'NoGuia0001',
      'customer_id'=> '78',
      'branch_id'=> '78',
      'location'=> 'DEF',
      'deliver_to'=> 'ABC, S.A. DE C.V.',
      'delivery_date'=> '2019/11/09',
      'delivery_address'=> 'Karachi',
      'order_date'=> '09/11/2019',
      'phone'=> '',
      'cust_ref'=> '',
      'comments'=> '',
      'ship_via'=> '1',
      'payment'=> '1',
      'sales_type'=> '1',
      'items'=> array
        (
          array
          (
            'stock_id'=> '2801',
            'description'=> 'iPhone',
            'qty'=> '1',
            'price'=> '100',
            'discount'=> '0'
          ),
          array
          (
            'stock_id'=> '2802',
            'description'=> 'Samsung',
            'qty'=> '1',
            'price'=> '100',
            'discount'=> '0'
          ),
        ),

      ));

Generally this is a one time correction best done in the FA DB directly instead of an extension unless many moons have passed with lots of transactions that need to be tinkered with!

Check Company Setup for settings on tax mode

918

(4 replies, posted in Accounts Receivable)

Committed

Committed

Anyone attempting this work will atleast need to do the following:
1. Take a diff of the existing codebase with the plain vanilla FA v2.3.22 - this will have the site specific changes as well as the customisation changes.
2. Study the schema changes between the backedup exisiting install and the new one in FA 2.3.26.
3. Some customisations will have been assimilated into FA 2.3.26 or FA 2.4.7+ already.
4. After incorporating the customisations into the attached FA 2.3.26 changed files, do an upgrade after taking files and sql backups.
5. If all works fine, then do the same for FA 2.4.7+ with schema and data changes necessary by referring the various sql and php DB updates necessary present in the sql folder in FA 2.4.7+.
6. Make adjustments to the sysprefs table and config.php as necessary.

Goodluck!

921

(3 replies, posted in Wish List)

Possibly restrict the display to be one less to one more than the date specified and take it from there for now. If a strict enforcement is necessary, then a "date <= reconcile date" will need to be implemented. State the URL where this occurs. The existing one takes all unreconciled transactions which is correct.

Refer doc/bank_reconciliation.txt.

Your version of Chrome Browser is 78.0.x - see if an update / downgrade is in order - check if popups are enabled in it's settings, if not put in exceptions for FA site.
Alternatively try FireFox.
What OS are you using for the client side?

Depends on wordpress version. Generally it should only affect some plugins.
You can also use a specific version of PHP for each application - ask your sysadmin if it is a hosting company / corporate environment.

PHP v7.3.x is not fully supported without tweaks to it's settings.
Try PHP 5.6.x or PHP 7.0 / 7.1.

Change the setting in config.php to be:

    $no_check_edit_conflicts = 1;