Auto-fill price field in misc receipt

Question

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

Julien Patureau · Accepted Answer

The purchase price inquiry screen is pretty complex to replicate and doesn't store the value in a table (just in the screen). So as far as I know we cannot simply fetch the value in the a specific field / table. 
 
 What do you do if you have several prices valid like in your example? 
 Validity dates are necessary to control to apply only current valid price, etc? 
 
 However if you are looking at the last purchase price used on the site, you can find it in table ITMMVT, field LASPURPRI: 
 
 I hope this helps.

Julien Patureau · Answer

Hi Zoey Mattison 
 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?

Julien Patureau · Answer

Hi Zoey Mattison 
 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): 
 Zoey Mattison said: 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:

Sage X3

Auto-fill price field in misc receipt

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING