301

(24 replies, posted in Reporting)

By "factory order" do you mean "works order", an internal order for your manufacturing dept to start manufacturing something?

302

(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.

Yes, your right @boxygen, I'd not looked at it for a while

Thank you

@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?

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

(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

I'll change the jpg to png,  the original png filesize was not accepted, I'll make a smaller one and upload it.

@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.

@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.

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

(6 replies, posted in Setup)

From the wiki, 2nd title

Link one
Link two
Link three

312

(6 replies, posted in Setup)

So what type of 'expense' are they? wages?

313

(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

(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.

There are nine reports for Banking and General Ledger, as you only have one, check your access rights.

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

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

@rafat, numerous text editors have search in file functionality(Notepad++ for one), and it takes seconds to carry out

319

(1 replies, posted in Accounts Payable)

This page in the wiki states there is report 201 and possibly 201.

320

(10 replies, posted in Report Bugs here)

What page are you trying to edit the items?

What can you edit or not edit?

321

(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

(216 replies, posted in Modules Add-on's)

Now you need to activate it....select the dropdown menu at the top

@kvvaradha whats a lac? Do you mean 100,000?

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

Is it anything in php.ini or mysql.cnf settings???