Announcements
HI,
I want to have inventory report similar to the below example
Site | Site_01 | |||||
Warehouse | Finshed Goods | |||||
Date | 01.04.2020 - 30.04.2020 | |||||
Item Group | Item Code | Item Name | Opening Stock | Received | Consumed | Closing Stock |
Furniture | TB_001 | Table_Dining | 0 | 32 | 30 | 2 |
Furniture | TB_002 | Table _Desktop | 15 | 28 | 9 | 34 |
Wardrobe | WB_001 | Kids Cupboard | 0 | 25 | 3 | 22 |
Appliances | FN_001 | Fan_Ceiling | 25 | 30 | 19 | 36 |
I found a report from the AOT under Output Menu Item with name InventStatusInPeriod_CN.
does this meant for China or is it a global one.
please suggest
Regards
Sriram
Hello Sriram GS,
Good to know that the case is solved and thanks for the feedback which is important.
Appreciate if you kindly verify this thread so that it could be helpful for community members to refer this thread for any future need.
Best regards,
Sourav Dam
Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.
Hi Ludwig,
We found a inquiry table " InventstatusInHand_CN" for on Hand Transaction customised for the China and Janpan.
We made few changes in the parameters and enabled the same in the inquries form under inventory and management.
Wiht this we can view the status of an item / Item group for a period with item dimensions , we can drill down the transaction of the item for the period specified. and also Print the report.
Issue Solved......
Hi Sriram GS,
I only know of this Chinese report. Yet, as far as I know this country-specific report cannot easily be made available for other countries because there is more than only a country key that would have to be changed.
Unfortunately, there is not really a comparable report available I am aware of. What you can do as a kind of workaround is running the inventory value report with all the parameters enabled to get the closing and consumed information.
Please have a look at this post and the parameters that are available for the inventory value report. dynamicsax-fico.com/.../ If those parameters don't give you all the information and separation needed, you would have to create your own custom designed report.
Best regards,
Ludwig
Hello Sriram GS,
Looks like this is a country specific report for which you may need to enable the country specific feature key in your environment.
However; let's wait for other member's input on this to take it forward.
If that is fine, then you can try this first in Dev before applying in PROD.
Best regards,
Sourav Dam
Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.
André Arnaud de Cal...
293,309
Super User 2025 Season 1
Martin Dráb
232,162
Most Valuable Professional
nmaenpaa
101,156
Moderator