I have a list of customers, which i usually select to allocate off the customer transaction. There is one customer with a long list, I can't seem to allocate the funds and process it. I am using a linux server with apache and mysql. Wonder is there is a specific memory allocation for the process of allocation customer payment. Where as if I use it on xamp, it works fine.

So, wondering if there is any specific guidelines of memory allocation for linux server.

Not sure if this is the right place to put the topic either. But so far, only the allocate customer payment or credit note is giving me the problem.

I've manage to create a Bank Reconcile report/statement for print. How can I share it out?

I'm using FA 2.3.5. I go into the reconcile bank account under Banking and General Ledger.

I can check to reconcile the transaction. But it doesn't do any other thing. Is there a step whereby I can print out the statement that I have checked out (reconciled transaction)?

if there isn't an option to print the report, what are the tables I can look into to produce the report I need for the reconcile bank account statement?

Looking for some answers.. thanks in advance.

Hi I am getting a yellow triangle when I do a GL inquiry. I have quite a number records
in the database but I can only get about 15 days worth i.e (01/01/11 - 01/15/11) any greater
and I get a yellow triangle with an exclamation mark.

Doing a search on the forum I have tried disabling java script.
This seems to solve the problem I can get over two months of record, without any errors displayed.
(with decent loading speed)
I have turn on the debug go_debug in the config.php but there is no error either.

I have tried increasing the tout value to 600000 in the util.js file but there do not seem to be any
difference.

I have also tried to increasing the memory values in phpmyadmin my.ini file
key_buffer              = 256M
max_allowed_packet      = 10M
table_cache             = 512
sort_buffer_size        = 32M
net_buffer_length       = 1M
read_buffer_size        = 1M
read_rnd_buffer_size    = 1M
myisam_sort_buffer_size = 32M
innodb_buffer_pool_size         = 256M
innodb_additional_mem_pool_size = 20M

and the php.ini
post_max_size = 128M

Does anyone have a solution or suggestion that I can try?

It would be greatly appreciated

5

(4 replies, posted in Reporting)

great! thank you.

6

(7 replies, posted in Setup)

I found away you can add your company logo into the top left corner of your pages. Just open your default.css of the theme you want to you. In my case, I use the Modern Theme.

Look for h1 and add in the codes. e.g.
h1 {
    font-size: 14px;
    margin-right: 20px;
    /*color: #466f01; title*/
    background: url(images/YOURCOMPANYLOGO.png) no-repeat; /*left tab image path*/
    background-position: left;
}

Hope this helps! I'm going to try it on the new executive theme...

I manage to display the user login name and display name inside page after login. The file is renderer.php in whichever theme you wish to use. Just add this code above the "preference" code line.

echo "<li><b>Welcome: </b>" . $_SESSION["wa_current_user"]->username . " (" . $_SESSION["wa_current_user"]->name . ")</li>\n"; //WELCOME USER

Hope this helps.
Note: You can change your text "Welcome:" to something else you based on your preference.

8

(4 replies, posted in Reporting)

this is very helpful. Anyway, I can align the text to the left instead of appearing in the center?

9

(4 replies, posted in Announcements)

ok, thanks

10

(4 replies, posted in Announcements)

I've checked. But how am I suppose to download the themes when I installed it locally on my pc? It doesn't connect to the internet and download from your site.

Hi Joe,

How do you make the bank account that you choose to appear instead of the first bank account that is automatically chosen?

Maybe you can stick them in set of numbers. That way, its easier for grouping and displaying? Like an example:

10000000    ASSETS *
11000000   CURRENT ASSET *
11010000    CASH EQUIVALENT *
11010100    PETTY CASH  *
11010101    PETTY CASH COMPANY

Just a suggestion

13

(2 replies, posted in Wish List)

Can the discount be number/amount instead of percentage? I didn't see a posting based on the search, so I thought of adding here instead. Thanks.

ya, make it more icon based, where we can change the icons. A dashboard layout. That's nice.

After further testing, when I turn off my javascript enable in browser, the query results come out. But the query results still took longer time to display. Anyway, or tutorial help to maximize the mysql settings? I'm using phpmyadmin in xampp.

