Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Last Updated Date 11/26/22

High-Level Design

Inc drawio
zoom1
simple0
pageId2516583313
custContentId2516845552
lbox1
diagramDisplayNamemet council
hiResPreview0
baseUrlhttps://mdnusa.atlassian.net/wiki
diagramNamemet council
imgPageId2545156097
pCenter0
aspectYu8pBkVzy0NOf2D8Tnkd 1
width831
includedDiagram1
aspectHash3a45568fb84ef11602fe37ff594d558a44126fd7
linksauto
tbstyletop
height691

Table of Contents
minLevel1
maxLevel7

Main Warehouse

High Level Design

Objectives

  • Standardize

  • Streamline

  • Automate

  • Document

Master Data

digial
    • digital and non-digital pantry will have a

warehous
    • warehouse record.

    • For phase 1 Bin Management - < 10 bins configuration

      • No scanning for phase 1

  • Item creation

    • Out of box Item No. creation.

      • Allow renaming Item No. after transactions are created.

    • Item by Multiple UOMs

    • Lot tracking and expiration date tracking.

    • Bundle Items creation.

    • Display Kosher certificates and other characteristics

    • Inventory management with both quantities and costing

    • Expired and unusable inventory tracking.

Purchase Order Creation/Receiving

/Put-aways

  • Email POs to vendors.

  • Import Purchase Orders

  • Manage available funding by sources and agencies on the PO.

  • Drop-Ship a purchase order to a pantry.

  • Donation Receiving

    • A Donation Purchase Order with 0

cost
    • costs must be set up first either manually or by CSV upload.

Transfer

Agency Order Creation/Allocation/

Picking/Shipments

Shipments

  • User Transfer Order

    • Alternate Shipping

    • Alternate Delivery Contact

  • Custom screen (Ben’s screen) for Agency Order creation (customization)

    • Allocate inventory with Qty. on Hand and Qty. on PO

    • Create or update Transfer Order

    • Add fresh products to an existing order

    • Email agency orders

  • Will be used or both digital and non-digital.

    • Month-end routine to zero out inventory in the non-digital

warhouses

Phase 1 “must have” Reports/Dashboards

After Phase 1
    • warehouses

    • Month-end routine to cycle count inventory in the digital warehouses.

  • Inventory Adjustments with reason codes

  • Warehouse Activities

    • Movements

    • Breakbulk

  • Cycle Counts

  • Calendar for both outbound and inbound shipments (Salesforece calendar)

Pantry Management 

  • Transfer Order Receiving 

  • Inventory Adjustments/ Put-aways to the Sales UOM.

  • Cycle Counts

  • Client Order Management

    • Receive orders from B2B Portal

  • Upon SF Orders creation/update, allocate inventory. 

  • Packing List and Delivery Label

  • Sync SF Orders with Status = “Picked up” or” Delivered” to GF Sales Invoices

    • Post manually to be posted to update allocation and deduct inventory

    • Automatically consume inventory FEFO by lots

      • Manage orders by different status

      • Allocation of inventory

      • Support manual insert/update orders.

        • RafterOne provides routines to update “points calculation”???

      • Mass print or individual print Packing List

        • Allow for custom configurations of the “to address” section on the Delivery Label.

        • Option to group delivery.

    Reports/Dashboards

    • Inventory Valuation

    • Purchase order report

    • Agency Transfer Orders

    • Inventory by Warehouse

    • Client Orders

    • …………

    Security

    Pantry Managers should only see their own pantry’s transactions:

    • Warehouse

    • Pantry Orders

    • Transfer Orders

    • Pantry Inventory

      • Bin Content

      • Item Ledger Entry

      • Warehouse Entry

    Data Conversion

    • Items

    • Item Formula

    • Vendors

    • Sites

    • Open Purchase Orders

    • Open Inventory

    • Closed Purchase Orders (from 1/1/22)

    • Closed Agency Orders (from 1/1/22)

    • Client Orders (from 1/1/22)????? vs. Pounds and People served by month by agency???

    Integration with B2B Portal

    • GoldFinch Item to Salesforce Product

      • When an inventory item is created or updated in GoldFinch, a corresponding Product will be automatically created or updated in Sales Cloud. GoldFinch Items and Sales Cloud products are linked.

    • Salesforce Orders to GoldFinch Sales Invoices

      • Order Allocations - When a Salesforce Order is created, updated, or deleted, Product Allocation for each Order Product is also created, updated, or deleted.

      • If an item is Lot Tracked, lot numbers are allocated using FEFO.

    • Maintain Qty. Available for B2B Portal on Bin Content object.

    • Copy Salesforce Orders to GoldFinch Invoices, after an Order is fulfilled, either manually, or by an automation routine.

    Go Live Date

    2/1/23

    Phase 2

    • Barcoding

    • Scan Receive and scanning apps

    Full-blown
    • Advanced Warehouse Bin Management

    Out of Scope

    Table of Contents
    minLevel1
    maxLevel7