STILL WRONG COSTS - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8) +--- Thread: STILL WRONG COSTS (/showthread.php?tid=2583) Pages:
1
2
|
STILL WRONG COSTS - giusba71 - 09-28-2015 Another average cost completely wrong! 282.16 [attachment=392] with only two movements at 17.65 !!! [attachment=393] WHAT CAN WE DO ??? RE: STILL WRONG COSTS - TimSchofield - 09-28-2015 webERP is calculating the costs properly (I think) but the information that the calculation is based on is flawed for some reason. We have two receipts 30 @ 17.64 and 30 @ 17.635 then a reversal of 30 @ 0 and a transfer of 28 @ 0 It is this reversal and transfer that has obviously incorrect costs against them that is throwing the calculations so far out. Was the supplier invoice entered before the transfer was done? Tim RE: STILL WRONG COSTS - giusba71 - 09-29-2015 This is only one example of the wrong cost calculation, please look at my previous posts for others examples, where I also found negative costs. No, the invoice is not entered before the transfers or issues for WOs, becauce we CAN'T. We receive the invoices after 30-60 days the delivery of the goods. Please, could you tell us where/when the costs are calculated, we will try to correct this with our SW Dept. RE: STILL WRONG COSTS - TimSchofield - 09-30-2015 (09-29-2015, 08:35 PM)giusba71 Wrote: No, the invoice is not entered before the transfers or issues for WOs, becauce we CAN'T. This will be the cause of your problems then because the cost is being updated when the supplier invoice is entered, but you have already done some transactions at zero cost which will give you the distorted weighted average cost. Tim RE: STILL WRONG COSTS - giusba71 - 09-30-2015 OK, where is calculated the weighted average cost? We would change the code to set the transactions at "order cost" instead of at "invoiced cost". RE: STILL WRONG COSTS - TimSchofield - 09-30-2015 The calculation of a new weighted average cost occurs wherever a change occurs. The one for the goods being received is in SupplierInvoice.php, however.... Moving that code to the goods received section and calculating on ordered cost at that point is fraught with many issues, such as how you deal with the situation of the invoice coming in at a different price than the order. As an accountant I would strongly advise that you run any changes you make past your accountants/auditors before using them. Tim RE: STILL WRONG COSTS - giusba71 - 10-01-2015 If I haven't got the invoice at the goods incoming, what else can I do? One is value the movements at average cost, so the cost doesn't change. Another is value the movements at order cost, so the cost moves near the real. But sure, is not a good idea to value the movements at cost zero! I personally insert the supplier invoices and maybe the 1% of the times the invoiced price differs from the order price. In this cases we can re-value the movement at invoice cost, or not? Then I've seen that the invoice total can be higher of the purchased items total, but not lower. For this reason, in invoice entering, isn't possible insert discounts. If I buy 100 items for 1000 EUR and at invoice stage the supplier apply a discount of 33% because he was happy, I have no way to apply the discount at the total of invoice (unless hand calculate and insert the discounted price for every one of the 100 items). RE: STILL WRONG COSTS - Exsonqu_Qu - 10-02-2015 Hi, I think you should set the initial standard cost correctly. Best regards! Exson RE: STILL WRONG COSTS - giusba71 - 10-02-2015 I've set the standard cost for all items during the first installation in january 2015. Now I've just found another negative cost. [attachment=394] I'm sure that it wasn't present in september, because I've checked all the inventory for negative costs. Looking at the movements there are no operations after july [attachment=395] Why the cost of this item is now negative? There are procedure of cost maintainance running at scheduled intervals? RE: STILL WRONG COSTS - agaluski - 10-02-2015 There are two methods I use to track down why, when and how something happened in WebERP when dealing with costs. 1) Use the Audit Trail (On Setup Menu). Search all tables and users for the part# in question 2) Run this query against the database PHP Code: SELECT * FROM `gltrans` WHERE narrative LIKE '%<YourPartNumber>%' |