Search options (Page 141 of 200)

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

Hi,

Please have a look in  about how to setup initial balances.

/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

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

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

I am not sure. I guess there were more changes, so I would certainly recommend an upgrade. Hopefully you have managed to upgrade.

/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

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

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

You can set the control accounts in the branches. And the customer balances can be taken by categories.

/Joe

If you want to put the dimension on all transaction rows, then you will have to find the 'add_gl_trans_supplier' lines in /purchasing/includes/db/invoice_db.inc, and fill in the dimensions in all lines. The function 'add_gl_trans_supplier' is defined in /purchasing/includes/purchasing_db.inc.
You will have to do the same thing in sales:
/sales/includes/db/sales_invoice_db.inc you will have to fill in the dimensions in all calls to 'add_gl_trans_customer'.
The same thing in /sales/includes/db/sales_delivery_db.inc.
I hope this will do it.

/Joe

Please be a little bit more specific. We have no known errors here. If you suspect a bug, the try to set the $go_debug in config.php to 1 and see if any errors are reported.
Also check that your accounts and account groups/classes are setup correctly.

/Joe