It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by 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
Try emptying the browser cache.
/Joe
Please write enable your /company/1/ and sub-folders.
/Joe
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
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
Hello again,
Remember first to make a backup of your company 
You can send the sql dump to:
contributions@frontaccounting.com
/Joe
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
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
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
Look in the CHANGELOG.txt.
/Joe
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
Hello Tom,
In the Bank Deposit form it is possible to enter a Deposit from a Supplier and the same thing in the Bank Payment enter a payment to a customer.
It may seems odd, but it is possible to do it. This is the reason for the column.
However it seems right to show the supplier reference number on the Payment to Suppliers instead of our transaction no.
/Joe
CVS Main updated with /includes/banking.inc
/Joe
Yes, tom. We will have to test for null values in currency_code. I will fix this in /includes/banking.inc
/Joe
The bug arose when purchasing service items from a supplier. And something was changed a while ago.
This bug has been fixed and CVS Main trunk is updated. You can also download the affected file, /sales/includes/db/sales_deliveries_db.inc, here:
/Joe
If you create a service item, it should never show up in the GL inventory account. It is the Item Type (Service) that controls how the item is handled. The Category type is only a way of categorize the items.
Even if there are accounts for inventory in the database, it has no effect of how the item is handled. It is the item type that controls how to handle it.
/Joe
Hi,
Maybe your folder /company/X/pdf_files, where X is your company number, is write protected?
/Joe
Hello, I have put your topic into the developers mailing list, Khaled.
We are having a good discussion here in the developers mailing list, and it seems to go your way, thanks to among others, Tom Hallman, US.
/Joe
Default the en_US-new.sql COA follows, which is a small US COA.
On the Download section of this website you can find UK COA.
After you have installed the Training Company (en_US), you can create your own UK comapny.
/Joe
I see. Please Khaled, enter this topic in the developers mailing list. So we can have the material inside one thread here.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.