It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
Not everyone's list of transactions may be as straightforward as yours was. Every instance of import_transactions should normally trigger such an error if there were no customers/branches to begin with in the target FA.
Your experience and feedback will be useful to those in a similar situation. Thankyou.
The function check_db_has_customer_branches() in sales/sales_order_entry.php and sales/credit_note_entry.php is the one that normally causes this error. In this case, the import_transactions.php file too calls this function on line 131.
After taking a backup before importing transactions, try to temporarily comment out the said line and then import your transactions and see if everything is in order. This check is there for those who try to import transactions pertaining to customers that do not exist in the target FA system.
To make the $_GET variables persistent, copy it to the session variable.
State where you are using this construct and context.
1. Remove pragma-cache
2. Set expiry for refresh to old date
3. Make sure file_get contents is within the max filesize and timeouts set in php.ini / apache conf files.
4. Zipping the sql will save bandwidth if http gz compression is not enabled.
View discussion.
The 'version'] => '-', is present in the codebase and hence it's use here.
As this is a manual install and is not available from the official repo, the version number has been omitted to run without error if the fix in this post is made. This will also serve to illustrate the use and disuse of the version parameter.
Attached in a later post is the Hello World Extension with manual install instructions in the README.md file.
It is also in my FA24Extensions Repo.
When a third party extension (that is not in the list of extension repos as defined in version.php) with no version number ('version' => '-',) is attempted to be re-installed and activated for a specific company, the following error arises:
Package <$ext['name']> is incompatible with current application version and cannot be activated.
Check Install/Activate page for newer package version. <$ext['name']>In general, such third party extensions can have their version set to a hyphen whilst they take responsibility for the version matches. To enable such extensions to be activated without the error nag, the following fix can be incorporated by replacing line 215 in admin/inst_module.php:
if (check_value('Active'.$i) && !check_src_ext_version($ext['version']))with:
if (check_value('Active'.$i) && (!($ext['version'] == '-' || check_src_ext_version($ext['version']))))The $ext['available'] parameter is to indicate the extension's availability with description in the official repos and will be blank for such third party unlisted extensions.
@joe: can incorporate it in the core.
The attachment in my earlier post shows it is editable as of now even after the GRN. Make sure that the Company Setup has chosen the correct accounting year as being active and current.
Hence: PO => GRN => Supplier Invoice => Supplier Payment Done.
Once a GRN is accepted / made, the original PO should not be edited and need not be too as any balance yet to be received is of no consequence unless a balance GRN is made and a fresh Supplier Invoice for it is accepted.
But in this case, after the Supplier Invoice has been made / entered, I am able to edit the original Purchase Order.
Therefore, in your case it may be a user role / permissions issue - try doing it with Company Admin user role.
You can download the latest dev from GIT. Alternatively, you can overwrite the existing v2.4.2 with the changed files in the Announcements for the said version.
Whilst your 3 commits address the state of the codebase on the date of your fork, check to see if any subsequent changes need to be incorporated.
https://github.com/PaulShipley/fa24/commit/c78c771ef159c7df95984127a2f82895ffaec13c
https://github.com/PaulShipley/fa24/commit/0a9c6fc6c3559b15c9be9bf9417159a20869bf77
https://github.com/PaulShipley/fa24/commit/4992f088c4d299b3443d8852df2cbeeeb9460afa
A simple shell script of sed constructs to achieve the same would be in order.
As the process of generating the DO from a Sales Order is normal, I do not see how you created a DO from the PO directly - unless you did so manually, in which case, the two are not linked by FA. In the Demo company, the PO is editable and is in no way linked to any DO.
Install a US Company with Demo Data (sql/en-US-demo.sql).
List your steps to reach where you are and let us see if we can replicate it.
How did you use a purchase order (your order with the supplier) to become a delivery order (your supply to your customer)?
Only Customer Orders can be used for deliveries to the customer and thence to invoicing the customer.
Revision 2 of the sales/merge_customers.php is attached herewith and committed to my FA24mods repo.
Addresses the missing fields listed in 1 by @itronics except the field gl_trans.person_id - for some transaction where person_type_id is set to PT_CUSTOMER (2).
Security escalated to Company Admin.
All echo statements replaced by wrappers.
On Merging Customers, the page does not re-compute the select boxes though the merge has been successful - purge cache?
The additional confirmation message is just displayed since there is no separate select window as in Void Transactions page. Someone can enhance it if necessary.
Anyone game to make it into a module?
To the extent possible, I have cleaned up the code and attached it in the 7th post in this thread.
@itronics: please provide the additions to cover the fields stated.
As far as the raw echo statements are concerned, it was only a means to illustrate the actual intent by following the KISS principle.
If there are any security considerations for access levels, then it can be exclusively allotted to the Company Administrator for keeping it in the core.
Should Salesmen be allowed to create customers for themselves only (taking logged in user as the Salesman for creating it)?
Should the Salesman field then be editable only by some higher level authority hierarchy?
Increase the company timeout from 600 (10 minutes) to 86400 (1 day) in Setup -> Company Setup..
The said message comes from line 256 of includes/session.inc
This happens when sys_prefs parameter 'db_ok' is not true (1) and $_SESSION["wa_current_user"] has become invalid due to a timeout.
Yes.
Lines 252 and 266 of sales/inquiry/sales_orders_view.php
Line 168 of sales/inquiry/sales_deliveries_view.php
Line 88 of sales/allocations/customer_allocation_main.php
Line 110 of purchasing/inquiry/po_search_completed.php
Line 171 of purchasing/inquiry/supplier_inquiry.php
Line 137 of purchasing/inquiry/supplier_allocation_inquiry.php
Line 95 of purchasing/allocations/supplier_allocation_main.php
too will need similar attention.
Line 96 of sales/manage/sales_groups.php:
label_cell($myrow["id"]);should be:
label_cell($myrow["id"], "nowrap align='right'");Similar appendage needed to
Line 140 of sales/manage/recurrent_invoices.php
Lines 218 and 230 of sales/create_recurrent_invoices.php
Lines 388 and 396 of purchasing/includes/ui/invoice_ui.inc
Line 301 of includes/ui/allocation_cart.inc
Line 157 of inventory/inquiry/stock_movements.php
@joe: thanks for the commit.
In sales/inquiry/_customer_inquiry.php lines 193-194:
_("#") => array('fun'=>'trans_view', 'ord'=>''),
_("Order") => array('fun'=>'order_view'), can be changed to
_("#") => array('fun'=>'trans_view', 'ord'=>'', 'align'=>'right'),
_("Order") => array('fun'=>'order_view', 'align'=>'right'), There are numerous dynamic IP to fixed URL redirection / Dynamic DNS services with different TTLs to assist FA users in running their instance without static IPs.
Most IP Update clients and remote authentication services rely on external servers to capture the local WAN IP. If such services are run from within a LAN / localhost and the remote user needs to verify the actual IP dishing out the services, it is best to parse the WAN IP from the local router.
Once such script for the NetGear DG834G WiFi ADSL router is now available at my repo. It does not use any cURL or other fancy libraries and can be run off localhost and CLI. It can be adapted for other routers / gateways that use such realm based authentication.
Chances are that they may be overwritten by others with similar ideas (from their extensions). Better to keep your constants inside your extension and do an array merge of standard arrays with yours for use within your extension.
The sales/merge_customers.php file has been updated with TB_PREF and sql_injection protection.
@joe: can include in core with appropriate menu entry and role permission.
The same can be done for suppliers and items as well.
Try this one. Repo updated with auto http / https.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.