Supply Chain Process - Overview

Business Entities

Account Ownership

Three different fulfillment POs:

• Walmart PO - owned by us

• Barnes & Noble PO - owned by us

• Amazon POs - owned by our clients

Ad Magic (ADM)

Subcontracting manufacturing that is 95% oversees and 5% domestic

For Ad Magic, when a client pays, we send a PO to a plant in China. It includes information about the job and artwork for the cards, game board, cases, etc. are sent to the plant.

Blackbox

Warehousing services, fulfillment services, storage

Breaking Games (BG)

Distribution (we own the inventory and sell it), representation (we do not own the inventory and sell on behalf of someone), and publishing (we create products using various IPs, designers, and developers)

We get orders to send to big box retailers. The big box clients (Walmart, Target, etc.) work with Breaking Games but BlackBox does the fulfillment of it.

Print & Play (P&P)

Domestic manufacturing; This will be a part of a future phase

Inventory Management

Owned Inventory

Import

• Direct Import: Sales channel (ex: Target & Walmart) directly imports product from overseas plant via FBA or FOB terms (pick up from plant or pick up from location outside of plant)

  • We own the inventory up until pickup and ownership transfers at the time of pickup

• Import: We ship to an international or domestic location where a sales channel then picks up or is shipped to

  • We own the inventory up until it ships from our location(s)

Domestic

• We import products to our domestic warehouse and fulfill domestic POs (from Sales Channels)

  • We own the inventory up until it ships from our location(s)

• We create products domestically via sub-contracting

Consignment Inventory

Import

• Direct Import: Sales channel (ex: Target & Walmart) directly import products from overseas plant via FBA or FOB terms (pick up from the plant or pick up from location outside of plant)

• Indirect Import: We ship to an international or domestic location.

Domestic

• We import products to our main domestic warehouse and fulfill domestic POs (from sales channels)

• We create products domestically via subcontracting

Accounts

• Sales can create a “Prospect” account.

• Need approval process to convert Prospect accounts to Customer accounts.

Warehouses

• Simple configuration - for 3PL and vendor warehouses

  • One pick bin

• Complex configuration - for warehouses owned

  • Allow pick and putaway

Items

• Master Data

  • Item No. structure

  • Item Unit of Measures

• Cross-References

  • Required for EDI and Shopify integration

Division Tracking

• 3 divisions

• Default from User Account

• Can update from Item Journal Sales Order, Purchase Order, Sales Invoice, and Purchase Invoice

• Division-related logos and addresses are printed on Sales Order Confirmation, Sales Invoice, and Purchase Order.

Sales and AR Process

https://goldfinch-cloud-solutions.monday.com/docs/4593484332

Sales Order Allocations

• A new object "GF Item Allocation Summary" is created to store summarized item allocation by warehouse by item and by unit of measure.

• Trigger "GF_ItemAllocationTrigger" is added to detect Insert, Update, and Delete operations against the GFERP's Item Allocation object. The system will increase or decrease the quantity count in the summarized table based on the operation type/or the quantity change detected by the trigger.

• A night job routine is scheduled to recalculate the allocated quantity in the summarized table.

  • The night job will run the batches in the following order.

1. Empty the summarized table - GF_DeleteSummarizedItemAllocationBatch

2. Prepare the item allocation table - GF_UpdateItemAllocationBatch

3. Generated summarized item allocation records - GF_SummarizeItemAllocationBatch

Integration with Shopify

• Could be multiple - Self and clients’ 

• For B2C orders

• One Customer account per Shopify site

• End customer addresses are stored on the transactions.

• Item Cross References to map customer item numbers with Ad Magic Item No.

• Configure Shopify webhooks push orders in GF.

  • Setup goldfinch@micro-datanet.com as admin to the test Shopify connection

  • Order Creation

  • Order Update

• Need to think about Update logic. Up to when can an order be updated?

• Shopify Orders to GF Import Orders to GF Sales Order, GF WS, Zenkraft Shipment, GF Invoices

• Custom code for Shopify

EDI Integration

• Use TrueCommerce

• Download 850 orders and import them into GoldFinch.

• Export 810 invoices then upload them into True Commerce.

Integration with FBA

• Transfer Order to transfer inventory to FBA

• Use SOAP XML to download FBA orders to the GF Import Shipments table, and to GF Sales Invoices to post. 

• Replenish FBA based on Reorder Point.

Sales Order

• Most orders are through EDI

• To process EDI orders, go to the Import Sales Orders tab.

• Allocation

Whse. Shipment 

• Whse. Shipments can be created for orders that have allocated quantities.

• Integration with Zenkraft

Zenkraft Integration

• How to download package instructions from the website to GoldFinch for packing?

• Compare live shipping rates vs. billed actual cost vs. amount billed to customers

• Salesforce weight is accurate but without box weight

• LTL, Small parcels and large parcels

• Zenkraft use as a freight option

• Admagic use Fedex Services for Zenkraft

• They have around 150 small shipments

• Do you require BoL in shipment?

• Transfer orders can’t be used as is between warehouses. You have to use the Sales Orders to ship the goods

• All the shipment needs to go through Zenfkraft to get packed.

Sales Invoice 

Consignment orders

• Ad Magic stock at supplier premises

• Should be invoiced once they get sold

• They can transfer that stock to other suppliers too

Purchase Order

• One currency

• Receive inventory to the Vendor Warehouse, then create a Transfer Order to transfer inventory to US warehouses.

• In the Transfer Order, you may use the Shipment Method or Freight Status to describe how the inventory is being shipped and where the inventory is.

  • You can also have one or more In-Transit warehouses (must have a checkbox in Use as In-Transit)

Customer Portal

• Not to save credit card information directly on the portal

• Shari wants it for Phase 1?

• AdMagic right now takes the Salesforce object and puts it on the portal and only has the limited people excess

• AdMagic has 2 options:

  • Give the client GoldFinch license

  • Connect the GoldFinch portal with the client portal but this will take time.

Royalties

• Royalties are commission sales

• Is a licensing agreement between suppliers and Admagic

• AdMagic needs to work on the Data table and wants to inform us what data needs to be captured

Inventory End of Month

• End of Month process

• Run reports in GF

Work Order

• No need to implement a Work Order

Reports

• Total Sales order