Latest industry insights, tutorials, best practices and case studies.
844 articles
抖店的资金账单把所有费用项塞进同一份 CSV——平台服务费、佣金、拦截费、提现、消费者赔付、月付贴息……一个店铺月结就有十几种费用类型，每种还要落到金蝶不同的单据。抖店费用转换脚本 v1.1.0（2026-09-03 用户定稿）用「**流水级直查 + 13 条规则 + 应付带符号净额**」回答这个问题——不经过对账聚合层，直接按「单据类型 × 核算项目」从账单行成单，扣款出正数、退还出红字冲减，单据合计与费用计划聚合净额对平。本文拆开这 13 条规则的分组、应付带符号净额的反直觉之处、v1.1.0 之后的版本演进，以及试跑批次与 Excel 验算锚点。
库存级核算是电商精细化财务核算的"最后一公里"——前 4 个维度（店铺级 / SKU 级 / 毛利级 / 税务级）算的是"账面赚了多少钱"，库存级算的是"账面利润被库存吃掉了多少"。一家年 GMV 5 亿的电商公司，看似 18% 的净利率，扣除「在库滞销 + FBA 长期仓储 + 退货在途 + 缺货损失」4 类隐性库存成本后，真实净利可能只有 6.8%——11.2 个百分点的差额就是库存黑洞。本文给出 CFO 必须看清的 4 类库存成本、多仓核算口径、库存周转"虚假拉长"的 3 大陷阱，以及 FBA 仓 + 国内仓的多仓合并视图。
Strategy-level walkthrough of pulling sales order headers from Kingdee Cloud on a */4 schedule via executeBillQuery, landing them into an in-house MySQL OMS table through Qeasy Data Integration. Covers field mapping, phased scheduling, lessons learned, and scope boundaries.
This article walks through a typical auxiliary data value pull-back scenario from Kingdee Cloud to MySQL, covering data flow, field mapping, Qeasy configuration, phased scheduling, and lessons learned on code mapping, incremental start points, and idempotent deduplication.
In sales order scenarios, enterprise bank account data is often scattered inside the ERP, while the CRM side needs to reconcile by account. This article uses the 'Query YongYou Enterprise Bank Accounts' strategy as a concrete example, breaking down the paging structure, scheduling design, and configuration points on the Qeasy data integration platform.
A field-tested walkthrough of syncing inventory-loss outbound documents from JikeCloud to Kingdee Cosmic, covering field mapping, scheduling cadence, and common pitfalls on the Qeasy integration platform.
Focused on the after-sales refund-order query scenario, this guide walks through configuring a single-strategy flow from LingXing ERP into the Qeasy integration platform. It covers data flow, field mapping, configuration highlights, phased scheduling, and common pitfalls.
This article focuses on one procurement monthly settlement sync strategy, explaining how the source system's monthly settlement instances are incrementally pulled by update time and written into downstream ERP business documents via Qeasy, with full configuration, scheduling and lessons learned.
This tutorial aggregates hands-on experience from real-world private-deployment integration projects, using the Kingdee Cloud Galaxy Sales Order query and the Xiaoshouyi currency and bank account queries as the example. It covers authentication, incremental pagination, nested field extraction, code mapping, scheduling, and retry practices.
This guide focuses on a single store-to-customer synchronization strategy, covering field mapping, Qeasy configuration, incremental and full synchronization scheduling, and common issues. Its goal is to prevent duplicate customers, coding mismatches, and the reintroduction of inactive records.
This article zooms in on a single sync strategy, dissecting the end-to-end flow of moving LingXing ERP split orders into Kingdee Cloud disassembly orders. From incremental querying on the source side, through middle-layer mapping, to batch writes on the target side, it lays out configuration essentials on the Qeasy integration platform, scheduling cadence, and common pitfalls, so that split/disassembly business documents stay stable, traceable, and re-runnable.
This article focuses on a single strategy, the [Linked Query] Kingdee Item Query, walking through business scenarios, field mapping, Qeasy configuration, scheduling design, and lessons learned, so you can incrementally pull item master data from Kingdee Cloud Xingchen V2 via a time window and land it on the Qeasy integration hub.
This tutorial focuses on one specific strategy — syncing sales return inbound orders from Wangdiantong to MySQL — covering scenarios, field mapping, Qeasy configuration essentials, phased scheduling, and lessons learned, written for engineers delivering supply chain integration projects.
For a manufacturing supply chain scenario, 14 document types from MES — master data, procurement, production issue/feed/return, quality stock-in — are synced to Kingdee Cloud Skylink in dependency order, achieving a closed loop through virtual materials, virtual warehouses, code mapping, and phased scheduling.
Qeasy Data Integration Platform delivers comprehensive data lifecycle management capabilities, covering the full process of data ingestion, processing, archiving, and deletion. DataHub enables enterprises to standardize integration data management through configurable policies and automated execution, reducing storage costs while meeting compliance requirements.
一份"看起来对完"的电商对账 Excel，往往掩盖了 35% 订单的真实差异——它们账面平了、钱却没真的对平。50 家中型电商财务团队的调研显示，**78% 的失败订单集中在 5 类陷阱**：数据时差、补贴扣点、退款倒挂、跨期结算、平台代扣税。本文给出每个陷阱的失败占比、CFO 视角的判定纪律，以及"假对平"与"真对平"之间的工程化分界线——把对账从「判断题」升级为「选择题」的 5 个现实门槛。
亚马逊 Subscribe & Save 订阅服务在 2026 年跨境家居 / 母婴 / 美妆品类的复购率贡献占比 28-42%，但它的财务对账远比普通订单复杂——同一订阅下的不同配送周期（月付 vs 周付）、3 类折扣的叠加（阶梯折扣 + Coupon + Bundle）、跳过订单（Skip）与取消订阅（Cancellation）的两条出口判定，都是境内电商看不到的特殊场景。本文以订阅订单的「分向聚合 × 折扣叠加判定顺序 × 无单守卫 × 跨期归属」为 4 条主线，拆解 Subscribe & Save 对账的工程框架，给出 5 个反直觉结论与 5 步走的实操建议——为订阅订单占 GMV 20%+ 的跨境品牌财务经理提供一份"4 主线 × 5 反直觉 × 5 步走"的操作地图。
最近三个月，业务一线咨询「AI Agent 能不能帮我写脚本」「沙箱安不安全」「能不能撤销」的问题集中在 4 类：能力边界、工作流、安全、知识库。本文按这 4 类递进，挑出最高频的 10 个问题逐条作答——读者可跳到对应编号阅读，也可从头串读。每一问都对应代码里的真实落点，不是 PPT 上的承诺。
2026 年某美妆集团年 GMV 18 亿，月均平台补贴收入 320 万元——因为「自营券 / 平台券 / 联合立减 / 抖音支付补贴 / 平台月付贴息」5 类补贴全走了「冲减主营业务收入」的口径，1 年下来少缴企业所得税 86 万元。稽查认定为**「人为调节收入与成本，影响企业所得税与增值税销项税」**——补缴税款 73 万元、滞纳金 12 万元、罚款 21 万元，合计 106 万元。**平台补贴的会计处理不是「随便挂个销售费用」那么简单**，而是「补贴性质 × 承担主体 × 业务实质 × 税务衔接 × 凭证链路」5 个维度同时越线才算违规。本文把 5 类常见平台补贴拆成「准则条款 → 总额 / 净额判定矩阵 → 23 标签码映射」3 段，给 CFO 与税务经理一份在稽查现场能直接拿出来用的判定手册。
This guide unpacks a specific supply-chain integration strategy: pushdown sync of purchase receipts from a frontline OMS to an ERP. It covers data flow, field mapping, key configuration points on Qeasy, phased rollout, and five common pitfalls we have seen in real customer projects.
