Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 58 of 200)
Topics by joe User defined search
Posts found: 1,426 to 1,450 of 4,985
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
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
Please report (positively) back
/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
I can agree that it looks better with AS, but it is not needed in mysql.
/Joe
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
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
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
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
Posts found: 1,426 to 1,450 of 4,985