Valuation Miscellaneous Receipt with Last Recepipt cost

Question

Hello, 
 We have a problem with Miscellaneous Recepipts. We want to valuate them with "Last Recepipt cost". 
 The valuation rule details are: 
 - Receipt source: Order cost 
 - Receipt alternate: Last cost (i dont know whye the possible values are differents than the previous picklist). 
 - Exception: Miscellaneous Receipt; Valuation source = Last cost. 
 Example: in product-site "Last receipt cost" = 22. I create a miscellaneous receipt, qty=1, value=23. Therefore the product-site "last receipt cost" change to 23. I would like to maintain 22.

Julien Patureau · Answer

Hi Jonathan.gonzalez Indeed my initial test was showing no change after the misc. receipt, there is an inconsistency and I have reported the question to the support. But the on-line is very clear: misc. receipt should update the last receipt cost (based on the order price). So this will not help you here. 
 Jonathan.gonzalez said: " Indeed, if you are using standard cost, following your proposition, the system should fed the above costs with the value matching the standard cost. " 
 You are expecting the last cost to remain identical after a misc. receipt because the valuation method is set with last cost. This is not the product logic, we are not using the valuation amount (VARVAL) but the order price (VARORD) to update the last cost (and other costs such as AVC). I tried to explain why using the valuation amount (VARVAL) is not a good idea to update the last cost by setting an example with standard cost. If you use standard cost to value your misc. receipt (VARVAL = standard cost), then the last cost would be, accordingly to your suggested logic, equal to the standard cost. This will forbid any possible stock valuation simulation / comparison between last cost and standard cost. Moreover, if you decide to transition to a valuation method using standard cost to last cost, the initial value would be incorrect. I hope I am clearer in this new post.

Sage X3

Valuation Miscellaneous Receipt with Last Recepipt cost

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING