Ok, MarkAndrew. here are two new report files, rep301.php1 and rep308.php1. Rename them to *.php and replace in the /reporting folder.

We are now using the price on the stock_moves where appropriate. This price has been converted to domestic values where needed.

I have tested this in your scenarios and it works.

Please give me a feed back. Maybe we after all can use the costed values.

/Joe

@MarkAndrew.

It just popped into my mind, that we can use the stock_moves price when handling receivals, and supp inv/credit notes.
If the price is belonging to a supplier that has a foreign currency, we can calculate the domestic value for the given date.

I will have a closer look at this later this evening.

This way wes could eliminate the problem in you last report.

Joe

I cannot recall why this page has disappeared. However the page only contained tips on how to earn money on open source software.

But still you must follow the rules of the open source GPL v.3.

Among other, you must share the changed source based on GPL v.3 with the community.

/Joe

No, this is not needed.

Joe

I am not sure I am the right person to advise you on that. Maybe sombody in the audience can do that.

Joe

Hello again MarkAndrew,

When you are entereing the high value of 100, The fixed average material cost is set to 100, so when you enter the value at 31.08.14 at 50, the stock_moves standard_cost is calculated to 75. And when we try to calculate back the price we have no prior values to calculate from.
Therefore we get this error.
I am not able to fix this, due to the fact that the standard_cost on the stock_moves is stored based on the fixed value.

So now is the the question? Can we live with this? How often are your latest scenario done? This is the best I can do.

We cannot improve the CIMR and the IVR further based on costed values.

Do you Think we should go for this anyhow, or should be just leave the IVR to not be selectable on date values?

/JOe

You can use the dimensions for that. Have a look in the Wiki about that.

Joe

1,433

(6 replies, posted in Report Bugs here)

Have you tried Another pdf-reader?

/Joe

Yes, but you can Place no tax exempt on the items and instead create different tax Groups and use these on your customer/branches and/or suppliers.

7Joe

Yes, of course. Why not?
If the standard cost is manuelly changed in Items and Inventory tab, it should affect the standard cost for the stock moves all over. Otherwise, the GL is not syncronized with the Stock values.

/Joe

Ok, MarkAndrew. here are two new report files, rep301.php1 and rep308.php1. Rename them to *.php and replace in the /reporting folder.

This work has been extremely difficult, due to the way the standard_cost is saved on the stock_moves. It turned out to be the average material cost after the stock move.
I had to calculate back the actual price, which was fairly simply, but due to various bugs over time my test data is not very good any more. But the algorithms should be ok.

Then add all the actual prices and divide with the counter should now give the average standard_cost over the time selected.

I hope this works and remember the old way with calculating the Inventory Valuation Report by today are still working smile

Please report (positively) back smile

/Joe

BTW, it turns out to be a Little more complicated changing the Costed Inventory Valuation Report.

I am woeking on it and will upload fresh files during the weekend for testing.

/Joe

I know the algorithm for calculating the avererage cost, but this function should only regulate the stock moves standard cost in respect to what was booked in the GL when changing the standard cost in Items and Inventory tab.

/Joe

1,439

(1 replies, posted in Report Bugs here)

I can agree that it looks better with AS, but it is not needed in mysql.

/Joe

1,440

(1 replies, posted in Manufactoring)

The M flag is for item type Manufacturing, B flag is for item type Purchaced and D flag is for item type Service.

The A flag is now redundant and should be removed asap. It was used for simple assembly.

/Joe

Ok, I will have a look at this asap.

Joe

1,442

(7 replies, posted in Installation)

If you are on the same major version, 2.3.XX, where XX. Is a number between 1 and 20, then you should have no problems doing so.

Joe

1,443

(6 replies, posted in Setup)

Just put Contacts on the customer branch with the correct action and email. Also the Company email.

/Joe

Hello again.

3 files are uploaded for testing. Download them and please rename the files rep301.php1 and rep308.php1 to *.php. Upload the two files to /reporting folder and /inventory/includes/db/items_trans_db.inc to /inventory/includes/db folder.

For backward compatibility there is now a flag in config.php (config.default.php) called $use_costed_values. Please enter this variable in the file config.php and set the value to 1. Default value will be 0 for backward compatibility. Select 1 for costed values.
This flag is related to the report, Inventory Valuation Report.

F.i. about line 176:
/* Show average costed values instead of fixed standard cost. Default value 0 */
$use_costed_values = 1;

The fix for changing the manuelly cost update will first work from now, so eventually old cost updates will not influence.

Please test and report back.

/Joe

I Think I have found a solution to the manuel change of standard cost.
If a change is made to the item, then when saving the cost update, the stock_moves get the standard_cost updated for the difference and where the stock moves are <= the date.
This should eliminate the difference from the IVR and the GL when taken Before todays date.

I will upload three files here when fixing this and please download the files and help me testing this. The files will be /inventory/includes/db/items_trans_db.inc, /reporting rep301.php and &/reporting rep308.php.

Especially Apmuthu and MarkAndrew.

Thanks in advance.

/Joe

1,446

(1 replies, posted in FA Modifications)

The transactions are in the table X_gl_trans, where X is your Company number.

/Joe

Well, the problem here is that you are allowed to change the standard costs at any time, which changes the GL as well, but does not change anything in the stock moves.
This will give an incorrect value in the IVR compared to the GL if taken before todays date and the standard cost has been changed manuelly.

The CIVR should give the correct costed value over all periods. If not, please download the final file here. However if you have changed the standard cost manuelly, it will show an incorrect value.

/joe

Maybe we should take away the date selector from Inventory valuation Report, and force users to use the Costed Inventory valuation Report for selecting periods. What do you say guys?

Joe

When you use the delivery from sales order, you can deliver parts of the sales order.

Joe

But you can use the costed invnetory valuation report, right?

Are you saying, that this report should work just like the costed inventory report?

I am not sure if this is right. Somebody in the audience has earlier asked for the change as it is now.

Joe