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

880

(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!

883

(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;

@joe: Can integrate the Approvals System into atleast FA 2.5.

Which version of FA are you using and which PHP/MySQL versions are dissing out FA?

890

(24 replies, posted in Installation)

Try with XAMPP v1.7.7 first.

Firstly, you are using a very old version of FA. The last version in the FA 2.3.x series is FA 2.3.26 which may have addressed some of the issues till then.

Secondly, check if the PHP / MySQL version in your server has changed and if so, as to have it reverted to the older version in which your FA version was stable.

If you are technically handicapped, take professional assistance by posting your bounty in the Jobs board.

892

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

Take it from https://github.com/apmuthu/FA24extensions/tree/master/Extensions/kanban

893

(12 replies, posted in Fixed Assets)

You have credited and debited the same account!

Check out the dump of the original db and compare with the new one for duplicate primary key records and reconcile them first. Which 2.4.7 sql file are you trying to import?

895

(5 replies, posted in Installation)

1. Check the versions of your source and target MySQL DB and PHP versions
2. Provide your source and target FA versions
3. List any extensions added in FA 2.3.x that may have spawned additional tables / file mods
4. List any custom FA and sql mods done
5. Checkout the FA source dump (backup - list size / open fiscal years) and compare schema with FA 2.4.7+ sql/en_US-new.sql schema.
6. Checkout all the sequential sql/*.sql and sql/*.php file updates after your existing versions

Test it out in a VM / container first. Paid assistance booty can be posted in the Job Offers board.
If all else fails, PM me.

896

(4 replies, posted in Accounts Receivable)

@joe: can commit?

Consider truncated fiscal years where the end_date is not 1 year ahead.

You have to make a purchase invoice for the supplier and allocate the payment to the supplier. You have directly written off the expense and hence the loose left over payment entry.

Debit: Stationary Expenses Account [Amount :500]
Credit: Supplier - Invoice for Stationery [Amount :500]

Debit: Supplier - Payment made [Amount :500]
Credit : Bank Account [Amount :500]

899

(3 replies, posted in Wish List)

This may be so where timezone issues are concerned when full timestamps are used and also for correction of dates as well.

Check this post for similar fix as it has to do with your later PHP version.

@joe: can commit it for this file as well.