3,851

(2 replies, posted in Wish List)

Well, Khaled. We have just implemented a selector for either decimals (user setup for decimals) or rounded values).
Maybe we in the future could change the selector to show with user_price_dec(), rounded, hundreds and thousands, but with these values we need to put that information on the report.
I guess we are talking Balance Sheet and P/L Statements here, right?
Regarding A3, isn't this quite rare? Not many use these sophisticated printers. Maybe you should consider creating a report like the one that is downloadable from the Download section. This report uses Landscape and can hold much more information. Just a thought.

Maybe you can put this on the Wishlist on the Wiki, Khaled.

/Joe

You are charging the customer for a fee, so it should be in the income section. However there is already an expense account for Bank Charge but this is merely for your own costs. So my advise is to create this in the income section.
Please check if you should charge tax on this wire amount. If not you should mark this with the correct item tax type. The item should be as a service.

If you have this cost yourself, then you should enter the fee in the bank charge field. The item code from the invoice line will only handle the sales (sales tax, charged bank fees and so). So you will most likely enter this cost when you do customer payment.


/Joe

3,853

(4 replies, posted in Setup)

You are right, it should be an income account (you charge your customer for this amount). I have created a new account, called 4910 Shipping. And put this on GL Setup for Freight.
The changes are uploaded to Website.

So please make this change locally. Thanks smile

/Joe

Hello again,
Regarding the Retained Earnings account I see that there is a SHARE CAPITAL group. I didn't realize that there was such a group. There is also an account, called 3200 Profit and Loss. This account belongs to SHARE CAPITAL group.  We will rename 3200 to Retained Earnings (instead of Profit and Loss).

So please select this account 3200 for the Retained Earnings in GL Setup and rename it in the GL Accounts. You may also delete the other setup Retained earnings you did before.

I will do the fix in the COA.


/Joe

Thanks,
I will make the changes and upload a new COA for en_GB-general.

/Joe

3,856

(27 replies, posted in Dimensions)

A pity you didn't know this. It is not the dimension id that is shown in front of the dimension, but the reference number. If you don't change that during creation, it will use a numeric serie, identical with the internal id.
So when you created the dimension, you could have put MJ125 in the first reference field. You can freely overwrite this reference nr, but it has to be unique inside the dimensions.
You could, without any side-effect, use phpMyAdmin to change your dimension references in the reference field. Then you could probably give them a more relevant name too.
After this you will have the list sorted by reference numbers and name.

/Joe

This feature, multiple items of same item id, is implemented in release 2.3. You can use the memo field for extra info. This info is printed on the PO/SO/INV after the lines.
In the Sales docuemnts you can click a line down, and add/change extra info to the description.

/Joe

The sentense you changed has been commented out in the code and gone into a later algorithm, where you can see how the average cost is calculated and also the adjustment when it arrives.

Well, it should work now, but you know, maybe it is safe to wait. I have tested it rigorously, but the developer should maybe not be the main tester.

If you do not enter a temporary Standard Cost for your 0 stock new items, you will not get any COGS values in the GL untill you get a PO or Item Adjustment, because there are no Standard Cost values to fetch. It is, however, corrected in the long run.

/Joe

Hi again,
The CURRENT LIABILITIES should be of class type Liabilities.
The Retained Earnings should belong to LONG TERM LIABILITIES if there is no EQUITY group. However, you don't need this EQUITY group.

/Joe

The two first accounts is used by Fiscal Year closure. There should be a relevant account in the Liability/Equity section you can choose for Retained Earnings. If you can't find a suitable account for Profit/Loss Year, then create one. It should be the last one in the Expense groups.
There should also be an expense account for Bank Charges. If not, then create one in the Expense groups.

/Joe

We have just fixed it and the CVS Main trunk is updated.
We can not use the proposed approach from the Company Setup, because we don't know if it is filled correctly.
What we do, is almost the same way as they do in Oracle and QuickBooks.
If there is an Average Standard Cost before the stock goes below 0, this is used until we get some better values from PO or Item Adjustments. Then the GL Inventory/COGS are updated in the background.
If you have new items and you want a start value for Standard Cost, then you can set in in Item and Inventory tab, Standard Costs.
You can enter an initial Standard Cost even if there are no stocks there yet.
This has the advance for new items that you get a better estimate for COGS and these values will later be corrected when POs or Item Adjustments are done.

