...
To avoid storing all sales we aggregate sales to see the stock changes in batches with exception for items sold with serial numbers. When return is done with damaged flag set, we treat that return as breakage, in result such return will create two lines, one as sale with amount increasing the stock, and one breakage line decreasing it again.
Calculate weighted cost price
Incoming goods receipt transactions trigger recalculation of weighted cost price basing on this formula:
New weighted cost price = (Stock quantity * Old weighted cost price + Goods receipt quantity * Cost price of the item) / (Stock quantity + Goods receipt quantity) |
Goods receipt cost price will be set to as new weighted cost price (without calculation) when:
- Item has some stock, but for some reasons weighted cost price was equal to 0;
- Stock quantity was negative;
- Item did not have stock in given store yet.
Improvements
Module | Description |
---|---|
Item transaction | Reason/action codes and language changes (RTC-30933) Reason code field is displayed above action code in the new transaction modal. |
Stock status | Minor improvements to the Status tab in Stock details view: (RTC-30737)
|
Transactions logs | View item transactions per item (RTC-31429) Stock balance and sales transactions are shown in view for transactions per item, also when using filter panel. View transaction log (RTC-31429) Imported stock balance and sales are not available in filter panel for transaction log. |
...