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.
2,676 09/23/2017 02:40:19 am
Topic: Hello World Extension for FA (17 replies, posted in Modules Add-on's)
2,677 09/23/2017 01:19:01 am
Topic: Manual Extensions with no version install fix (2 replies, posted in Modules Add-on's)
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.
2,678 09/22/2017 11:39:42 am
Re: Non editable Purchase Order (12 replies, posted in Accounts Payable)
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.
2,679 09/22/2017 05:58:12 am
Re: Non editable Purchase Order (12 replies, posted in Accounts Payable)
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.
2,680 09/22/2017 05:45:28 am
Re: Error flashes up after creating a supplier invoice (6 replies, posted in Report Bugs here)
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.
2,681 09/21/2017 12:07:40 pm
Re: Installation problem (24 replies, posted in Installation)
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.
2,682 09/21/2017 12:04:48 pm
Re: Non editable Purchase Order (12 replies, posted in Accounts Payable)
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.
2,683 09/21/2017 09:00:44 am
Re: Non editable Purchase Order (12 replies, posted in Accounts Payable)
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.
2,684 09/21/2017 05:01:44 am
Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)
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?
2,685 09/21/2017 02:18:27 am
Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)
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.
2,686 09/21/2017 02:03:20 am
Re: how to Prevent changing sales persons in the Customer Branches (4 replies, posted in Accounts Receivable)
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?
2,687 09/20/2017 05:20:05 pm
Re: Solved: Backup does not complete (9 replies, posted in Report Bugs here)
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.
2,688 09/20/2017 03:54:12 pm
Re: Align Inv and Order Numbers (4 replies, posted in Accounts Receivable)
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
2,689 09/20/2017 02:53:28 pm
Re: Align Inv and Order Numbers (4 replies, posted in Accounts Receivable)
@joe: thanks for the commit.
2,690 09/20/2017 07:53:42 am
Topic: Align Inv and Order Numbers (4 replies, posted in Accounts Receivable)
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'), 2,691 09/19/2017 02:59:57 am
Topic: FA from Dynamic IP (0 replies, posted in FA Modifications)
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.
2,692 09/17/2017 04:12:04 pm
Re: Can i Add new Sysname from Extensions ? (2 replies, posted in Modules Add-on's)
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.
2,693 09/17/2017 03:44:24 am
Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)
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.
2,694 09/15/2017 04:37:49 pm
Re: Report Generator (3 replies, posted in Modules Add-on's)
Try this one. Repo updated with auto http / https.
2,695 09/15/2017 02:37:56 pm
Re: Standard pricing & Inventory Valuation Report showing 50% on manufact (3 replies, posted in Items and Inventory)
@poncho1234: update to latest codebase after FA v2.4.2 released. See Announcements and patch.
2,696 09/15/2017 02:36:55 pm
Re: Account & Account Type Ordering (7 replies, posted in FA Modifications)
@joe: makes sense.
2,697 09/15/2017 02:36:23 pm
Re: Bug in rep108 (10 replies, posted in Report Bugs here)
@joe: any separate code for JE?
2,698 09/15/2017 02:27:11 pm
Re: Error flashes up after creating a supplier invoice (6 replies, posted in Report Bugs here)
@poncho1234: You have just found a bug!
@joe: There is no variable $net_total in entire FA 2.4.2 but is used in /purchasing/includes/db/invoice_db.inc at line 396. Should it be $invoice_items_total or $allocate_amount or something else?
2,699 09/14/2017 05:41:38 pm
Re: Can't change the currency of bank accounts (2 replies, posted in Banking and General Ledger)
The "Banking and General Ledger => GL Accounts => Edit Bank Account" does not bear the Currency details.
The "Banking and General Ledger => Bank Accounts => Edit" does not allow the changing of Currency once set. This can be changed in the database directly only. Take a backup, correct it in the sql and upload and restore it. This should be done only when you know that no transactions exist for the said Bank Account as yet.
Make sure that the Home Currency is properly set in the Setup => "Company Setup".
2,700 09/14/2017 05:33:28 pm
Re: Multiple Products From One Manufacturing Process (5 replies, posted in Manufactoring)
Raw Milk, Toned Milk and Cream are 3 different products.
100 Ltr of Raw Milk = 100 Ltr of Toned Milk + 10 Kg of Cream
If you treat the output products as the real constituent items and the input product as the "Kit", you will ordinarily be dismantling the "Kit" and selling the constituent items whilst you can also sell the Raw Milk directly if desired - directly in the "Kit" form.