4,926

(5 replies, posted in Report Bugs here)

Hello,
Thanks. Regarding the Invoice No/Reference no. Most companies use their own number series for their Invoice Numbers (the Reference) instead of the autoincremented Invoice No. This is the reason that we chose to use the Reference instead. We could probably use a switch inside config.php for doing this.
Regarding your suggestions with directing the pdf, we have used this before, but had some problems with some browsers. This was the reason to use our own presentation. Are you sure that this is browser safe now? If you are, then we will try it again.

/Joe

4,927

(5 replies, posted in Report Bugs here)

Hello,
We are aware of this. Can you point out a solution for this? It should probably be done in the include file /reporting/includes/pdf_report.inc.

Joe

4,928

(11 replies, posted in Report Bugs here)

Hello,
Thanks for your contribution. Regarding #1. Do you have a solution to that?
Regarding #2. These 2 lines with str_replace() is neccessary. The first line is for empty chart of accounts. They are marked with a 0_ table prefix and are replaces with the current company table prefix. The second line is for the Report Generator SQL file. A table prefix of Y_ should be replaced with the 0_ prefix. Could this be rewritten to work with your test?

Kind regards
Joe

Hello,
Thanks for your contribution. I will answer your questions by referring to your list numbers.
1. The phone numbers etc, are not belonging to the customer, but to a branch (branches). The reason to have this separated is that it might be a one to many relationship. In database technology it is called normalization. A company can have one or many branch addresses for deliveries.
2. The same thing regarding the Items. We can have prices for retail, wholesale, and for various currencies. Again this is a one to many relationship.
3. The check writing has not been implemented yet. You can use the ACH transferring in the US.

If you want to build another application based on FA, you are welcome to do so.
We will not change the kind of infrastructure we have built, because it is our experience that this is the right way of doing it.

Kind regards

Joe

4,930

(14 replies, posted in Accounts Receivable)

Yes, that could reveal some smart things. Though, we will not implement a framework for doing this, but we could probably find some way of doing it.
Regarding the AJAX, we have already worked on that and found a good script with very small footprint. You can take a look here for a very early example:
https://frontaccounting.com/grid/sample16.php. It is our plan to implement AJAX in release 2.0. It will require a lot of rewrite of the code and probably make it even better.

/Joe

4,931

(14 replies, posted in Accounts Receivable)

Hello Steve,
I agree on that it would be nice to change the layout of the documents. But as we do not have a report generator, we have to think smart. As you mention, it could be an approach to have some editable templates to work from. Something like ini-files where we could place the coordinates in millimeters (or px's). And of course an add-on module for editing/creating such templates. And see instantly how these templates looks like in PDF.
And of course we should be able to select the various templates somewhere.
Well, we have to think a bit more, before starting with this, but it would be a real improvement to the system

/Joe

4,932

(14 replies, posted in Accounts Receivable)

Thanks for this contribution. Glad to see these suggestions. We can not guarantee that all these attributes will be implemented. Some of them are already in the planning stage.
FYI, if you set a variable in CONFIG.SYS, $loc_notification, to 1, an email notification is sent to the location email if the stock available is below the reorder-level. This require release 1.15. On every stock location, you can set an email adress.

Will take a closer look into this.

/Joe
PS. Are there any suggesitons about improment to the item reports etc.

4,933

(9 replies, posted in Setup)

This is an extract from the file CONFIG.PHP regarding the User Access Levels:

"Security Group definitions - Depending on the AccessLevel of the user defined in the user set up the areas of functionality accessible can be modified.

Each AccessLevel is associated with an array containing the security categories that the user is entitled to access Each script has a particular security category associated with it.

If the security setting of the page is contained in the security group as determined by the access level then the user will be allowed access.

Each page has a $page_security = x; variable

This value is compared to contents of the array applicable which is based on the access level of the user.

Access authorisation is checked in header.inc this is where _SESSION["AccessLevel"] is the index of the security_groups array. If you wish to add more security groups with then you must add a new SecurityHeading to the security_headings array and a new array of Security categories to the Security Groups array

This mechanism allows more fine grained control of access security_groups is an array of arrays

The index is the order in which the array of allowed pages is defined new ones can be defined at will or by changing the numbers in each array the security access can be tailored. These numbers need to read in conjunction with the Page Security index"

$security_headings = array(
              _("Inquiries"),
              _("Accountant"),
              _("System Administrator")
    );

    $security_groups = array(
            array(1,2),
            array(1,2,3,4,5,6,7,8,9,10,11,12,13,14),
            array(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)
    );

As you can see there are 3 levels of User Access Levels at present. The corresponding arrays shows which pages a user can access. Every page has its own security level.

/Joe

4,934

(14 replies, posted in Accounts Receivable)

Hello Steve,
The Item code field is a helper field for quickly entering the item. You should set 'Show Item code' in the Setup - Display Setup. If you do that you will see that the list to the right of the Item code field tries to follow your entry. The list field has the correct entry. As soon as you see it you can press the Tab key (or Enter key). If there is a price entered for the item and currency, it will now show up. All these entries require that javascript is enabled.
Sounds great, Steve, that you are sharing a chart of accounts for the UK in a while.
If everything is ok, the sales order entry should work without any problems. Please let us know, if you detect an unwanted behaviour .

/Joe

Yes Henry, thanks for helping with this. This was a dum mistake. Bugs fixed in both /gl/inquiry/gl_account_inquiry.php and /gl/inquiry/gl_trial_balance.php. New files at the CVS repository at sourceforge!!! Look in the CHANGELOG.txt.

/Joe
PS. Henry, your testing has been vitally important. Thanks again!

Well Henry,
You got a point here, and it was quite easy to fix so I have fixed it now.
Check out the file /admin/db/voiding_db.inc at the CVS repository at https:/sourceforge.net/projects/frontaccounting .

/Joe

Hello again Henry,
Yes you are right that bank transactions posted using Journal Entry is automatically posted to the bank transactions as well. However, this is a feature only for Administrators. It is the only way to setup an initial opening balance.
While most users are using the admin account, it is easy to use the Journal Entry to enter bank transactions.
You can use the voiding routine for many other type of transactions and several type of transactions are voided as well as the GL transactions. But if you insist, I will try to find a solution for this ;-)

