Good day,
I am wondering if there is a setting to change that will allow the price field to auto-fill in the Misc. Receipt window. Currently we have to manually enter it after checking the price detail in product record:
Thank you,
Zoey
I guess you pay attention to this field because you noticed the impact on your stock value (are you using AUC, AUC lot or FIFO?).
Instead of loading the price in the screen which will need a cutomization (more or less simple depending on how you are managing your price list), I can suggest to set an exception rule on the stock valuation method (Setup > Stock > Valuation methods) for misc. receipt to avoid using the price on the misc. receipt (which is usually unreliable) but an alternate value:
If you field order price is not populated, this setup will value the stock created using the current average unit cost.
Please be sure to test properly this configuration change before using it in your Live environment!
Does this information answer your question?
Hi Julien Patureau, after two years of Sage we have recently been told by the CFO to input the order price when doing Misc. receipts as not doing so is affecting our average cost. We don't use lots so I am assuming that means just AUC. The interesting thing is, our previous CFO actually said the same thing last year, and then backtracked saying it was not actually necessary. But now we are back here again having to do it.
I was not able to find the screen you mentioned. Setup->Stock-> Valuation Methods took me here:
+
Where should I go from here to check that line you showed?
Thank you,
Zoey
You just need to click on the Magnifier icon to open the screen allowing you to set an exception rule for misc. issue (Grid at the bottom on the screen):
been told by the CFO to input the order price
Of course entering the order price using the latest valid purchase price is not the same as using the average unit cost (as suggested above). But if you test this configuration, you can see that the value on your stock movement is based on the average cost (and your stock balance will be updated accordingly) which the exact same logic for a stock count adjustment.
Note: if you are creating stock for a product-site using misc. receipt then your current AUC is nul, so be sure to forbid nul price. In this case entering the order price would be your last option:
You just need to click on the Magnifier icon to open the screen allowing you to set an exception rule for misc. issue (Grid at the bottom on the screen):
been told by the CFO to input the order price
Of course entering the order price using the latest valid purchase price is not the same as using the average unit cost (as suggested above). But if you test this configuration, you can see that the value on your stock movement is based on the average cost (and your stock balance will be updated accordingly) which the exact same logic for a stock count adjustment.
Note: if you are creating stock for a product-site using misc. receipt then your current AUC is nul, so be sure to forbid nul price. In this case entering the order price would be your last option:
