Microsoft Dynamics AX (Archived)

AP Payment Export File Format (csv)

(0) Share

Report

Posted on by Tremor Olaes

2,147

Is there a way to export payment file as csv format in AX?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Why do you need that as csv?

Usually the banks define the file format they need.

Would be great if you could explain.

Thanks

Ludwig

Was this reply helpful? Yes No
Tremor Olaes 2,147 on at

Like (0)

Report
Copy link

Link copied!

We have a new initiative to provide payment information for Virtual Card payments. The bank we are working with requires a file that looks like this:

H,1001,ACMECO

P,1,1227760,06112014,196.00,840,UNITED VAN LINES,56565,07302014,accountspayableshared@acmetestco.com,VND123224

D,1,7548,98.00,P100,06/09/14

D,1,654,147.00,P200,06/10/14

D,1,946,196.00,P300,06/11/14

D,1,6548,(245.00),P300,06/11/14

P,2,1227761,06112014,792.00,840,OFFICE MAX STORES,56565,07302014,accountspayableshared@acmetestco.com,VND105455

D,2,3548,123.75,P100,06/09/14

D,2,378,173.25,P200,06/10/14

D,2,312,222.75,P300,06/11/14

D,2,444,272.25,P300,06/11/14

T,12,988.00

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

In AX2012 you have to develop this format yourself if it is not one of the already available ones.

The standard formats I am familiar with create usually txt or xml files but no csv files.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

hi Tremor,

Take a look at link below and see if this helps.

microsoft-dynamics-ax-erp.blogspot.com/.../electronic-vendor-payments-in-ax-2012.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello, Just wondering to see if you found any solution for this?

Was this reply helpful? Yes No