Vendor balance list on details level

(0) Share

Report

Posted on by Community Member

Hi,

Vendor balance list on details level, does anyone know how to get the info? All corrections, FCR , payments and credit note should be included.

Thank you very much for your support

Kacper

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Community Member on at

Like (0)

Report

Hi,

Report but if the report doesn’t exist than form will be fine

Was this reply helpful? Yes No
Suggested answer

ZvikaR 168 on at

Like (1)

Report

did you look at "Vendor Statement" report?

what kind of details you do not find there?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

looks good but I need use this report to migrate data from one system to another. Account statement contains too much vendor master data and I am looking just only for account , invoice and amount per particular date

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

there are many forms and reports available in AX,

based on your requirements you can use one of them.

you can use vendor balance list, vendor balance list with credit limit, account statement , vendor aging reports

also, you can check all vendors list page form,check vendor balance form in tab vendor

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I already checked reports you mentioned. Let say that vendor X has a balance -100 Eur per 20180410. I would like to see which transaction create this balance. I would like to create report that contains all info like: invoice, credit note in etc for all vendors.

Account statement is good but the format is terrible.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

you can check All details in transaction form, and transaction report

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

let says that vendor balance is 100 $. I would like to get a report what kind of transactions create this balance. This report will be used for migration purpose. Accoun statement is good but the format is terrible

Was this reply helpful? Yes No
Suggested answer

ZvikaR 168 on at

Like (0)

Report

I think looking for a report is probably not the best direction.

If all you need is raw data you can transform for Excel in order to use in data migration, I would try going to "Open AP invoices" inquiry screen, and export the content of that list into Excel using the "Excel" button on the top right corner

Was this reply helpful? Yes No