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