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 Code is passed to Accounting Seed as Accounting Variable 1
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.
Empty the summarized table - GF_DeleteSummarizedItemAllocationBatch
Prepare the item allocation table - GF_UpdateItemAllocationBatch
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.
Accounting Seeds
Integration of GF with accounting seeds.
AR/AP/GL required
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