Display orderables to fill with the OpenLMIS Ideal Product Model

Description

As Philomena, I want to see my available products I can fulfill an order with, with their stock on hand amounts, grouped under the products that have been ordered so that I can easily see how to fulfill the order with my current stock (stock cards) at my facility.

Ideal Product Model
This changes the Fulfill Order screen to support the ideal product model. Currently if the same orderables are used for requisition/fulfillment and stock management, the Fulfill Order screen can show that orderable on the same line, with order quantity from the order, SOH from the stock card (of the fulfilling/supplying facility) and fill quantities to be entered. With the ideal product model, the commodity type orderable would be on one line with order quantity, and the trade item orderables (with lots) would be grouped under it with SOH and fill quantities to be entered.

This will look similar to what is described in and the same API from would be used. See mockup for grouping example.

Mock up

Acceptance Criteria

  • And a "Remaining SOH" column to the table

    • The value of the "Remaining SOH" for each row will be that row's stock on hand minus the entered fill quantity

    • For "orderable" rows, the stock on hand will be the total stock on hand for the ordered orderable, and the fill quanitity will be the total of all fill quantities related to the orderable

  • For each orderable in an order

    • Change the row color to the "secondary" row color from

    • Add the following information to the order orderable row (see red text in mockup) — assuming the orderable is a commodity type orderable

      • Stock on Hand: Display the sum of all related trade item's stock on hand at the supplying facility

      • Total Fill Quantity: Display the sum of all related trade item's fill quantity

      • Remaining SOH: Display the sum of all related trade item's remaining quantity

      • The above changes are similar to and

    • if the ordered orderable has related trade item orderables, then:

      • Each trade item orderable is shown below the ordered orderable

      • Trade item orderable rows are shown in the row's primary row color (ie white)

      • Lots for a trade item are shown as "child rows" which have less padding than normal rows. See for details.

    • If the ordered orderable is a generic orderable (not using the ideal product model meaning not a commodity type orderable or trade item orderable), then:

      • the Ordered Quantity and Stock on Hand for the supplier will appear on the same line since only the exact same orderable can fulfill an orderable which is not backed by either a CT or TI.

      • The row's color should be the primary row color (ie white)

  • Table columns are ordered with item meta data first, followed by order information, and lastly fulfilling facility stock information. This would read:

    • Product Code

    • Product

    • Lot Code which are shown if there are trade items with lots

    • VVM Status is showing if a trade item's lot has a VVM status

    • Expiry Date is showing if a trade item's lot has an expiry date

    • Order Quantity which is only shown on rows for ordered orderables

    • Fill Quantity

    • Available SOH

    • Remaining SOH

  • Implement openlmis-table-pane so table will virtually scroll

  • Page title has spaces before and after the "-": Fulfilling Order - [NUMBER]

Attachments

2
100% Done
Loading...

QAlity Plus - Test Management

Checklists

Activity

Show:

Joanna BebakMarch 23, 2018 at 7:38 AM

I made a re-test, and now everything works correctly.

Nikodem GraczewskiMarch 23, 2018 at 6:24 AM

I've updated the description to be consistent about the Remaining SOH column name.

Mary Jo KochendorferMarch 22, 2018 at 1:04 PM

Apologies for the lack of clarity, let's say "Remaining SOH" since we use "Available SOH" in the earlier column and it is in fact the remaining SOH not the Remaining quantity to fulfill the order Quantity.

Nikodem GraczewskiMarch 22, 2018 at 12:52 PM

I've pushed changes for 1, 2, 3 and 5.

Nikodem GraczewskiMarch 22, 2018 at 12:50 PM

Which label should we use for the Remaining Quantity column? "Remaining Quantity" or "Remaining Stock on Hand"? The ACC is not clear about it (it uses both).

Flagged
Done
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Story Points

Original estimate

Time tracking

3w 4d 2h logged2h 30m remaining

Components

Sprint

Fix versions

Priority

Time Assistant

Created February 27, 2018 at 12:09 AM
Updated November 29, 2020 at 10:37 AM
Resolved March 23, 2018 at 7:38 AM