/Joe

Hello Henry,
Are you sure you selected the correct transaction type before voiding the transaction? If you don't select the Bank Deposit, Payment etc., it will not be voided. The GL transaction will be voided as well using these transaction types.

/Joe

4,939

(4 replies, posted in Setup)

Hello Henk,
If you are using a Windows Server, there are some hints in some other topics here.
Otherwise I'm stock. Please help us, if you other guys have some hints.

/Joe

4,940

(4 replies, posted in Setup)

Hello Henk,
I'm not sure if I understand you correctly. Do you mean that you use a remote server, where the PHP is set to safe mode=on? Even if this is generally not a good idea, you should be able to run it anyhow.
You could try to add the following line in the top of config.php:
ini_set("safe_mode", "Off");

/Joe

4,941

(7 replies, posted in Items and Inventory)

Hello Henk,
Great that you solved it. At first it looked a bit complicated. Henk, please specify exactly how you set up your tax groups, to help others with the same problem.

Best regards
Joe

4,942

(7 replies, posted in Items and Inventory)

Hello,
First you setup your various vat rates. Then you build your vat groups. This is an easy way of then using the correct taxgroup on the customers/Items.
I hope this gives a meaning to you, otherwise can someone from holland help him a bit, please.

/Joe

4,943

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

A module for importing Items from other systems has been added to the Download pages.

/Joe

4,944

(2 replies, posted in Report Bugs here)

Thanks Henry for adressing this bug. It was difficult to find, but now it is fixed. Check out the files at the CVS repository at sourceforge. Look in the CHANGELOG.txt file.

/Joe

4,945

(2 replies, posted in Report Bugs here)

Which release are you running, Henry?

/Joe

Hello Henry,
These are known issues. They have a low priority.

Regards
Joe

This bug has been fixed in release 1.15.

/Joe

4,948

(2 replies, posted in Reporting)

But the memo/remark is still there if you look at the GL transactions when you look at GL Account Inquiry, and then press the # field, right.
And when you take a report of Journal Entries. There is not room for the info when Printing the GL Account transactions.

/Joe

4,949

(3 replies, posted in Accounts Payable)

Hello again,
Yes, there was a reason for not calculating the tax on GL lines in both the Supplier Invoice and Supplier Credit note. The reason is that it all depends on which accounts you post to. You have to enter the correct Tax-in values as GL lines as well.
The automatic calculation of Taxes is only working on Item lines. I hope this gives some meaning.

/Joe

4,950

(3 replies, posted in Accounts Payable)

I've had a closer look at it. The Tax works correct when working on Item lines if everything is setup correctly. You are right that when entering GL lines there are no Tax calculations. There might be a reason for that. I will deep into it further.

/Joe