09-28-2015, 09:55 PM,
|
|
giusba71
Senior Member
|
Posts: 62
Threads: 29
Joined: Feb 2015
|
|
STILL WRONG COSTS
Another average cost completely wrong!
282.16
with only two movements at 17.65 !!!
WHAT CAN WE DO ???
|
|
10-01-2015, 01:04 AM,
|
|
giusba71
Senior Member
|
Posts: 62
Threads: 29
Joined: Feb 2015
|
|
RE: STILL WRONG COSTS
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).
|
|
10-02-2015, 10:04 PM,
|
|
giusba71
Senior Member
|
Posts: 62
Threads: 29
Joined: Feb 2015
|
|
RE: STILL WRONG COSTS
I've set the standard cost for all items during the first installation in january 2015.
Now I've just found another negative cost.
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
Why the cost of this item is now negative?
There are procedure of cost maintainance running at scheduled intervals?
|
|
10-02-2015, 11:00 PM,
|
|
agaluski
Senior Member
|
Posts: 326
Threads: 74
Joined: Jan 2014
|
|
RE: STILL WRONG COSTS
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>%'
You will probably find the transaction type that caused the problem with a narrative of "<YourPartNumber> cost was 0 changed to d.cc x Quantity on hand of 999" or "<SupplierNumber> - Average Cost Adj - <YourPartNumber> x 999 x d.cc" or something similar
|
|
|