cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Movement Report

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

stefan_resag
Employee
Employee
0 Kudos

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

Former Member
0 Kudos

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.

stefan_resag
Employee
Employee
0 Kudos

Hi Jae,

I was more thinking of using the material ID as join criteria.

Best regards,

Stefan

Former Member
0 Kudos

Hi Stefan,

Material ID has also been used as one of the join criteria, but the results still isnt expected as I would get some duplicated entries instead due to the confirmation journal having more entries due to the changes in logistic area.

stefan_resag
Employee
Employee
0 Kudos

Hi Jae,

you have to filter out all those movements in the confirmation journal that only belong to internal movements. Only those movements are of interest, that increase or decrease the inventory on site level.

Best regards,

Stefan

jasmin_schaad
Explorer
0 Kudos

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

stefan_resag
Employee
Employee
0 Kudos

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

Former Member
0 Kudos

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?