I have same items in different location with different unit cost. Am using average cost method in both item card and inventory setup.
For eg. Item A - Quantity 100 @ 40 AED = 4000 in Dubai
Item A - Quantity 100 @ 50 AED = 5000 In Ajman
Average cost will be 45 AED
When i post a sales invoice of 100 quantity from Dubai , The location is credited with 100 @ 45 = 4500 , Which cause location showing negative 500 with zero quatity.
How to solve this issue