Valuation Miscellaneous Receipt with Last Recepipt cost

SUGGESTED

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.

Top Replies

Parents
  • By design Last cost is updated with the latest stock receipt (misc. receipt included).

    Hi  , therefore you previous example, is opposite to the afirmation? (maybe is my english)

    "See before misc. receipt:

    Both Last receipt cost and Last purchase price remain identical after the misc. receipt created at a different order price:

      "

    About the standard cost, i can not understand "Indeed, if you are using standard cost, following your proposition, the system should fed the above costs with the value matching the standard cost."

    ast price, Average cost, Lot Average cost and FIFO are always calculated in Sage X3 disregarding the valuation method setup (based on VARORD and not VARVAL). Indeed, if you are using standard cost, following your proposition, the system should fed the above costs with the value matching the standard cost.
Reply
  • By design Last cost is updated with the latest stock receipt (misc. receipt included).

    Hi  , therefore you previous example, is opposite to the afirmation? (maybe is my english)

    "See before misc. receipt:

    Both Last receipt cost and Last purchase price remain identical after the misc. receipt created at a different order price:

      "

    About the standard cost, i can not understand "Indeed, if you are using standard cost, following your proposition, the system should fed the above costs with the value matching the standard cost."

    ast price, Average cost, Lot Average cost and FIFO are always calculated in Sage X3 disregarding the valuation method setup (based on VARORD and not VARVAL). Indeed, if you are using standard cost, following your proposition, the system should fed the above costs with the value matching the standard cost.
Children
  • 0 in reply to Jonathan.gonzalez
    SUGGESTED

    Hi  
    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.

    "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.

  • 0 in reply to Julien Patureau

    Thanks Julien for the new post.

    We will try the development in misc receips and adjust the order price.