So far I have entered 3600 transactions. I can only view the journal inquiry transaction with only 5 days apart. I can't view the journal transactions from January to December or (example: February to June). The processing error displays a "triangle error image". Is there a buffer size I can increase? Or an error log I can view what is the error display is saying? Any way to solve this problem? Thank you.

Under Banking & General Ledger, --> Balance Sheet Drilldown.

Currently, it will display the main eg. Assets , Liabilities, etc... table with the respective current assets, fixed assets and so on.

If I click on the Current Assets link, it will go to the 'next page' displaying the items under Current Assets. If I want to go back, I would just click on the Back link.

Example:
Assets
- Current Assets (if I click on this link...)
- Fixed Assets
- Total Assets

'next page' displays:
Current Assets
- Inventory Assets
- Total Current Assets


Is there a way that I can display the drop-down of the items under each Assets (Liabilities and so on) in the 'same page' without jumping to the 'next page'??

Like so:
Assets
- Current Assets
  - Inventory Assets
  - Total Current Assets
- Fixed Assets
- Total Assets

Any idea on what scripts I can use to make it possible.. javascript, collapsible table php scripts, etc. Need your expert advise.

Thanks.

is there anyway, I can change the sorting to Name instead? I'm using the version 2.2.11. Which file I should be looking at? /gl/manage/gl_account_types.php?

thanks

I'm so happy that the GL Account Group can add with multiple levels - subgroup of. However, when I add more and more items into it generating multi-levels, the data entry becomes slower and slower but when I view on the database table, the data is merely less than 10Kb.

Any idea why it is like that?

I also found a php script that says can repair the mysql table - repair.php

<?php
require("config.php");
$host = $dbhost;
$database = $dbname;
$username = $dbuname;
$password = $dbpass;
mysql_connect($host, $username, $password);
@mysql_select_db($database);
$res = mysql_query("repair table ".$prefix."_XXXX");
if ($res) {
    echo $res;
} else {
    print (mysql_error());
}
?>

The outcome result I got was "Resource id #4"

Any idea on what it means? Just want to know how I can overcome the slow processing of data entry.

Thanx a million

20

(4 replies, posted in Translations)

ya, I think this is a good feature. Would like to see it in future modification. Will help out in translation if needed.

Hello, I just want to say its very good erp program. I'm still customizing it for my own company. And the demands from my accountants! Phew! I'd like to ask if there is any way to restrict the number of users logging into the frontaccounting?

Example:
user admin. If some dumbo go and give the user admin login to other personnel within the same staff level, there is practically no way for us to keep track of who has access and how many people is access it simultaneously, right?

Is there a function where I can set, the user admin to be able to log only 3 limit of the same user-name?

Or, maybe can restrict only a number of users to login.

Hmm, yes. Would like to know if there is a way to change the sorting of GL Account Group. Currently I don't see how it is sorted. By ID? Name? Subgroup of? or Types? I'd like to make it sorted by Name. Is it possible? Probably a permanent setting?

Much appreciate.

thanks for the tip. that was enlightening. however would be good if i can view who is online. will try some programming. if it works will share it out. By the way, thanks.

Hi, do you know a script or anyway to keep a status track of user logins. Maybe a seperate script to run and display the current users logging into the FA.

example: simultaneously an accountant and stock manager logins in, I run a script and able to see the status of user logins with a stamped time-in and log-out.. etc.

is this possible?
Your help is appreciated.

25

(1 replies, posted in Reporting)

Hi, I would like to add a supplier details listing on the supplier report & analytic just like the customer details listing. Would like to know what I should include.

Was trying to replicate the customer details listing coding for supplier but having difficulties. not a hardcore php programmer.. just a beginner but willing to learn.

as I know, for customer details listing, its using the debtors_master table. So, for supplier details listing, I should be using the suppliers table, right? But I notice in the customer details listing rep103.php it includes other data field from other tables as well. Do I need to include some data related fields from other table as well for the Supplier details listing? need your expert advise.

So far, I've done:
- duplicate file for rep103.php to rep205.php
- duplicate code in reports_main.php
- currently stuck at coding for rep205.php

Need help with the function codes.