Updates for Lost Stock Report

[jmcameron]

Stock > Report > Lost Stock Report

Possible bug: Consider the Vanga database for the month of February 2021 (see below). This is not technically a loss. Apparently the inventory+lot+price was duplicated with different quantities but the two items got mixed up on the receiving end. See the corresponding Stock Movement: This should never have happened! The Originating Stock exit should not allowed a duplicate of an existing inventory item + lot ID (with the same price). It should have prompted the user to adjust the quantity of the existing item rather than adding a new item. As far as fixing this in the report, it should be possible to search for duplicate inventory+lot+price items and see if they got transposed and ignore them if there was no loss when considered together. It may not be worth the effort. Note that in the Vanga database, the report for all 2021 shows several cases where the items have the same inventory and lot but difference prices. It is not clear whether these represent true losses since the combined quantities are the same (this should be investigated further).

Suggestions

• The stock movement ID should be included on each line for reference purposes
• If "Either" is selected for the "List stock transfer losses for this depot as" option, the depot name is not shown in the report titles. But it probably should be, using something like "Source or Destination: " to match the report title layout of the other options.