PL open items extract direct from the SQL DB - AX9

(0) Share

Report

Posted on by alan.cook@kaleida.c...

I need to export the PL open items that are the same as the open invoice transactions report from the Purchase ledger. I need to take this straight from the SQL database. Has anyone got an extract script that works, please?

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: PL open items extract direct from the SQL DB - AX9

Hello alan,

The vendor account statement report includes all the information you are looking for.

- it includes the supplier

- it includes the transaction date

- there is a parameter to filter by open transactions

- you can filter by transaction type such as payments, purchase orders, etc.

- you can even select a parameter to show you the offset account.

Have you checked whether this standard report might fit all your requirements?

Best regards,

Ludwig
alan.cook@kaleida.c... 15 on at

Like (0)

Report

RE: PL open items extract direct from the SQL DB - AX9

Hi Ludwig,

Thanks for the initial response.

I want to see the Purchase Ledger account balances. So as of today's date, I want to extract by the supplier, and show by supplier, by transaction date any transaction that appears in the Purchase Ledger that is deemed as unpaid (Open), I also want any items where any payment has been made to the account, on account. I need the information at line level if possible. I need the balance amount in currency (GBP) to be the same from the extract and the balance amount in currency from the Open Invoice Transaction report in AX9.

Hpe that helps.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: PL open items extract direct from the SQL DB - AX9

Hello Alan,

Does 'PL open items' refers to ledger account balances?

What is it that you try to do here exactly?

Would be great if you could describe in more detail.

Thanks,

Ludwig