Hello, Epicor ERP 9.5 user here!
Has any got a ABL query output to CSV file Epicor 9.5
I found the below ABL code but did not work.
Example of outputting to an Excel .csv file: from MES Button
MESSAGE "Purchased Parts: " ct
VIEW-AS ALERT-BOX.
Error i get is ----
** Unable to understand after -- "company.company". (247)
** C:\Epicor\EpicorData\6322396891617321725036161871067172191120.p Line 24 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)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.
Has any got a ABL query output to CSV file Epicor 9.5
I found the below ABL code but did not work.
Example of outputting to an Excel .csv file: from MES Button
MESSAGE "Purchased Parts: " ct
VIEW-AS ALERT-BOX.
Error i get is ----
** Unable to understand after -- "company.company". (247)
** C:\Epicor\EpicorData\6322396891617321725036161871067172191120.p Line 24 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)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.
Last edited: