Latest industry insights, tutorials, best practices and case studies.
844 articles
This tutorial walks through a single strategy of incrementally pulling item master data from Kingdee's cloud suite by modification time, landing it on the target via the Qeasy Data Integration Platform. It covers field mapping, scheduling design, common pitfalls, and applicable boundaries.
This tutorial systematically reviews the Kingdee Cloud 'Assistant Data Detail' query interface (FormId: BOS_ASSISTANTDATA_DETAIL), covering field definitions, filter conditions, and typical configurations in CRM/ERP master data synchronization scenarios. Distilled from multiple customer implementations, it consolidates common practices, pitfall checklists, and configuration guidance on the Qeasy data integration platform.
This tutorial explains how to push supplier master data from Kingdee Cloud to Wangdiantong on a 5-minute incremental cadence using Qeasy, covering field mapping, configuration, phased scheduling, and common pitfalls in supply-chain integration scenarios.
This tutorial uses a step-by-step transfer-in order from a manufacturing enterprise to show how to use the Qeasy data integration platform to write Kingdee Cloud Cosmos approval results back to a MySQL staging table via a lightweight polling trigger. It focuses on the no-op trigger, the SQL writeback script, scheduling cadence, and common pitfalls.
For wholesale market scenarios, this guide walks through syncing sales outbound orders from a market-side system to T+ sales vouchers. It covers field mapping, configuration on the Qeasy platform, staged scheduling, and lessons learned from real implementations.
This guide walks through one specific supply-chain integration strategy—backfilling the outbound time of assembly/disassembly orders from a source system to a target system. It covers data flow, key Qeasy configuration points, phased scheduling, and lessons learned, aimed at integration engineers handling business document sync between Jike Cloud and Kingdee Cosmic.
Set against the supply-chain integration between a retail platform and Kingdee Cloud, this tutorial systematically consolidates the executeBillQuery API for querying STK_Inventory: capabilities, field mapping, online-warehouse filtering, pagination, incremental strategy, and field pitfalls drawn from multiple customer projects, so engineers can master every practical detail in one read.
This article walks through a concrete sales stock-out sync strategy: incrementally pulling audited/dispatched stock-out orders from the source ERP, mapping and de-duplicating fields on the Qeasy data integration platform, then pushing them into the target financial system as sales delivery orders. It covers data flow, field mapping, configuration tips, scheduling design, and lessons learned.
This article walks through a real-world integration that writes back the stocking-complete status from a Yonyou YS purchase receipt to the sales order in Xiaoman OKKI CRM. It covers the business scenario, data flow, key configuration points on the Qeasy platform, and lessons learned, aimed at engineers building CRM–ERP status synchronization in on-premise environments.
电商对账系统每天都会产出大量「差异行」——金额不一致、缺供应链单、退款倒挂、跨期结算、代扣税、平台补贴……这些差异如果只写成「金额对不上,请人工核对」,审计师根本无从下手。23 个 diffReason 业务标签码存在的意义,就是把这一团团模糊的「差异」翻译成审计师能直接穿透的标准化证据链:① 机读码精确还原差异成因;② 中文处理建议告诉财务经理去哪查、怎么处理;③ 配套状态机迁移日志完整记录从「对账触发」到「手工确认」再到「集成转换推送 ERP」的每一步。本文用「5 大类别 + 3 大审计应用 + 1 张穿透核验路径图」,把这套标签码体系对审计师的价值一次性说透。
把电商财务的整个流程拆开看，本质就是 5 个独立的"自动化单元"——账单自动解析（JS 沙箱）、对账自动匹配（双码匹配）、凭证自动生成（集成转换规则引擎）、报表自动生成（VTable 三段式）、推送自动触发（BullMQ + 集成中心）。**这 5 件套不是 5 个孤立的产品功能，而是「数据接入 → 业务核对 → 财务入账 → 决策支持 → 系统闭环」的完整价值链**——少任何一件，闭环都不成立。本文从 CFO 与财务经理视角拆解每件套的工程实现、生产纪律与真实上线效果。
CFO 想看「上周抖店毛利情况」——过去要「提需求 → 财务经理分派 → 财务核算专员写 SQL/Excel 透视 → 出表 → 邮件发送」五段人工链，**单张临时报表平均 4.8 小时、月耗 110 小时**。AI 财务智能体的「报表生成」应用，把这条 110 小时的链压成 **90 秒一句话：CFO 用自然语言问「上周抖店毛利情况」，AI 自动从 6 个受控数据集选数据集、组装报表定义、运行预览、用业务语言讲清楚图表+洞察+建议——CFO 不写 SQL、不提需求、不等开发**。
审计师最爱什么样的对账系统？不是"对得最快的"，而是"解释得最清楚、追溯得最全、改得最透明"的那一种。这篇文章不讲通用对账流程，直接讲 5 个让审计师愿意在底稿上签字的工程化细节——**完整的差异追溯链、状态机的清晰迁移、操作日志的全量记录、桥表的 5 字段最小化、物料明细独立表**。每一条都是从 SOX 抽样测试、内控合规审计、年审问询函的真实踩坑里反推出来的工程纪律，不只是"对得上"，而是"对得上 + 能解释 + 留得下证据链"。
金蝶云星空、用户系统里的对账结果要生成应收单、应付单，自研 ERP 要的是另一套字段……这套「目标系统千差万别」的中间产物，怎么在 Prisma schema 里只占 4 张表、不随集成数线性膨胀？答案就是「transform_documents × payload JSONB × columnSchema × editableFields」这一组通用骨架——骨架字段固定、目标系统差异全收敛进 JSONB、列声明与编辑白名单随批次快照落库、金额字段一律禁改。
同一句话「对账」，在京东 POP、抖店、支付宝、亚马逊、速卖通五个平台跑出来的是五种不同的判定逻辑——京东用整单轧差把同一订单的收款和退款合并成净额再判、抖店沿用同一种整单轧差但把判定轮次刻意做少靠多证据链单点爆破、亚马逊坚持分向不轧差让收款与退款各对各的、支付宝靠三张表分别告诉你「平台给了多少」「在哪个账户」「生了多少利息」、速卖通用 4 个资金 billType 拆开两套资金账户再叠 1 张不入金蝶的 JIT 维表。这篇文章不是平台对比表，是把这五种「判定权威」背后的工程逻辑拆给你看——读完你会知道为什么亚马逊的对账失败率能从 20% 压到 5% 靠的不是多写代码而是认清「分向不轧差」是账单本质决定的。
AI 系统的知识库不是「写一次吃一辈子」，它会随代码迭代、随业务更新、随 md 文档修正而持续变化。这篇文章不讲 RAG 原理，而是讲一个更接地气的问题：怎么让「拉代码 + 重启服务」一行命令搞定知识库更新，让运维不需要关心这次改的是 md、是 seed、还是 schema 注释？答案是一个 70 行的 Node 脚本 + 一份调用纪律：post-deploy-knowledge。
电商对账不是「两列数字相减」，而是一套**合规风险控制系统**——5 大雷区（收入确认时点错配、退款倒挂、平台补贴未入账、跨期收入错配、代扣税未计提）每年让中型电商公司产生 0.3%-1.2% 的「假利润」，审计一来就得做红冲、做追溯、做说明。本文不讲术语堆砌，从一份真实的月结错账复盘出发，把每条雷区的触发场景、合规口径、规避动作拆给你看。读完你会知道：合规对账的护城河不在 Excel 表里，而在**机读差异标签**（diffReason）+ **沙箱分摊反写** + **物料级追溯链**这三件事上。
2024 年 1 月，财政部《企业数据资源相关会计处理暂行规定》正式施行，把"数据资源"从治理议题推到会计科目——而决定一项数据能不能从"原始流水"走到"无形资产"入表的，是企业数据治理的成熟度水平。同样是 5 亿条订单数据，治理成熟度 3 级的电商企业可以做出 95% 自动对账的核算体系，治理成熟度 1 级的同行依然困在"每月对账 8 天、差异靠 Exce…
This article walks through a single strategy that syncs supplier master data from LingXing ERP to Kingdee Cloud, covering data flow, field mapping, configuration in Qeasy, dual-track scheduling, and five lessons learned.
This tutorial focuses on a single synchronization strategy: pushing sales orders from Jushuitan to Kingdee Cloud Skylight outbound documents. It covers data flow, field mapping, Qeasy configuration essentials, scheduling design, and lessons learned, giving engineers a ready-to-use playbook for private-deployment supply-chain integration.
