首页 > 解决方案 > Epicor - ABL 导出到 excel

问题描述

Epicor ERP 9.5 用户在这里!

是否有任何将 ABL 查询输出到 CSV 文件 Epicor 9.5 我找到了以下 ABL 代码但没有工作。输出到 Excel .csv 文件的示例:从 MES 按钮

Find first company no-lock no-error.

DEF VAR ct AS INTE NO-UNDO.

Output to c:\temp\part-purchased.csv.

Export delimiter ","
"Part Number"
"Description"
"Type Code"
"Cost Method".

For each part no-lock where part.company = company.company (use CUR-COMP
if using from a BPM)
and part.typecode = "P".
ct = ct + 1.
export delimiter ","
part.partnum
part.partdescription
part.typecode
part.costmethod.
end.

Output close.

MESSAGE "Purchased Parts: " ct
VIEW-AS ALERT-BOX.

Error i get is ----

** 后无法理解 -- “company.company”。(247) ** C:\Epicor\EpicorData\6322396891617321725036161871067172191120.p 第 24 行 -- FOR、DO、REPEAT 或 EDITING 语句无效。(194)

标签: epicorerp

解决方案


推荐阅读