https://frontaccounting.com/fawiki/index.php?n=Help.SystemAndGeneralGLSetup
https://frontaccounting.com/fawiki/index.php?n=Help.Items
2,576 10/21/2017 05:33:52 pm
Re: Supplier purchase account doesnt show as default GL account in Invoice (4 replies, posted in Accounts Payable)
2,577 10/21/2017 05:30:37 pm
Re: Purchase order voiding BUG (10 replies, posted in Report Bugs here)
That is how it should be. We have only voided the PO Delivery and not the PO itself. A PO does not need to be voided, it can be cancelled in it's Edit screen.
2,578 10/21/2017 05:24:38 pm
Re: Supplier purchase account doesnt show as default GL account in Invoice (4 replies, posted in Accounts Payable)
Where did you get the 8 Digit GAAP Chart from?
Compare your chart sql template with the (FA 2.4.2+) one in my GitHub repo.
You will find that none of the official repo charts have the account number 50090001 (in both FA 2.3.x and FA 2.4.x) and that the default COGS A/c is 42090001 and is listed there as the default one in the sys_prefs table too.
2,579 10/21/2017 05:00:12 pm
Re: Invoice Editable (23 replies, posted in FA Modifications)
Updated.
The diff of your new file added as compared to the stock FA 2.4.2+ master apart from whitespace changes are::
--- sales/includes/ui/sales_order_ui.inc Sun May 21 21:49:30 2017
+++ sales/includes/ui/sales_order_ui.inc Sat Oct 21 22:32:51 2017
@@ -236,6 +236,10 @@
display_note(_("Marked items have insufficient quantities in stock as on day of delivery."), 0, 1, "class='stockmankofg'");
div_end();
+
+ if(list_updated('stock_id')) //added by faisal phuong
+ set_focus('stock_id');
+
}
// ------------------------------------------------------------------------------
@@ -265,6 +269,9 @@
else
{
customer_list_row(_("Customer:"), 'customer_id', null, false, true, false, true);
+ If (isset($_GET['InvoiceNo']))
+ hidden('InvoiceNo', $_GET['InvoiceNo']); //Added by Faisal for Invoice Edit
+
if ($order->customer_id != get_post('customer_id', -1))
{
2,580 10/21/2017 10:47:01 am
Re: Hello World Extension for FA (17 replies, posted in Modules Add-on's)
Placed the Hello World tab in the 4th position (configurable in the code). Requested for tab positioning method in the application class itself in this post.
2,581 10/21/2017 10:36:15 am
Topic: New method for application class re-ordering the application tabs (0 replies, posted in Modules Add-on's)
Whenever a new tabbed application is added to FrontAccounting, it appears in a tab just before the Setup tab as coded in the front_accounting class method init() and invoked at the end of the includes/session.inc file.
Any new extension developer would want to position their application's tab (if it is an application predominantly residing in a separate tab) at some specific place and not just before the Setup one.
To alleviate this situation without having to code inconsistently/redundantly in each extension, it would be better to have a method in the application class (in applications/application.php) on the following lines contemplated to be in my hello_world extension for now:
// Change tab order
$i = 4; // set this extension on the 4th tab
$x = $app->applications;
$y = array_pop($app->applications); // this application was added last just now
$app->applications = Array();
$app->applications = array_merge(array_slice($x, 0, $i-1), array('hello' => $y), array_slice($x, $i-1));
unset($x,$y,$i);
2,582 10/21/2017 10:07:02 am
Topic: Remove double return in hooks.inc (3 replies, posted in Report Bugs here)
The file includes/hooks.inc has it's last class method default_get_dispatchable_quantity() called only in the page's last function hook_get_dispatchable_quantity().
1. Is this set of functions necessary here?
2. The said method has two consecutive return statements - remove or comment one of them if they should be there for some alternative workaround for a different set of PHP versions.
2,583 10/21/2017 09:36:16 am
Re: Activating extension in new company (1 replies, posted in Modules Add-on's)
Install of an extension and activating it for specific companies can be done only from the default company. All other companies can only then enable/disable permissions for it's security sections for appropriate roles for themselves.
2,584 10/21/2017 07:24:44 am
Re: Purchase order voiding BUG (10 replies, posted in Report Bugs here)
The problem is that you are trying to Void it twice - once on successfully Voiding a transaction and since Transaction# is still showing the voided one as a label in the resultant page you may have pressed the Void Transaction again. The Memo field gets cleared but the Transaction# field does not.
@joe: The success message should show the Transaction# that was successfully voided and the Transaction# label in the form should be blanked out on the success page.
2,585 10/20/2017 07:44:15 pm
Re: Auto Numbering on Item Code (11 replies, posted in Items and Inventory)
There is another issue that appears. When we try to add one more item to a SalesKit, the SalesKit (the one we are adding to) appears in the selection drop down box and we can actually get into a circular binge! If some other SalesKits are chosen then it may be okay and that too only if this current one is not part of the SalesKit we are adding.....This may not really be a problem if the Sales Kit being added to another Sales Kit gets populated by it's constituent items!
If we can replace the primary key id with the stock_id and item_code as a compound primary key in the item_codes table and re-code all the classes and functions to adhere to it, then maybe we can do what you want. It will probably break a few extensions as well!
@joe: good to have.
2,586 10/20/2017 04:34:06 pm
Re: Hello World Extension for FA (17 replies, posted in Modules Add-on's)
The $_SESSION['App']->applications array of objects is dumped and attached herein for further coding and ordering the tabs.
2,587 10/20/2017 04:17:50 pm
Re: Auto Numbering on Item Code (11 replies, posted in Items and Inventory)
Actually the Uniqueness for the said couple of fields is enforced by an index. It could have been the compound primary key in which case your need would be satisfied.
FA for the most part has tables with just one single primary key to make it easy to code record manipulations (select, update,delete).
The fields stock_id and item_code are both generally VARCHAR(20 except a few of the former are CHAR(20) in all tables they are part of. The varied definition is probably an error or some index justification.
grep stock_id sql/en_US-new.sql
`item_code` varchar(20) NOT NULL default '',
`item_code` varchar(20) NOT NULL,
`item_code` varchar(20) NOT NULL default '',
grep item_code sql/en_US-new.sql
`stock_id` varchar(20) NOT NULL default '',
`stock_id` varchar(20) NOT NULL,
`stock_id` char(20) NOT NULL default '',
`stock_id` varchar(20) NOT NULL default '',
`stock_id` char(20) NOT NULL default '',
`stock_id` varchar(20) NOT NULL default '',
`stock_id` char(20) NOT NULL DEFAULT '',
`stock_id` varchar(20) NOT NULL default '',
`stock_id` varchar(20) NOT NULL default '',
`stock_id` varchar(40) default NULL,
`stock_id` char(20) NOT NULL default '',
2,588 10/20/2017 03:51:11 pm
Re: Recurrent invoices and sales groups (9 replies, posted in Wish List)
If two branches of a single customer are assigned to different Sales Groups, will your listing appear fine if the new Sales Group filter is in place?
The tag for strike-through here is del (in [ ] and [/ ]).
2,589 10/20/2017 02:39:05 pm
Re: Recurrent invoices and sales groups (9 replies, posted in Wish List)
You're right. The field group_no (Sales Group) is part of the #_cust_branch table and hence there can be only one Sales Group for one branch.
This means that you will also need to have a cust_branch filter if you want to make a report Sales Group - wise.
2,590 10/20/2017 03:16:39 am
Re: Purchase order voiding BUG (10 replies, posted in Report Bugs here)
Update to latest FA 2.4.2+ and see if this issue resolves itself.
The changed files from FA 2.4.1 to FA 2.4.2 (#4 post) and that for fixes thereafter (#12 post) are in the Announcements thread for FA 2.4.2.
2,591 10/20/2017 01:57:49 am
Re: No need for charts in installed_extensions.php in company# (2 replies, posted in Modules Add-on's)
@joe: your take?
2,592 10/20/2017 12:29:05 am
Re: Recurrent invoices and sales groups (9 replies, posted in Wish List)
Then as it is still possible to assign the same branch to more than one sales group, the uniqueness of the requested filter would will cause erroneous sums in the resultant report.
2,593 10/19/2017 05:50:25 pm
Re: Recurrent invoices and sales groups (9 replies, posted in Wish List)
@joe: makes sense?
What happens if a customer is in more than one sales group?
2,594 10/19/2017 05:42:28 pm
Re: Hello World Extension for FA (17 replies, posted in Modules Add-on's)
The Hello World module is now extended to be in it's very own tab.
Screenshots too are in the attachment herein.
Must now implement ways to disable and re-enable tabs from within the user interface much like the Use Manufacturing and Use Fixed Assets settings in the Company Setup page.
The tabs are stored in $_SESSION['App']->applications array of objects where the keys will now be:
'orders'
'AP'
'stock'
'manuf'
'assets'
'proj'
'GL'
'hello' <<== newly inserted
'system'
What is the standard method of re-ordering the tabs? Some tabs will be missing in the above list if not enabled.
Why not code the Company Setup with the means to enable/disable all standard and registered tabs other than Setup?
2,595 10/19/2017 01:19:43 pm
Re: Work Order, How does this work? (8 replies, posted in Manufactoring)
Materials are issued from stock / purchases for use in a work order for processing.
They may be in addition to those in the BOM and may be issued multiple times during manufacturing process.
When material is moved from stock for manufacturing they need to move out of the warehouse and hence the stock_moves - only after this can manufacture start / resume.
Refer the Wiki which is quite comprehensive.
2,596 10/19/2017 06:07:40 am
Re: db connection scripts fixes (5 replies, posted in Report Bugs here)
@joe: any thoughts?
2,597 10/19/2017 06:05:17 am
Re: Invoice Editable (23 replies, posted in FA Modifications)
@joe: I agree.
@boxygen: Zip, upload and paste link to changed files for this "feature" so that it can become an extension someday and be available for reference.
2,598 10/19/2017 06:00:03 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
@BraathWaate: Good to rely on core functions like the native get_next_trans_no() in the final fix now committed in my repo.
It is attached herewith.
2,599 10/19/2017 02:58:51 am
Re: credit amount customer (1 replies, posted in Reporting)
Either create your own report or manipulate the Excel Report.
2,600 10/19/2017 02:48:02 am
Re: Auto Numbering on Item Code (11 replies, posted in Items and Inventory)
Each Sales Kit has a separate item_code of it's own in FA. The Sales invoice will only reflect the individual items and not the Sales Kit name. In fact, the item_codes table has some redundancy in the description of the Sales Kit name (see attachment) that is duplicated for each constituent item in it. This normalisation issue may the cause of it's inability to provide the unique auto numbered item_code to the constituent items of a SalesKit when more than one constituent item exists. As the said table has a separate auto-numbered id field manipulating each entry individually is not hampered when just the id of the record is provided. But when several constituent items are inserted in sequence this will be an issue if the actual item_code is not properly coded into them and the next one is invoked each time.
Wonder which field or what logic distinguishes a SalesKit from a normal item......
@joe: this needs investigation.