3,976

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

There are no fixed rules regarding the asignment of values. Only the core values are starting at 1. So starting a bit up in the sequence seems to be the way of doing it. And checking with other similar modules that they do not share the same values.

/Joe

No, I am afraid not.

/Joe

3,978

(16 replies, posted in Installation)

Hello, I will try to explain how it works.
And I will explain it in an easy way.
After the fiscal year has come to an end and a new one is created, you may want to close the previous year when the last entries have been done.
Before that your assets have accumulated into $2000. The liabilities have reached $1500. The difference between these $2000 and $1500 is your Equity (or Net assets). $500.
Your revenues have reached $3000 and you expenses have reached $2500. Net income is $500.
Now you want to close the fiscal year. The Net Assets (or Equity) $500 is booked in credit on RETAINED EARNINGS (this account is accumulating the year net assets over years).
The Net Income, $500, will always be the same as the year net assets. So the debit booking of $500 is going to the PROFIT/LOSS YEAR.

When the fiscal year is closed you can no longer make entries into it.

/Joe

A new file can be downloaded from CVS Main:



The fix is going into release 2.2.3.

/Joe

Thanks Bryan, for pointing this out. We will have a look at this.

/Joe

3,981

(16 replies, posted in Installation)

Oops. This routine is inside the file /sql/alter2.2.php that is used when running Software Upgrade.

I haven't heard about problems here, and I find no spurious things here. The memo_ field is escaped.
I guess Janusz will look at this when he is back in office again.
Do you think you can fix the error, tom?

/Joe

3,982

(16 replies, posted in Installation)

You should be able to update directly. Just follow the instructions in update.html.

/Joe

Hello ferre,

For your own safety you should download a fixed file from the CVS repository



/Joe

First ensure you have different GL accounts associated with your Foreign Currency Bank Accounts.
Before doing the operations, you should check if there is an exchange rate for the transfer date. If not then get one.
Every time when you do a bank transfer the routine will check that the underlying GL Transfer against the current bank account are equal based on the date when the bank transfer is done. If this is not the fact, two GL transactions will be done covering the difference.
If you look at the Journal Entry after you have done the bank transfer (where there is a foreign currency involved and the exchange rate are different than an earlier one) there should be two transactions covering the diff.

/Joe

There are no automatic calculation routines for that, but if you make a small adjustment of 0.01 in bank transfer forth and back by year-end date the GL Journal will be updated automatically.
Every time you make a bank transfer with a foreign currency involved, the GL Journal is automatically updated with an exchange correction. So the domestic balance is updated everytime a bank transaction is involved, though always shows the correct domestic balance for the last transaction date.

/Joe

Hello again,
We are using Dimension 1 and 2 for the same thing for the last digits. I know that this was quite common to do before we got the SQL databases. But having the dimensions outside the account string make them much more flexible. That is the reason for not having more than 11 characters in the accounts.

/Joe

You can void the wrong payment and after that do the right one.

/Joe

But khaled, you will still have to make the joins to the other tables and a normal process is to use an sql statements like the one in function get_gl_accounts_all($balance=-1) placed in /gl/includes/db/gl_db_accounts.inc.
Those accounts will be sorted in class / type / subtype / account order and making the joins by an alfa string instead of the numeric value seems not to be easier. So why do that. The numeric variant is more flexible when creating subtypes.

Also I see no idea in extending the account code to 15 instead of 11. It is redundant with all these digits/chars in an account code. Most countries only use 4-5.

But let us hear opinions from other users out there.

/Joe

Yes, and the reason is that the translators haven't translated the menu strings containing key accelerators.
You or others can help doing this by downloading the latest language files from .

/Joe

3,990

(5 replies, posted in Installation)

Hello sananthv

We are just about releasing 2.2.2. We have been replacing all the deprecated functions, so it should now work in PHP version >= 5.3.0.

Please give it a try as soon as it is available. Maybe tonight.

/Joe

I have decided to print Total VAT Incl. if the tax is included on the customer. Else Total Ex. VAT.

/Joe

The tax info placed on screen is a positive side-effect when creating this ability for direct invoice and direct delivery.
We do not have the final info for the tax before the delivery phase.
The tax info is only calculated during the entry of the Sales Order on screen.
In the Sales Order Inquiry the amounts are only including shipping.  Also when you look at the Sales Orders from the Inquiry on screen.

In my opinion the tax info is not interesting during Sales Order phase. The Tax is somewhat zeroed out in the long run.
The customer has the tax deductable and when he sales the items further he add his own tax.

It is ok to discuss this further, but I am about to release 2.2.2 today, so if we should make any changes here it will have to wait until release 2.2.3.

/Joe

I think that you guys means different things here.
Khaled wants a combo selector where he only wants to see the accounts belonging to an expanded type (group) for easier selection, especially if the COA is very big.
And you Chaitanya wants a drill down BS or PL.
Both whishes seem to be fair. Only that the link you presented, Khaled, contains source that are proprietary (not open source).
We will have to rely on our JS expert, Janusz. Maybe he can find someting useful. Unfortunately he is very overloaded with business at present.
Maybe we can move this discussiont to the FA Wiki, Developers section, Wishlist and future development directions for next major releases.
We could then set the planning to go into release 2.3.

This discussion will be inside the current discussion.

/Joe

On a costumer / supplier you can set a prompt payment percent. If the customer has a 2 percents deduction and he pays let us say $98 instead of expected $100 for an invoice. You will see in the Customer Payment that the customer has a 2% deduction. You can now decide to set the payment to $98 and the discount to $2. Btw. you can always do this operation despite the discount set on the customer.
The total amount of $100 is going into the accounts receivable, but only $98 into the bank account. The $2 is going into the account for customer prompt payments.
The same thing happens on the Supplier Payment, only the other way around.

/Joe

I think this is a brilliant idea. Starting with the classes. Then the groups (types), Then the accounts and finally the transactions (with an option to look at the Journal Entry).
It could, as you say, be done in two parts. A BS and a PL.
I guess we need some kind of a Javascript helper to do that, right?

/Joe

3,996

(4 replies, posted in FA Modifications)

Hello Chaitanya,
The ability to edit SO even after an invoice is created was implemented some time ago and was done by Janusz. So far there haven't been reported any problems with this, but let us hope that Janusz will comment on this too.

/Joe

3,997

(1 replies, posted in Setup)

If the addon's are to be used in release 2.2.X then you must follow the new syntax. You should download some of the more simpler modules like accruals22.zip to see how they are built. It is quite simple and by using the new access roles it is easy to setup the addon's for existing and new users of the company.

/Joe

3,998

(2 replies, posted in Reporting)

This issue was related to the module 'Report Generator'. A new version has been uploaded to the Website - Download - Modules section.

/Joe

This issue has been fixed. CVS Main repository updated. Affected file /purchasing/po_entry_items.php

/Joe

4,000

(7 replies, posted in Setup)

In Setup tab, Install/Update Companies, you can set the default company. Then this company will always be default in the listbox when logging in.

/Joe