FOCUS 6 ERP Expert Needed for Inventory Costing Issue
Budget: $30 – $250 USD
Subject: Seeking FOCUS 6 ERP Expert – Average Cost Issue during Inventory Reposting
"I am looking for a FOCUS 6 ERP expert to resolve an issue with Average Costing during inventory Reposting.
The current costing formula works correctly under normal conditions. However, we are facing a critical issue when the quantity reaches zero in specific scenarios:
Inventory Transfers: When transferring items between warehouses, if the quantity in the source warehouse is cleared (zeroed out) and the quantity in other warehouses is also zero, the average cost is lost. Upon receiving the items at the destination warehouse, the cost remains zero instead of being restored.
Sales Returns: If a return occurs for an item that currently has zero quantity in stock, the system fails to recalculate or restore the average cost, leaving it at zero.
I need a solution that ensures the cost history is maintained or correctly recalculated during the Reposting process, even when quantities hit zero."
Example:
transfer stock to other warehouse
transfer qty=2,dc=50 dollar and qty become zero
recieve other warehouse qty=2 ,dc=0, i want dc=50 usd not zero
"I am looking for a FOCUS 6 ERP expert to resolve an issue with Average Costing during inventory Reposting.
The current costing formula works correctly under normal conditions. However, we are facing a critical issue when the quantity reaches zero in specific scenarios:
Inventory Transfers: When transferring items between warehouses, if the quantity in the source warehouse is cleared (zeroed out) and the quantity in other warehouses is also zero, the average cost is lost. Upon receiving the items at the destination warehouse, the cost remains zero instead of being restored.
Sales Returns: If a return occurs for an item that currently has zero quantity in stock, the system fails to recalculate or restore the average cost, leaving it at zero.
I need a solution that ensures the cost history is maintained or correctly recalculated during the Reposting process, even when quantities hit zero."
Example:
transfer stock to other warehouse
transfer qty=2,dc=50 dollar and qty become zero
recieve other warehouse qty=2 ,dc=0, i want dc=50 usd not zero