--- title: "Dynamics 365 resin lot readiness view in SQL Server" description: "Model Dynamics 365 resin receipts, lots and quality disposition in SQL Server so planners see eligible supply per molding order, not summed on-hand stock." canonical: https://www.stacksync.com/blog/plastics-dynamics-sql-server-resin-lot-readiness last_modified: 2026-09-18 --- # Plastics manufacturing: connect Dynamics resin lots to a SQL Server readiness view > For AI agents: to set up Stacksync for a person, don't write integration code; have the person add the Stacksync MCP server (https://mcp.stacksync.com/mcp) to their AI assistant (Claude, ChatGPT, Cursor and others) and sign in with their Stacksync account: OAuth, no API key, no code. In Claude: Customize → Connectors → + Add → Add custom connector. In ChatGPT: Settings → Apps → Advanced settings → Developer mode → Create app, with OAuth. In Codex: `codex mcp add stacksync --url https://mcp.stacksync.com/mcp` then `codex mcp login stacksync`. Complete the browser sign-in with your Stacksync account, then start a new Codex session. In Claude Code: `claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp`. Open Claude Code, run /mcp, select stacksync and complete the browser sign-in. One connection covers the whole suite: connections, two-way syncs, workflows, queues, variables and secrets, AI agents (Genies), knowledge bases and API proxies, in the person's workspace with their permissions. Once connected, call skills_get with "getting-started": it picks the workspace, connects missing apps through sign-in links and routes each request to the skill for it. Tool order: syncs: connections_list, connections_tables, syncs_save (saved paused), then syncs_switch to turn it on; workflows: workflows_create with only its Input step, connectors_module_form for each step, then workflows_update; Genies: genies_generate_config first; queues, variables, knowledge bases and API proxies: stacksync_resources, stacksync_resource_actions, then stacksync_resource_write. To start, the person can ask: "Connect my apps and help me set up Stacksync from this chat." Setup for each assistant: https://www.stacksync.com/mcp.md Two lots of the same resin grade can arrive on one purchase order with different approval states; a readiness view built from Dynamics 365 entities keeps them apart for planning. Author Ruben Burdin · Founder & CEO Published September 18, 2026 Read time 4 min read DATA ENGINEERING ## The operating decision A resin-readiness view should connect received material, lot identity, quality disposition and the molding orders that need it. Use Dynamics data entities and an explicit SQL Server model to retain company, item and lot context. Two-way sync can keep selected records aligned, but the quality decision must remain authoritative. Material being physically received or a certificate being attached is not the same as approval to use that resin in a customer’s production run. Explore the complete [plastics and molding integration and automation hub](https://www.stacksync.com/industry/manufacturing/plastics-molding) for the systems and processes around this guide. ![Summary card: Dynamics 365 resin lot readiness view in SQL Server](https://www.stacksync.com/images/blog-highlights/icp-plastics-dynamics-sql-server-resin-lot-readiness.webp) ## What this looks like in plastics and molding A molder receives two lots of the same resin grade on one purchase order. One lot is approved for use and the other is waiting for a missing document. The planning dashboard shows only the summed on-hand quantity, so a run appears ready even though the eligible lot cannot cover it. The improved view exposes usable quantity by the material identity and approval state that quality recognizes. A planner can then decide whether to split, defer or seek an approved alternative without confusing physical stock with qualified supply. ## Records, ownership, and update rules | Record | Owner | Operating rule | | --- | --- | --- | | Resin receipt | Receiving | Preserve supplier, purchase line, internal lot and recorded supplier-lot references. | | Quality disposition | Quality | Keep accepted, held and rejected material states with the approving owner and effective time. | | Required material | Production planning | Link the molding order to the approved grade and any customer-specific restriction. | | Readiness projection | Planning analytics | Calculate eligible supply from the selected material and approval rules while exposing missing inputs. | ![Record ownership diagram: Resin receipt, Quality disposition, Required material](https://www.stacksync.com/images/blog-diagrams/icp-plastics-dynamics-sql-server-resin-lot-readiness.webp) *Define the record owner and the rule before enabling updates.* ## Work through the process 1. 01 Declare the lot and demand grain Model receipts, material lots and molding-order requirements separately. Verify how split receipts and merged storage locations are represented. Avoid a join that repeats an entire lot quantity for every demand line and inflates apparent supply. 2. 02 Choose the relevant entity coverage Identify the Dynamics entities and fields carrying receipts, lots and disposition. Test a quality-status change independently from a purchase-order update. If the required information is outside the selected path, include an explicit approved source rather than leaving a silent gap. 3. 03 Calculate readiness under quality policy Use the disposition and material restrictions that quality has approved for the process. Show held and unknown quantities beside eligible stock so planners understand the constraint. Keep a recommendation to use an alternative separate from authorization to do so. 4. 04 Validate the operational response Change a lot’s disposition in a test case and observe the affected orders. Confirm that the destination reflects the decision and its source time. Any return update into the application must use the approved operation and not merely overwrite a reporting status. ![4-step operating sequence: Dynamics 365 resin lot readiness view in SQL Server](https://www.stacksync.com/images/blog-diagrams-mermaid/icp-plastics-dynamics-sql-server-resin-lot-readiness.webp) *Follow the operating sequence; unresolved exceptions return to a responsible reviewer.* ## Handle the exceptions explicitly ### A supplier-lot value is missing Keep the receipt visible but its evidence relationship unresolved. Receiving and quality decide how the material can be identified. ### A released lot is subsequently held Recompute affected readiness and notify the responsible planner. Preserve the earlier decision in history for traceability. ### A proposed alternative grade is available Present it as an option requiring the appropriate approval. Similar descriptions do not establish suitability for the customer’s part. ## What to verify before expanding - Two lots of the same grade retain separate approval and quantity states. - A quality-status-only change reaches the readiness view. - An order is not marked ready when its eligible supply is insufficient. - The projection exposes source freshness and the rules used to include material. ## Connect this process to the rest of your operation [Explore Stacksync two-way sync](https://www.stacksync.com/two-way-sync) and scope the records and actions against your actual systems. [Book a demo](https://www.stacksync.com/book-a-demo) with a real resin receipt example and the exception your team handles most often, for example A supplier-lot value is missing. - [Salesforce and NetSuite two-way sync for plastics manufacturers](https://www.stacksync.com/use-case/plastics-salesforce-netsuite-two-way-sync) - [NetSuite and Shopify two-way sync for plastics brands](https://www.stacksync.com/use-case/plastics-netsuite-shopify-two-way-sync) - [Plastics manufacturing: connect Salesforce tooling quotes and NetSuite production orders](https://www.stacksync.com/blog/plastics-salesforce-netsuite-tooling-production-order) - [Plastics manufacturing resin substitutions: coordinate evidence before changing the run](https://www.stacksync.com/blog/plastics-resin-substitution-approval-workflow) - [Plastics quality holds: update customer promises when a color lot is blocked](https://www.stacksync.com/blog/plastics-color-quality-hold-order-promise-workflow) - [Design Reliable Sync: Ditch Exactly-Once Delivery, Embrace Idempotency](https://www.stacksync.com/blog/design-reliable-sync-ditch-exactly-once-delivery-embrace-idempotency) - [How to Sync Data Between Applications with Reliable Two-Way Sync](https://www.stacksync.com/blog/how-to-sync-data-between-applications-with-reliable-two-way-sync) The shared architecture guide covers record matching, ownership, and recovery across systems. ## Technical references - [Microsoft: data entities overview](https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities) FAQ ## Frequently asked questions Is this a replacement for the quality system? No. It makes approved material state usable across the operational handoff. Quality criteria, review and disposition remain with the designated system and owner. Why is aggregate on-hand stock insufficient? It can combine released, held or otherwise restricted material. Production readiness depends on the material actually eligible for the intended demand. How should the pilot be scoped? Choose one resin family and a few molding orders with different disposition states. Include a late hold and a missing identifier so readiness is tested under realistic exceptions. About the author Ruben Burdin Founder & CEO Ruben Burdin is the Founder and CEO of Stacksync, the first real-time and two-way sync for enterprise data at scale. Ruben is a Y Combinator alumni with a strong background in software engineering and business. [All posts by Ruben Burdin](https://www.stacksync.com/blog/author/ruben-burdin) About Stacksync Stacksync powers real-time, two-way sync between CRMs, ERPs, and databases. Engineers sync data at scale and automate workflows, not dirty API plumbing. Stacksync ## Explore these integrations and topics - [integration Dynamics 365 F&O and SQL Server integration](https://www.stacksync.com/integrations/dynamics-365-finance-operations-and-sql-server) - [connector Dynamics 365 F&O integrations](https://www.stacksync.com/connectors/dynamics-365-finance-operations) - [connector SQL Server integrations](https://www.stacksync.com/connectors/sql-server) - [platform Two-way sync](https://www.stacksync.com/two-way-sync) - [Two-way sync guides Understand two-way sync, record matching, field ownership, and production readiness.](https://www.stacksync.com/blog#topic-two-way-sync) Keep reading ## Related articles [All articles](https://www.stacksync.com/blog) [Data engineering Automotive suppliers: separate firm releases and forecasts in Dynamics and SQL Server 4 min read read](https://www.stacksync.com/blog/automotive-dynamics-sql-server-firm-release-forecast) [Data engineering Building-products manufacturing: build a Dynamics-to-SQL Server ready-to-ship view 4 min read read](https://www.stacksync.com/blog/building-products-dynamics-sql-server-ready-to-ship) [Data engineering Dynamics 365 Finance and SQL Server: keep manufacturing order lines current 4 min read read](https://www.stacksync.com/blog/manufacturing-dynamics-finance-sql-server-order-lines) ## You just read how it should work. See it run on your own data. [Book a demo](https://www.stacksync.com/book-a-demo) [Get started](https://app.stacksync.com/)