kingdee_query_purchase_orders
Query purchase orders from Kingdee ERP with filters for status, supplier, date, and more. Retrieve key fields like bill number, date, supplier, and amounts.
Instructions
查询采购订单(PUR_PurchaseOrder)列表。
常用 filter_string:
已审核: "FDocumentStatus='C'"
指定供应商: "FSupplierId.FNumber='S001'"
指定日期: "FDate>='2024-01-01' and FDate<='2024-12-31'"
未关闭: "FCloseStatus='A'"
业务正常: "FBusinessClose='A'"
推荐 field_keys(默认已包含关键执行字段): FID,FBillNo,FDate,FDocumentStatus,FSupplierId.FName,FPurchaseDeptId.FName, FTaxAmount,FAllAmount,FReceiveQty,FStockInQty
注:FTotalAmount/FLinkQty/FBusinessClose 等字段在 demo 环境可能不存在, 如需关联数量,请用 FReceiveQty + FStockInQty 代替,或用 kingdee_get_fields 确认可用字段
关联数量业务规则:
关联数量 = 累计收料数量 + 累计入库数量
关联数量 >= 订单数量时,采购订单无法下推收料单/入库单
勾选控制交货数量时,关联数量 >= 交货下限时无法下推
Returns: str: JSON 格式的采购订单列表
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |