hello community .
so I have this item , bought 20 (first transaction) , then transfer few of them to different warehouses . and I sold few (3) and lost 2 while doing reconciliation.
so in total bought 20 , sold 3 , lost 2 . rest 15 . I can see the current balance which is 15 in stock balance . but the total OUT and total IN should not be 41 , -24 .
in summary , the internal transactions is increasing value since each material transfer add more in and out .
what I want it total in (buy or manufacture) , total out (sold) , + the reconciliation entry and the balance 15 .
anyone is facing the same issue ?
