Search options (Page 73 of 246)

The effect of the return -1; above should be tested under various PHP dispensations - is it an error or is it a graceful change to a new_reference, the calling entity should know and act accordingly.

The official extensions repo has not been updated in a while. The file stands okay in the FA24extensions repo.
Take the files for your extension from:
https://github.com/apmuthu/FA24extensio … ansactions.

Older Windows OSes and older XAMPP have issues with gettext which if disabled in the php.ini and then restart webserver should allow for translations to occur from an array instead. This is because Windows uses 3 character language locales instead of Linux's 2_2.

We can let this pass as the error will indicate to the user that FA needs to be installed. PHP returns false on error for such common functions like db access. This is due to strict syntax checks in later versions of PHP trying to make it more rigid instead of retaining it to be loosely typed. Otherwise, each missing variable will have to be tackled making it long winded.

@poncho1234: Thanks. Committed.

@joe: is this necessary?

@joe: has this been an issue for quite some time? Is there another standard operating procedure that needs to replace the above?

@karl1234: The first of your transactions has a payment and receipt and hence there is an exchange rate variance computed on the exchange rates used (one for payment and another for receipt) for the nett balance of the transaction set. In your second transaction, there is only a notional value in the exchange rate variance account as it awaits the contra entry when settlement occurs in the desired currency.

@andijani: The second transaction (one way) of @karl1234 applies to both your transactions.

The same item can be in Living Room and in Dining Room say like a Chair. If an item can only belong to one group, then name them like:
Living Room Item 1
Living Room Item 2
Dining Room Item 1
Dining Room Item 2
...

Line 45 in includes/types.inc is:

define('ST_SALESORDER', 30);

The execution of the $sql defined from Line 224 in sales/includes/db/sales_order_db.inc provides a non unique resultset which triggers the error message you stated. The simplified query (assuming company db table prefix as "_1") to test this case is:

SELECT * FROM 1_sales_orders WHERE trans_no=30 AND order_no=3;

If you get more than 1 row output, then your Chart of Accounts is not proper as the primary key has not been defined to be a compound one comprising trans_no and order_no.

Since you say that there is no duplicate sales order with that combination of fields, then the new sales order you are trying to insert may have these same values which comes from the type and reference fields in the 1_refs table.

All of this is assuming you are using FA v2.4.x. When you ask for assistance, please provide details of versions of server components and platform used.

There is no Sales Order associated with a payment for the Payment Transaction.
Only when a payment allocation is made to a Sales Invoice, the corresponding Sales Order is tagged to the transaction.

@corporatei: When you upload the latest FA files, it will show v2.4.4 as of now. This does not mean that your chart of Accounts is matched to it. Compare your schema of the database with that of sql/en_US-new.sql and see if there are any table differences or field order and availability differences and synch them to the latter. A blank chart of accounts will necessarily not have any data and hence the tax summary will be 0.

You can install any extension only when logged in as admin in the default company and activate it for any target company from within it. Then, when you are logged in as admin in your target company, you may have to enhance your security role (atleast for the admin user) by enabling the permissions for the new extensions, logout and then login again into the target company.

If you are still in a quandary, PM me access details at a mutually convenient time. I'm possibly half a world away.