Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-10577

New Feature: Inventory Cycle Count

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Patch Available
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Trunk
    • Fix Version/s: None
    • Component/s: hhfacility, product
    • Labels:

      Description

      Here are the design notes for cycle count workflow:

      Find Session Screen: In this screen, we will show all the sessions created in the system with respect to the facility, locations, inventory count item, current status, and created date. We have a search field to filter the records on the basis of the facility, status.

      Find Pending Locations: In this screen, we have a table listing all the pending locations whose countings are pending and we can create a session for them. All details regarding the pending locations are listed here with the location, next count date, last count date and days extended for the count, total inventory item and product for this location. We have facets for filtering the records on the basis of the facility, not scanned since and scheduled for next scan. Also, we have a global search at the top of the screen. In Pending Locations screen, we have a Create Session button. To create a session we can either select one or more records from the below list or create a new session by yourself.

      In Create Session screen, the basic overview is shown in the "Overview" section and the items are listed in the "Items" section. We can create a new line item by clicking on the 'Add' button and we can also update the item quantity. After completing this, we can proceed with this session and mark it with 'Pending for Review' status from the 'Status' button at the top of the screen or we can simply 'Reject'. 'Reject' status button is available at the top of the screen.

      Find Review Screen: In this screen, we have a table listing all the locations pending for the review. All the details regarding the review sessions are listed with the facility, locations and counted inventory item. We have facets for filtering records on the basis of the facility. By clicking any session we can go to its detail screen, where basic details regarding this session are listed in the 'Overview' section and items are listed in the 'Items' section. We can select any number of rows and mark them as 'Accept' or 'Reject'. When these items are marked as 'Accepted' then the variance is created and these are added in the Count Progress report. Only authorized persons can accept or reject the sessions and once the session is accepted it is marked as 'Completed'.

      Count Progress Report: In this screen, User can view the advanced counting related analytics with respect to all the 'Completed' status session from Reports Screen. We can filter the records on the basis of the facility and within the date range. We can also see the percentage of the total locations, inventory items counted and errors occurred during the process. Item variance details are listed in the below section in tabular form.

      Following changes to the existing data model to support end to end counting process flow:

      New entities:

      InventoryCount
        inventoryCountId
        uploadedByUserLogin
        facilityId
        statusId
        createdDatetime
      InventoryCountItem
        inventoryCountId
        inventoryCountItemSeqId
        inventoryItemId
        itemStatusId
        locationSeqId
        productId
        productIdentifier
        quantity
      InventoryCountVariance
        inventoryCountId
        inventoryCountItemSeqId
        inventoryItemId
        productId
        productIdentifier
        locationSeqId
        systemQuantityOnHand
        actualQuantityOnHand
        varianceQuantityOnHand
        totalCost
        actualCost
        costVariance
        actualValue
        totalValue
        valueVariance
        unitCost
      **Extended entity:
      FacilityLocation
        locked
        lastCountDate
        nextCountDate

      **We will prevent the following inbound and outbound transactions within the application if the location is locked for counting:
      Inventory Transfer
      Issuance against Sales Order
      Sales Return receiving
      Inventory receive
      Issuance and return inventory in manufacturing Job
      Kit breakup
      Update Location
      Physical Variance creation

      The locked locations won’t have any bearing on the transactions that are affecting the only ATP of parts i.e. Reserving component for Jobs/Sales Orders etc. as they don’t affect QOH in any way.

        Attachments

        1. Ui Issue.png
          108 kB
          Pawan Verma
        2. Menu Error.png
          105 kB
          Pawan Verma
        3. Ui Issue.png
          108 kB
          Pawan Verma
        4. Menu Error.png
          105 kB
          Pawan Verma
        5. ItemSubSeqId.png
          188 kB
          Pawan Verma
        6. InventoryItemLookup.png
          88 kB
          Pawan Verma
        7. FindSessionIssue.png
          100 kB
          Pawan Verma
        8. Checkbox Issue.png
          119 kB
          Pawan Verma
        9. screenshot-8-report-screen.png
          388 kB
          Yashwant Dhakad
        10. screenshot-1-find-session.png
          334 kB
          Yashwant Dhakad
        11. screenshot-7-complete-review.png
          409 kB
          Yashwant Dhakad
        12. screenshot-4-list-of-review-session.png
          454 kB
          Yashwant Dhakad
        13. screenshot-6-accept-session.png
          373 kB
          Yashwant Dhakad
        14. screenshot-3-add-location-to-session.png
          423 kB
          Yashwant Dhakad
        15. screenshot-2-pending-locations.png
          471 kB
          Yashwant Dhakad
        16. screenshot-5-review-session-detail.png
          423 kB
          Yashwant Dhakad
        17. OFBIZ-10577.patch
          206 kB
          Yashwant Dhakad
        18. OFBIZ-10577-Database-Changes.patch
          13 kB
          Ankit Joshi

          Activity

            People

            • Assignee:
              yashwant.dhakad Yashwant Dhakad
              Reporter:
              yashwant.dhakad Yashwant Dhakad
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: