Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Average Cost Updating - Replace Cost if Stock Cost is Zero |
Article Number: 83 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 11:35 PM
|
Datafile Software Average Cost Updating - Replace Cost if Stock Cost is Zero Stock System Profiles (and Purchase Invoice or Purchase Order Processing documents) allow the system to be configured to update the stock cost price on an average basis during goods received. When updating the cost price the system updates based on the formula of: (CURRENT-COST x QTY) + (RECEIVED-QTY x COST) / TOTAL-QTY = COST-PRICE Currently if the updated cost price would result in a zero cost price the system automatically omits the update of cost price and keeps the current cost. Additionally an existing parameter allows the system to omit the update of cost if the received cost is zero (perhaps due to receipt of samples on a FOC basis), but if the current cost price is set as zero (but a non-zero physical qty was recorded) then the system averaged in the value with the current qty at a zero cost. Release 6.4 introduces a new option to omit the average update in these circumstances and instead replace the current stock cost with the receipt cost. Installation System Profiles A new option has been added to the Stock System
Profiles to enable the replacement update of cost. To update select Installation from the main menu followed by Application Manager, then System
Profiles before selecting the Stock
Control application. Replace with I/P if Stock Cost Zero – when set the system will replace the stock cost with the received stock cost if the current stock cost is zero rather than averaging the receipt in. Notes Stock System Profile parameters as to whether to update stock costs apply to Stock Control and Bill of Materials only. Invoicer and Purchase Order Processing have their own document parameters to control the update of stock costing. However, the option to omit the update of average cost if i/p zero and this new option to replace cost when stock cost is zero are system wide and apply to all the goods received options when they are set to update costs. |
Attachments
There are no attachments for this article.
|
Sales Issues / Reservation Listing - Stock Control
Viewed 1395 times since Mon, Jun 18, 2012
Flag Component Records to Omit Cost Price
Viewed 1600 times since Tue, Jun 12, 2012
Matrix Factors - Batch Tracking
Viewed 1375 times since Wed, Jun 20, 2012
System Status - Batch Tracking
Viewed 1484 times since Tue, Jun 19, 2012
Stock Optional 2 - Stock Control
Viewed 1461 times since Tue, Jun 19, 2012
Stock Reports - Stock Control
Viewed 1518 times since Tue, Jun 19, 2012
Stock Adjustments Report - Stock Control
Viewed 1461 times since Mon, Jun 18, 2012
Build Document - Batch Tracking
Viewed 1344 times since Tue, Jun 19, 2012
Transaction Control Numbers - Stock Control
Viewed 1515 times since Tue, Jun 19, 2012
Transferring from Existing Stock Control
Viewed 1528 times since Mon, Jun 18, 2012
|