Pharmacy Daily Stock Values F15 - hmislk/hmis GitHub Wiki

Daily Stock Values (F-15)

Reconciles a pharmacy department's stock value for a day: opening stock, plus or minus every movement (sales, purchases, transfers, adjustments), should equal closing stock, at cost, purchase and retail value.

Page: Pharmacy → Pharmacy Analytics → Summary Reports → Daily Stock Values (F-15) Privilege: PharmacyAnalyticsDailyStockValuesF15 Config: Pharmacy Analytics - Show Daily Stock Values must be on. Favorite key: pharmacyAnalytics_dailyStockValuesF15


Adjustment Transactions

This section lists the stock adjustments made in the department during the day, with their Cost, Purchase and Retail stock values.

Adjustment Values shown
Quantity adjustment (Pharmacy → Adjustments → Quantity Adjustment) The quantity change at the batch's cost, purchase and retail rates. A decrease shows negative values.
Purchase / cost / retail rate adjustment Only the value that the adjustment changes. For example, a retail rate adjustment shows a retail value and 0 for cost and purchase, because the stock's cost and purchase value do not change.
Expiry date adjustment Listed with 0 values: changing the expiry date does not change the stock value.

F-15 Adjustment Transactions after a quantity adjustment: Cost -7.33, Purchase -7.00, Retail -8.06

A quantity adjustment that reduced stock by two units. The Purchase column now shows the purchase value of the change.

Before issue #19512 was fixed, quantity adjustments made from the Quantity Adjustment page showed 0 in the Stock Value (Purchase) column, so the purchase-value reconciliation did not balance.

Staff stock adjustments are not included

Adjustments to staff stock are not listed. Staff stock is held by a staff member, not by the department, so it is not part of the department's opening or closing stock. Including it would stop the report from balancing.


Related