By "factory order" do you mean "works order", an internal order for your manufacturing dept to start manufacturing something?
302 09/27/2018 01:40:39 pm
Re: New Copy of Sales Order (24 replies, posted in Reporting)
@jfirestone, apmuthu's answer is probably the easiest, have a look at the report extensions on his github acc. to see how they are constructed, look for the code that appears in all the extensions. Don't worry about the _init directory thats used for auto install, you can install it manually.
Then use reporting/rep109.php as the basis for your new extension, just rename it first, when you get it running then modify it to what you need and write your new header code
Also an ext does not modify the core FA files, so upgrades are not compromised
If you figured out you need to modify doctext and header2 you should be able to do it.
303 09/23/2018 10:48:14 pm
Re: Is it possible to extend the function get_ctrl in reports_classes.inc? (5 replies, posted in FA Modifications)
Yes, your right @boxygen, I'd not looked at it for a while
Thank you
304 09/22/2018 07:03:23 pm
Re: Is it possible to extend the function get_ctrl in reports_classes.inc? (5 replies, posted in FA Modifications)
@kvvaradha, thinking out loud here, but this may be relevant... a function cannot be extended it seems, but a class can so looking at:-
File: \reporting\includes\reports_classes.inc
458: class Report
459: {
460: var $id;
461: var $name;
462: var $ar_params;
463: var $controls;
464:
465: function __construct($id, $name, $ar_params = null)
466: {
467: $this->id = $id;
468: $this->name = $name;
469: if ($ar_params) $this->set_controls($ar_params);
470: }
471:
472: function set_controls($ar_params) {
473: $this->controls = $ar_params;
474: }
475:
476: function get_controls() {
477: return $this->controls;
478: }
479:
480: }
So function get_controls is only used once in:-
File: \reporting\includes\reports_classes.inc
104: $st_params .= $this->getOptions($report->get_controls(), $report->id);
And in function getOptions is the line:-
File: \reporting\includes\reports_classes.inc
146: $ctrl = $this->get_ctrl('PARAM_'.$cnt, $type);
also in the same function is:-
File: \reporting\includes\reports_classes.inc
136: foreach($this->ctrl_handlers as $fun) { // first check for non-standard controls
137:
I'm struggling with my php knowledge, but has @joe/@janusz left us something here?
305 09/21/2018 09:52:09 pm
Topic: Is it possible to extend the function get_ctrl in reports_classes.inc? (5 replies, posted in FA Modifications)
Is it possible to extend the function get_ctrl in reports_classes.inc?
How can I add a custom report parameter?
I would like a custom report where a GL account range is selected automatically, to the defined gl accounts needed for the report, but the select gl accounts is still available for the user to select a different range of gl accounts.
Currently there is:-
File: \reporting\includes\reports_classes.inc
270: case 'ACCOUNTS': // not used
271: return gl_account_types_list($name, null, _("No Account Group Filter"), true);
272:
273: case 'ACCOUNTS_NO_FILTER': // not used
274: return gl_account_types_list($name);
275:
276: case 'GL_ACCOUNTS':
277: return gl_all_accounts_list($name);
I've tried to add parameters to reports_custom.php:-
_('From Account') => 'GL_ACCOUNTS',
_('To Account') => 'GL_ACCOUNTS',
but nothing worked for me - is this possible?
Another alternative would be to delete the gl account selection parameters and hard code the fromacc to the toacc in the report, but I would prefer a solution to the above.
Any help or advice would be much appreciated
306 09/20/2018 11:23:58 pm
Topic: New users seem unaware we have a wiki (3 replies, posted in Wish List)
I've noticed that new users seem unaware we have a wiki, so they seem to come straight to the forum (its linked in README.md)
Is it worthwhile to:-
1. Add a link in the README.md file in the root dir?
2. Add a link and some relevant blurb in the install.html file in the root dir?
3. Pre-populate the new post text area in this forum with a similar message as in #2 above?
4. Include that clicking on the help button in the program will take them to the relevant wiki page
307 09/20/2018 09:24:15 pm
Re: Inventory Items CSV Import 2.4.0-3 in FA 2.4.4 on MYSQL 5.6.21 (7 replies, posted in Items and Inventory)
I'll change the jpg to png, the original png filesize was not accepted, I'll make a smaller one and upload it.
308 09/20/2018 02:17:11 pm
Re: Inventory Items CSV Import 2.4.0-3 in FA 2.4.4 on MYSQL 5.6.21 (7 replies, posted in Items and Inventory)
@apmuthu Thank you, guess I need to read the wiki more...
I hope its clearer now, & hopefully less posts on this subject... we shall see.
309 09/18/2018 08:47:57 pm
Re: Inventory Items CSV Import 2.4.0-3 in FA 2.4.4 on MYSQL 5.6.21 (7 replies, posted in Items and Inventory)
@apmuthu can you please add the following images to Install/Activate Extensions wiki page
Both in step 2 https://imgur.com/a/XKEM33V and https://imgur.com/GQuhkLs or send me a link of how to do it.
310 09/18/2018 07:51:08 pm
Re: Inventory Items CSV Import 2.4.0-3 in FA 2.4.4 on MYSQL 5.6.21 (7 replies, posted in Items and Inventory)
Hi,
Have you followed the instructions in the wiki?
Most users who are installing an extension for the 1st time forget or are confused about steps 3and 4. For you my guess is step 3, but could be step 4 if you have changed config setup to not show unaccesible items.
311 09/17/2018 03:35:02 pm
Re: Need help regarding service business (6 replies, posted in Setup)
From the wiki, 2nd title
312 09/15/2018 03:04:39 pm
Re: Need help regarding service business (6 replies, posted in Setup)
So what type of 'expense' are they? wages?
313 09/14/2018 11:48:36 am
Re: Need help regarding service business (6 replies, posted in Setup)
What GL account have you selected for the service items?
If they are expenses you probably need to purchase them from the supplier, then resell them to your customer.
314 09/01/2018 02:35:00 pm
Re: Import functions (3 replies, posted in Modules Add-on's)
You have to give yourself access rights go to Setup -> Access Setup and select the role you are using.
315 08/30/2018 09:45:42 pm
Re: GL Accounts Transactions Totals Between two dates (5 replies, posted in Reporting)
There are nine reports for Banking and General Ledger, as you only have one, check your access rights.
316 08/30/2018 04:32:19 pm
Re: GL Accounts Transactions Totals Between two dates (5 replies, posted in Reporting)
There are two reports in Banking and General Ledger -> General Ledger Reports that have a column total for period selected by individual GL account.
The column headings are This Period and Period
317 08/16/2018 07:18:40 pm
Re: No cash account in Direct invoice (1 replies, posted in Accounts Receivable)
Hi,
The cash account is from the bank account you have set in Banking and General Ledger -> Bank Accounts
The GL accounts for the bank account are assigned here.
I think you can only have one cash bank account. From what I can see thats one GL account per bank account, you cannot use the same GL account for more than one bank account
A bank account in FA does not have to be tangible - hence the petty cash box and the cash till are classed as bank accounts in FA
All about bank accounts in the wiki
The two forum posts mentioned in the wiki are worth a read as well
318 08/16/2018 02:30:01 pm
Re: Closing a fiscal year needs to update the query a bit. (9 replies, posted in FA Modifications)
@rafat, numerous text editors have search in file functionality(Notepad++ for one), and it takes seconds to carry out
319 08/15/2018 03:00:07 pm
Re: Is there an A/P Report? (1 replies, posted in Accounts Payable)
This page in the wiki states there is report 201 and possibly 201.
320 08/11/2018 09:04:24 pm
Re: Search Item List (10 replies, posted in Report Bugs here)
What page are you trying to edit the items?
What can you edit or not edit?
321 08/07/2018 04:26:01 pm
Re: Fixed Assets (30 replies, posted in Fixed Assets)
In Setup - >System and General GL Setup you can set your depreciation period - monthly/yearly.
Then in Fixed Asets -> Fixed Assets set your depreciation rate for an item for say 20% (5 years)
All explained in the wiki
322 08/07/2018 02:14:03 am
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
Now you need to activate it....select the dropdown menu at the top
323 08/04/2018 05:59:30 pm
Re: Ajax Time Out in GL Inquiry (11 replies, posted in Banking and General Ledger)
@kvvaradha whats a lac? Do you mean 100,000?
324 08/04/2018 02:38:54 pm
Re: Ajax Time Out in GL Inquiry (11 replies, posted in Banking and General Ledger)
How long is it now?
I've seen 600 secs recomended as max, (setting to 0 is unlimited, but maybe other timeouts in http so beware) From my understanding its a security issue.
Does your host allow changes?
This SE post is interesting, can you add a variable based on number of records?
Google is your friend
325 08/02/2018 01:48:35 pm
Re: Ajax Time Out in GL Inquiry (11 replies, posted in Banking and General Ledger)
Is it anything in php.ini or mysql.cnf settings???