/Joe

Go into Setup tab, Sales Points. Edit the Default Sales Point and update it again. There are some missing setting in the GB COA. This should help.

/Joe

The average material cost is a common way of handling the producs. Other methods are LIFO and FIFO, where LIFO is last in first out and FIFO is first in first out.
Both Oracle and quickBooks are using the Average Material Costs. And we have been looking at how they handle the 'Allow Negative Stock'. There is a possibility to continue with the Average Material Costs during the negative period of stock, but this value is not correct. But when the stock again passes positive values, either with PO or Item adjustments, all the deliveries done during this period will have to be adjusted for correct values.

We will fix it in this way, but it will take a while.

/Joe

In the GL Inventory, it is not possible to have a negative inventory stock value. This is physical impossible. Just like you cannot have a negative cash. Therefore when the stock is going negative the average material cost is going to be set to 0. First when the value is going into a positive value again, the average material cost is growing again.
When you later buy the stock that is missing, the values will not increase the GL stock inventory before the stock item value is over 0.

You must be avare of that. If you operate with this flag set, you should always check the values when the stock is positive again and make adjustments in the GL.

/Joe

3,865

(8 replies, posted in Banking and General Ledger)

Try emptying the browser cache.

/Joe

3,866

(1 replies, posted in Reporting)

Please write enable your /company/1/ and sub-folders.

/Joe

3,867

(16 replies, posted in Installation)

Just remove as much of the transactions that you can see, and I will clean the rest and prepare it for a new COA. Just remember to keep the hart_master, chart_types and chart_classes and the standard accounts on the company.

/Joe

3,868

(16 replies, posted in Installation)

You can just send the sql dump as an attachment. They are not that big. Or you can zip it.
If there are more companies in the file, I will pick the one with 1_ as table prefix.
If they have a 1_, in front of the tables (table prefix), I will change them to 0_. 0_ is the standard in the COAs. This prefix will be replaced when you the create company in FA. If you want such a file with 1_ or other values you must first make a search and replade (1_ should be replaced by 0_). But as told, I can do that for you and I can adjust the COA as much as possible.

/Joe

3,869

(16 replies, posted in Installation)

Hello again,
Remember first to make a backup of your company smile

You can send the sql dump to:

contributions@frontaccounting.com

/Joe

3,870

(2 replies, posted in Reporting)

Hello Khaled,
The use of the font utily package is quite complex. When I started create some fonts, I did get some information on the TCPDF website, ,  on how to use it.
They also have some forums here.
I am afraid that this all I can help with.

/Joe

Hello again.
Presenting the 'Calculated Return' on the balance sheet is an amount that the company owes you. Thats the reason for the minus sign here. The total balance of all accounts (both balance sheet and P/L) should be 0, right? This is the reason for that.

/Joe

3,872

(16 replies, posted in Installation)

Hello again,
The Dutch COA from our Website - Download, have been created by others. It may need some fine-tuning. If you do this, please return a fine-tuned copy back to us. We will be appreciated.

/Joe

3,873

(16 replies, posted in Installation)

If you only use one account for the profit/Loss year, you don't have to close all the other income/expense accounts.
This way it is possible to retrieve profit/loss over several years for a dimension, acting as a project. There are other advantages to this. You can still make PL statements on closed years. Instead of a Calculated return, you will get your result in the Profit/Loss year account.

You can read more about this in  under fiscal years.

/Joe

3,874

(2 replies, posted in Installation)

Look in the CHANGELOG.txt.

/Joe

3,875

(5 replies, posted in Items and Inventory)

Accountings must be done inside a fiscal year. Fiscal years isolate the various years to accounting for that year.
If you don't have a fiscal year for 2010, then goto Setup tab, Fiscal Years. Enter a suitable fiscal year.
Now goto Company Setup, in the Setup tab also, and select this new fiscal year for the company.
Now you are ready to begin.

/Joe