Average Costing Method Issue in Dynamics 365

Question

How can I resolve the issue with the average costing method in Dynamics 365 where my ledger is showing a negative value for an item with zero quantity in one location, but the same item is showing a positive value in another location? I have different unit costs for the item in different locations and use the average costing method. The problem only occurs when I post a sales invoice and the ledger is credited with profit based on average cost. Please provide guidance on how to solve this issue.