Report for audit

Hello everyone,

This is my first post here, I think forum is great.

I have a request from auditors to deliver report in form like below:



Ordinal Number



Field Description



Field Type



1



Account code



Character



2



Inventory code (unique identifier)



Character



3



Inventory name



Character



4



Warehouse code



Character



5



Warehouse name



Character



6



Unit of measure



Character



7



Opening balance - quantity



Character



8



Input quantity - cumulative



Numeric



9



Output quantity - cumulative



Numeric



10



Quantity balance



Numeric



11



Opening balance - value



Numeric



12



Input value - cumulative



Numeric



13



Output value - cumulative



Numeric



14



Balance



Numeric

Is there AX report similar to this, or report should be created? The main problem here is to provide account transactions per item numbers.

Thanks in advance