Average Cost without Dock locations

Question

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)

Julien Patureau · Accepted 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).

Sage X3

Average Cost without Dock locations

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING