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
You can use either application to create/update customers. Just remember that in FA you must also create at least one branch. You can look into the module Import Customers for this.
If you call it from TikiWiki you must connect to the FA company database and do the updates/creation, and vice versa if you do it from FA.
Another way would be to create a module extension in FA to sync the two customer tables. Look into the Import Customers about how to make a module extension.
/Joe
It is called Install / Update Extensions from 2.2.
GD is a Graphics Library. It is used inside Business Graphics. You can check your php installation with the php routine phpinfo() and see if, and which version, you have. You can use FA without the Business Graphics.
/Joe
The avg. standard_cost is stamped into the stock_moves table when delivering the items (either during delivery or direct invoice). This stamp is based on the average material cost on the delivery day for the item. So this value will also be the value that is stamped into the GL transactions when creating the delivery (direct invoice).
So with the changes done now, we should always ensure the correct values in both GL and Inventory Sales Report for the same period.
/Joe
Upgrading from 2.3RC2 to 2.3RC3 and 2.3 Final is just a matter of copying files unto your server. There are never database changes between minor releases.
/Joe
It is never easy to move from one accounting system to another. Some of the modules on the Download - Modules may help you import customer/supplier and items.
You should also consider using a newer release, as 2.2.11. And we are shortly releasing the 2.3 final.
/Joe
There is a Report, Audit Trail.
/Joe
Yes, I have sent you the new COA by email with instructions. You should change the remaining texts and localizations.
/Joe
Hello Popsicles12,
I have been following your topic carefully and I see that we in the stock_moves table stamps the average standard cost at the time being recorded. There are no stamping for Work Orders. So I would suggest changing the algorithm in Inventory Sales Report to use this field instead of the overall average standard cost if the field is non zero.
This will go into 2.3 release, but you can change the following row in /reporting/rep304.php, line 46 into:
SUM(-IF(".TB_PREF."stock_moves.standard_cost <> 0, ".TB_PREF."stock_moves.qty * ".TB_PREF."stock_moves.standard_cost, ".TB_PREF."stock_moves.qty *(".TB_PREF."stock_master.material_cost + ".TB_PREF."stock_master.labour_cost + ".TB_PREF."stock_master.overhead_cost))) AS cost/Joe
No, there are no cash flow statements included, but you can help us build one. No payroll module is planned to go into core FA.
/Joe
Hi,
Please have a look in about how to setup initial balances.
/Joe
Yes it will work, as long as these 8 small small companies doesn't have its own accountancy requirements for legal reasons. If it is only branches of your company, that you are interested in profit/loss statements, then it should work.
/Joe
Hello again Bin,
I have now prepared an Italian COA for FA 2.2.X. Unfortunately the account groups/types are not sorted correctly in 2.2.X the way it is setup in the Italian COA. This is, however, done correctly in the upcoming release 2.3 that are now shipping in 2.3 RC2.
So I would suggest that I convert the new COA to 2.3 before sending it to you for further fixup. Is that ok for you? Do you have 2he 2.3 RC2 setup?
/Joe
Thanks, I will have a look at it. I will then convert it to a FrontAccounting COA, however there are still some items that need to be translated in the COA. I will send you it when ready.
/Joe
Well, there are various ways of doing this. But it will require more fields in the user table.
However you have an option to show how many users that are currently on-line by setting the variable:
$show_users_online = 1;
in the config.php file in the root of the installation.
/Joe
Hi,
First of all you don't need the JOINs. You do not have that much information on the suppliers that you need this. But you may want some other information from the suppliers table.
The transactions should be taken from the supp_trans table instead of debtor_trans table.
I hope this is adequate info for you. If you end up with a nice and usable report, please share it with us.
/Joe
If you have some kind of an Italian Chart of Accounts that can be exported in a comma separated file, I will help you convert it into a chart of accounts for FrontAccounting.
/Joe
Hello,
You can change the average standard cost in Itens and Inventory to what you want it to be, lower right. This operation will, however, create a difference record in GL.
/Joe
I am not sure. I guess there were more changes, so I would certainly recommend an upgrade. Hopefully you have managed to upgrade.
/Joe
Hello again,
You don't have to change the purchase data every time it changes. Just enter the new price in the purchase order line. When the items are received, the purchase price, description and UOM (can be changed here as well) are updated automatically and will be suggested the next time you enter the item for the next PO. Even if the prices changes when entering the Supplier Invoice, it will be changed automatically in purchase price data.
The average material cost is updated also both during PO receive and (if changes in invoice) during supplier Invoice.
As a last resort, if you see something is not correct, you can change the average material cost under Items and Inventory, Standard Costs.
/Joe
If you refer to the report, Inventory Sales Report, the price column is the actual price per the transaction date eventually changed to domestic currency. The cost column is the overall average material cost.
I need more information, a concrete example, so I can follow your operations.
/Joe
I cannot reproduce this error. Please try the new release 2.3 rc2 that we are releasing later today. Something seems to be out of sync.
Please report after trying the new release.
/Joe
Yes, I would recommend an upgrade to 2.3 rc2. This release is about to ship this evening.
But still there might be bugs left, so take care 
/Joe
You have run into a bug in 2.3RC. Please look at this topic:
/Joe
Problem fixed. You can download the following files from the CVS repository:
copy it into /purchasing/includes
and
copy it into /gl/includes/db
You will have to void the supplier invoices and reenter them again.
Thanks for reporting this severe issue!
/Joe
I guess you have run into a bug in 2.3 RC1. This worked fine in 2.2. This bug will be fixed asap.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.