on 01-20-2016 10:26 AM
Dear All,
Has anyone come across a report that shows the inventory in and outs which includes both quantity and the cost? As I couldnt find any relevant reports in the system, and have been trying to create 1 using the confirmation journal as the base, but it doesnt seem sufficient as I couldn't get to match it to get the inventory valuation for each detail line.
Would appreciate some guidance on creating an inventory report that could report the movement with quantity and cost involved, also if possible I would like to match the supplier and customer invoices for each In and out. Hope that someone could share some ideas with me. Thanks
Hi Jae,
I detected two other report data sources, which you should try to combine:
- Confirmation Journal contains all inventory movements. You have to filter to those who are relevant to you. It also contains internal movements.
- Material valuation data contains the costs, but keep in mind, that this is time dependent data.
Best regards,
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Stefan,
Thanks for your advise, I've been trying to join these 2 data sources into one. But there seems to be some issue as if I try to join say for example, the Conf.ID and Source Document ID as both are actually a possible link, but the end results is that the system isn't able to show any data, unless i remove those 2 as a join criteria.
Hi Jae
Maybe the report "Material Inventories - Line Items" fits to your requirement.
This reports shows all posts for material inventory.
May you have to order the column, so date is the first one.
Regards
Jasmin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jae,
please take a look at the 'Material Inventory - Balance History' report in the inventory valuation WoC. It shows all quantities in and out of a warehouse for a certain period in quantity and value.
Best regards,
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Stefan,
Thanks for your reply, I've looked at this report previously but it doesn't seem to suit my current process requirement as I would need to look at the in and outs per transaction basis, which also require to show the total in and outs for each days. With the material inventory balance history, I can only have an overall picture. Is there a report which shows the detail level of the material movements?
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.