Accounts Payable data (AP) in AX 2012 R2/R3

We need to pull Accounts Payable (open transactions only) - what is the best way to do this? ideally if this can be a batch job, it will be great as well.

Also, I wonder what would be the best way to do this in Dynamics 365 Operations? Thank you

What exactly do you mean by “to pull Accounts Payable”? And why is the title “… in AX 2012 R2/R3” if you’re asking about Dynamics 365 for Operations? Please clarify.

Hi Martin, I meant for extracting some fields from the open AP transactions records for AX 2012 R2. Also I have D365 Operations instance as well in addition to on-premise AX 2012 (these two are not connected to each other) that I was wondering what would be the best approach.

If you want to export data from AX, use the Data Import Export Framework (DIXF). In Operations, it’s based on an important new concept: data entities.

Automation is a bit more complicated in cloud - please refer to Recurring integrations.