Average Cost without Dock locations

SOLVED

We Want to find a way to exclude the products that are still in Dock locations from the average cost on the product site level?

For example

I have in Stock 10 PC with average cost of 1$ (The base amount is 10$)  

I received 5PC to the dock location with value of 2$ per PC  , the average cost in product site should not be affected neither the base amount  (should remain 10$ until I move it from the dock location to normal location)

Parents
  • +1
    verified answer

    You can exclude the stock movement posting as long as the stock is in the dock: for this you just need to set a formula on the auto journals. 
    But once, you received the stock: the AVC is updated. Then, don't you want to pre-receive the order instead of doing a dock location receipt? In that case, the stock is not yet created.

    You can use the AVC lot method instead. By simply, creating a new lot at each receipt, you won't have an impact on the existing stock value upon a dock receipt. If you don't manage lot currently, you may try the optional lot mgt and managed a receipt with a lot number defaulted from the receipt number for instance.

    Last, would be to manage 2 sites: one for the dock and one for the rest of the stock. But this method is a huge change and increase the complexity of the managent of the solution: more product-site records, inter-site transfer transactions to do instead of a storage plan, MRP need to be set with inter-site supplier for the related products, you need to ensure the invoice adjustment are properly push to the 2nd site (using cost issue adjustement).

Reply
  • +1
    verified answer

    You can exclude the stock movement posting as long as the stock is in the dock: for this you just need to set a formula on the auto journals. 
    But once, you received the stock: the AVC is updated. Then, don't you want to pre-receive the order instead of doing a dock location receipt? In that case, the stock is not yet created.

    You can use the AVC lot method instead. By simply, creating a new lot at each receipt, you won't have an impact on the existing stock value upon a dock receipt. If you don't manage lot currently, you may try the optional lot mgt and managed a receipt with a lot number defaulted from the receipt number for instance.

    Last, would be to manage 2 sites: one for the dock and one for the rest of the stock. But this method is a huge change and increase the complexity of the managent of the solution: more product-site records, inter-site transfer transactions to do instead of a storage plan, MRP need to be set with inter-site supplier for the related products, you need to ensure the invoice adjustment are properly push to the 2nd site (using cost issue adjustement).

Children